OGwin allows you to save up to 16 reports in XLS format for use with Excel. This versatile feature provides you relevant data as a basis for the simplest to the most intricate spreadsheet. Here’s a menu of OGwin reports you can save:

• 210 – General Ledger
• 212 – Trial Balance
• 230 – Financial Report
• 240 – Property Sub-ledger
• 250 – Property Report
• 330 – A/P Check Register
• 340 – A/P Detail Listing
• 430 – Revenue Check Register
• 440 – Revenue Suspense
• 520 – Production Reporting
• 640 – Aged A/R Listing
• 650 – Delinquency Analysis
• 830 – Capital Check Register
• OWM – Owner Master Listing
• PUM – Purchaser Master Listing
• VNM – Vendor Master Listing

• In the Output Options find “Send to”
• Select “ XLS File”
• Specify the File Location and Name to be used for this file
• Use the default extension of XLS so that the file is recognized by Excel as a file in the proper format.

  

  You may further customize the resulting output file using selections found on the “Customize XLS File” tab.

  

  These customizing selections allow you to convert the data and remove items that can become superfluous in an XLS file. Enable any of the following options by using a checkmark:
  

  • Remove Empty Lines – generates the report without empty lines
  • Remove Total Lines – generates the report without total lines
  • Remove Report Headings – generates the report without the usual report headings.
  • Change Categories To Columns – can be used only with a Report 230 and will cause the lines of data to be preceded by columns containing the category title
  • Ignore Page Breaks – generates the report without page breaks
  • Remove Text Lines – generates the report without text lines
  
  When you generate a report as an XLS file, the system holds a copy of that file in the Output Manager. To open the file using Excel, double click the file from the Output Manager. Use “Save As” to save any report to another directory (possibly an Excel folder).
  Note: OGwin will not recognize an XLS file unless your machine has Excel software.

  To send these XLS files via email, use the “Send Mail” button in the Output Manager.
  

Look Ma, No Mouse!

Even though the mouse is an essential and useful computer tool, sometimes it is nice to enter information without using it. Several OGwin features allow you to operate “mouseless” --

Enter as tab
Use this feature to enter data in AP Invoice Entry, Manual Journal Entry, Purchaser Check Entry, AR Invoice Entry, and AR Payment Entry. Just key in the data and press “Enter.” To activate the feature—
• In the System menu, select “User Preferences”
• Click the file tab “Custom Actions”
• Go to “ Key Action/Enter Key” section (top right on your screen) and click the Recommended button
• The system will check the appropriate boxes for the ideal setting of the feature

After the initial activation, turn the feature on/off using the Standard Toolbar button

Underlined Character
OGwin menus and buttons have lots of underlines. You may use the underlined letter in conjunction with the ALT key or CLTR key to activate the function. For example, the letter “P” is underlined in the word “Process” on the action line.

To open the process menu, simultaneously press the “ALT” and “P.” Once the Process menu is open, use the “Up” and “Down” arrow keys to move around on the menu . . . or type the letter that is underlined for the application you would like to access.

When you are in an entry screen, you may see file folder tabs for the different input screens. To access another screen, hold down “CTRL” and type the letter that is underlined on the tab.

There are usually several buttons available in entry screens. A dotted line will appear around the edge of a button when your cursor is sitting on it.

To activate the button, hit “ENTER.”

Function Keys
A number of functions keys are available in OGwin—
• “F4” opens the Output Manger
• “F5” opens the Task Manager
• “F3” takes you to the next available voucher number on all the voucher entry screens
• “F2” opens the search list for a field with search capabilities

How to Create Net Distribution History

An easy-to-use OGwin option — “Net Distribution” — allows you to create net distribution history and carry it over to a report for an owner. This useful function summarizes revenue and JIB detail by product, account, and well for each owner who is flagged to receive the net distribution statement.

Run the Net Distribution History Generate function after final posting revenue but prior to netting of revenue vs. expense and revenue check printing. When you are running the netting process or printing revenue checks, the system will warn you if history has not been generated.

When performing Net Distribution History Generate, you have options for setting up the posting date—you may choose between the “activity date’ and the “statement date.” If you opt for “activity date,” the system posts history entries in the journal date month for revenue and expenses. If you choose “statement date,” the system prompts for the month to use for the statement.

If you choose “statement date,” the system will post all revenue received and JIBs processed since the last generation in the statement month. Therefore, revenue will be posted based on the deposit date, and JIBs (since they are fairly current) will be posted based on the journal date.

If you want revenue posted based on the production month, choose “activity date.” The Statement Date selection should agree with the Revenue Summary Statements and JIB invoices for the month.

The reporting function allows six report variations. Three variations are for historical reporting, while three are for current period. Reports 425-01, -02, and –03 are the historical reports. Run them before or after the check print and netting. To produce the reports after check print or netting, you would have run the history generate. The historical reports use a property format in combination with the programmed report layout. The columns in the format must call for net values.

Reports –04, -05, and –06 are the current period reports. You must run these after the final A/P, JE, and Revenue postings but prior to the Net Distribution History Generate. These reports will print information for the current period revenue and expense.

Contact OGSYS support for cost and additional information on the Net Distribution Reports.

The Doctor is IN

Q: Is it possible to turn off the system minimize feature, so I don’t have to continue to enter my password?

A: Yes. Here’s how your Supervisor can get the job done—
• From the Supervisor menu, select Station Maintenance
• Click the Options button.
• Locate the appropriate station ID
• Click the Change button
• Find a check box (right side of screen) for “Minimize and require password when idle”
• Set the minutes to “0” (zero) and
• Uncheck the box

Q: In deck maintenance, I noticed there are two codes for each interest type — W or X for working, R or E for royalty, and O or N for override. What is the difference between the two codes?

A: There is no difference. Within a deck, an owner may have only one of each interest type. In some cases, you may need to have two of a single interest type for the same owner. Therefore, OGSYS has established two acceptable codes for each type. An owner code may have two of the same type of interest using the two codes. There is no difference in the recording of the entries to the owner.

Q: What controls the default date for reports like the AP Detail?

A: The system date controls it. Prior to the 15th day of any month, the system will default to the prior month. From the 15th day to the end of a current month, it will default to the current month. For example, suppose the system date is “7/10/06.” The default report date would be “6/30/06.” Suppose the system date is “7/15/06.” The default report date would be “7/31/06.”