One of the most useful functions in the OGwin program is The Report Writer. It gives you the ability to create customized general ledger reports and offers an unlimited number of user-defined report formats to meet your varied reporting needs. You also get run-time options that affect how the data is presented in your reports. Below are some of the options and how they can help you get the information you require:

Property Selection Filters
Both the Financial Report (Report 230) and the Property Report (Report 250) allow you to limit the report to certain properties. When this option is enabled, you may select the properties to be included by selecting “All Wells,” “Single Well,” “User-Specified Well,” or “Wells Selected for AFE.” The User-Specified Well Selection allows you to select the wells to be included in this report through well fields that are used as data filters.

OGwin uses two types of well fields for filtering—default well fields and user-defined well fields. Default well fields can include “Billing Suspended,” “County,“ “Operating Group,” “Revenue Suspended,” “Search Key,” “State,” and the “Well Code” itself. You may view these options in the well-selection window.

Look for the user-defined well fields in System Parameter Maintenance. They are shown as “Short Well Fields.” Short well fields are set up and populated in the Well Maintenance – User Fields window. Once these fields have been set up, they also will appear in the selection window. When you select a well field, you must supply the criteria for that field. For example, you can select by State if you enter valid state codes and add them to the selection criteria.

Sorting Fields
You can use these same well fields as sorting criteria. Sorting determines the sequence of the wells in the report and simultaneously sub-totals the data. For example, when you sort a well report by State, you get a list of wells segregated alphabetically by state, with sub-totals for each state.

AFE Selection
Check out the option for an alternative selection method – by AFE criteria.
When you enable this option, you may filter the report data by “All AFEs,” “Single AFE,” “User-specified AFE” or “Batch of AFEs.” The User-specified AFE selection includes these AFE fields: AFE Code, Operating Group, Search Key, and Well Reference. (This feature requires you to enable both the AFE option and the AFE Selection option. Contact OGSYS System Support to request these options.)

Extra Information
When you require additional well information on a property report, use the Extra-Information feature to format the information to be included. First, use Master Maintenance\Property Maintenance\Extra Information Maintenance to create an Extra-Info Batch. Supply the Extra Info [batch] Name and Retrieve. Use the drop-down menu for Selected Info to view the list of available items to be added to the batch. These items can include any of the six well master Comment Lines, the County, State Name, State Code, Well Name, Operating Group Code, Operating Group Name, Legal Description, Company’s Revenue Interest, Company’s Expense Interest, Search Key and Shutin status. In addition to these items, you can also include the user-defined well fields as extra information. OGwin includes a well’s “extra information” for each well on the report on an additional line.

Detail Months to Print
The Property Report includes an option to specify the number of “Detail Months to Print” for each well. When more than one month is selected, OGwin displays the detail for the well for each month requested with a balance forward, a well total, and a monthly average for the period selected. The date formula in the property format must be equal to or greater than the number of months requested in the report.

Drill Down
And finally, the Financial Report and Property Report include a drill down feature that allows you to “drill down” or “back-track” through the entries that make up a balance on the report. You can trace these entries as far back as the journal entry to view and verify entries posted.

When you request the report, choose from several options for the Drill Down Output Selection. Select “Print Only,” “View Only,” or “Print and View,” then customize the output through sub options available under the View Selection group. Select “View Deferred” and enter a valid path and file name. To view the report and begin tracing entries as far back as the journal entry, select “View Immediately.”

The Financial Viewer allows you to save the report to a file before closing the report. Enable “Include Zero-contributions in Reference” in order to gain the ability to click zero balances on the report for the purpose of viewing accounts and entries that contributed to the zero balance. Enable “Include Calculated-Amounts in Reference” to view all the accounts that contributed to a calculated amount (such as a sum) in the report.

If you do not immediately see the drill-down version of the report, use the Financial Viewer found on the General Ledger Reports menu to view the report for Drill Down. Supply a valid path and filename to load the report for viewing. Click any of the amounts shown on the report, then click the “Drill Down” button to display a listing of accounts that contributed to that amount from the first level. To display any entries that contributed to the selected amount, click one of the amounts at this second level. Continue to “drill down” until you reach the final level—the original journal entry.

Note: An alternative technique for executing a drill down is to double click an entry (rather than clicking an amount, then the drill-down button). Remember, choosing the Drill Down option may actually lengthen report generation time by four to five times.
OGwin Features

Shortcuts
You may setup access to frequently used programs called “shortcuts.” Establish shortcuts in the System menu under ‘User Preferences.” OGwin allows you 20 shortcuts unique to the user name. They will appear on the Shortcuts menu and on the Shortcuts toolbar.

Quick Codes
The program uses a three- to four-character code assigned to each application in the database. The codes are either initials of the application, or (in the case of reports) the report number. You may enter the code in the direct access box. Retrieve the box through the Shortcuts menu, the Standard toolbar yellow-maze button, or by hitting the F2 key at the main OGwin screen. The direct access box provides a scan button to review and select from the list of applications and their codes.

Enter vs.Tab
The function key that moves you from one field to another is Tab. However, in some situations, using the Enter key may be more useful. In these situations, it’s good to remember that OGwin provides an override to allow Enter to respond as Tab.

To activate this feature, go to the System menu to User Preferences, and click the file folder tab for Custom Actions. The “Enter as Tab” feature is on the upper right side of the screen. Click the Activate button; check the top box “Change Enter to act as TAB, except for push buttons”; then click the Recommended button. After this initial activation, you may turn “Enter as Tab” on and off by clicking the red arrow button on the standard toolbar.

“Enter as Tab” was designed for the entry screens of AP invoice, AR invoice, AR payment, purchaser check, and journal. You may find it does not respond well in grid type screens.

Answers to Key Questions

Q: Our company is responsible for remitting tax to the state. How do I handle this in OGwin?

A: Go to the Purchaser Check Control Maintenance (check mask) found on the Master Maintenance/Revenue menu. When defining the taxes on the check control information screen, flag the taxes your company is to remit as generated. This will book a taxes payable amount when the purchaser check is final posted. You will reduce the taxes payable account on the entry recording payment to the state.

Q: I input and final posted an AP invoice with a mistake. How do I correct this?

A: The rule of thumb in OGwin is to correct a mistake where it occurs. Reverse the original invoice through AP invoice entry. Use a different invoice number (maybe the original number with an “R” at the end). OGwin will prompt you to model from an existing invoice. Answer “Yes” and input the original voucher and invoice number. Basic information from that invoice will appear along with the buttons Exact Copy or Reverse. Click “Reverse,” and the system will copy the original invoice and give every entry the opposite sign. You may then model another invoice, use Exact Copy, and make the necessary changes to amounts, dates, etc. Final post the entries.

Q: I would like to prioritize the running of my OGwin reports. Is this possible?

A: Yes. When you setup the report and click “OK,” you receive the output options screen. Click the tab called “Task Schedule,” and look for an area for task options on the right side of the screen. Set a priority of 1 – 5 on a report. To apply this priority, also check the box “Run Alone on the Station;” otherwise multiple reports will run with this report and may complete before a higher priority report.