Download newsletter

Throughout our 25-year history, many clients have requested custom programming.
When we reprogram OGSYS, we make all changes available to our client base. You see many of them in our regular system updates. When a custom programming request is more specific, we assign it an option number to make it available to all clients.

Options fall into two categories: (1) formatting and (2) extra cost functions. You may directly manage some formatting options — like JIB formats — through Site File Utility on the Supervisor menu. Activation of some formatting options requires a file from OGSYS support.

Extra-cost options include OGwin add-on modules, such as Lease Records, Production, Fixed Assets, and Inventory. Subledger upload functions, such as CDEX and AP Invoice upload (as well as some additional reporting capabilities like Net Distribution reports and the OGsql reporting module), also are extra-cost options.

To receive an updated options list, please email .

Whenever you make changes to the Site File Utility, email OGSYS support including your company name and the option you turned on or off. This will prevent the loss of the option setting when future releases are loaded against OGwin.

OGwin ‘Loaded’ with Upload Tools

Take advantage of OGwin’s many built-in upload capabilities. You may upload a journal entry, an AP invoice, budgets, and many more items.

OGwin requires a certain layout for the upload files. Therefore, we have recently created Excel macros for various system uploads. You will find these macros and related instruction documents on our Upload Tools page.

Right-click on a specific spreadsheet and save it to your system. Do not enter your data directly into the spreadsheet on our website.

OGwin 2.0 – New Opportunities in Revenue Redistribution

OGwin allows the redistribution of revenue from one owner to another or from one owner to a company (not from a company to an owner.) With the new 2.0 version, you will see some changes to the Revenue Redistribution program.

You also may redistribute revenue by creating temporary decks with the new and old owners and posting negative revenue amounts to one deck and positive amounts to the other. Revenue Redistribution works only between outside owners.

OGwin will not allow use of Revenue Redistribution to reduce a company’s share of revenue.

OGwin will not allow redistribution in cases when an owner has been netted or had a partial payment made against the revenue you wish to redistribute. Use the Unpaid History entry to make this change. Call OGSYS Support for procedures if netting has been done.

To redistribute an owner’s revenue:

• Select NEW [F3 key] for a new voucher number. OGwin 2.0 introduced the use of a voucher number with redistribution.
• Enter the owner code.
• Complete the Revenue Selection window for the redistributed items. (You may filter the items to be redistributed by well, product, deck, production month ranges, voucher, interest type and payment type.) Then click RETRIEVE

  

• The Selected Revenue Items tab will show all items to be redistributed. Use the Del Line button to delete individual lines that you do NOT want to be redistributed. OGwin will display the total amount to be redistributed as “Total Payable.”

  

• To create a reversing entry in a memo company for each line to be redistributed (not just the lines with an entry in the MemoAlso column), enter a company code in Memo Comp. If a revenue item was associated with a memo company at the time of posting, that memo company code will be reflected in the MemoAlso column. The Memo Comp replaces that MemoAlso code for those revenue items.
• Specify one or more owners or companies to receive the redistribution of the revenue item(s) being selected. Click the Target Entities tab to enter the owners and/or companies to receive the redistribution. Click Add Line. Enter the owner or company code. The program does not allow code duplication. To remove an owner or company from the screen, select Del Line. OGwin assigns a share of the revenue according to their share of the total decimal interests of all owners or companies on this screen to each of the owners or companies.
• OGwin calculates this share by the formula:
  Revenue * (Their-Decimal-Intr / Total-Intr-on-Screen)
  One simple way to use this formula is to enter each owner or company’s share of the well.
  Example: Suppose you wish to replace one owner having a 20% share with three owners having shares of 10, 6, and 4%.
  Simply enter the decimal interests as .1, .06, and .04, and the program will assign the three owners a proportional share of the existing revenue. To calculate the percentage of the total to be redistributed to each of the owners/companies listed, click the Scale button.

  

• OGwin will prompt you to enter the new owners/companies and their relative percentages. IMPORTANT — If the original owner is to retain a portion of the revenue, you must list them with the percentage to be retained. In the example below, owner 105200 is retaining a 50% interest in the revenue. The remaining 50% is to be redistributed to owner 100000 and 100007. To also show the amounts to be redistributed in a memo company, enter the memo company code in the Memo space.
  
• The sample (above) shows the revised percents after you click the Scale button. OGwin will redistribute 100%, according to the owner’s percentages; the total should be 100%. OGwin will not show an amount for redistribution if it has been netted or otherwise adjusted. The program allows redistribution only of the original amount.
• To allow users to specify a well/deck for redistributing the items, use the Target Deck tab (new in version 2.0), rather than listing individual owners/companies. This is useful particularly in instances where the true ownership was originally unknown and a “dummy” owner was specified. Once you determine the ownership, use the Target Deck tab to select an expense deck to specify the ownership percent to redistribute the “dummy” ownership interest.

  

• Specify the payment type of the newly redistributed revenue. Select “Same” (same as the original revenue item), “Fully Payable,” “Suspended,” or “Suspend Code” (1-9).
• Indicate if revenue redistributed to a company should have the gross volumes and values suppressed in the company’s general ledger. This is useful if the company already has an interest in the well’s revenue to prevent duplicate gross amounts in property reports. This is new in version 2.0

  

• To save your selections, click “Save.”
• OGwin may display the message shown below if any of the revenue items show ??? in the MemoAlso company column on the Selected Revenue Items tab. The message indicates that some revenue was posted in an earlier release of OGwin and allows the user to choose whether to reverse revenue from a memo company. To enter a Memo Company, enter “No.” To proceed without entering a Memo Company, enter “Yes.”

  

• Go to Post Revenue Redistribution (new in version 2.0). Select the appropriate Report Version to trial post, then final post the redistribution. Select Audit-Listing to print the G/L detail reports.

  

In OGwin 2.0 service pack 6/28/07, you gain the new capability to suppress cross clearing, while running the netting process. (Cross clearing is clearing a credit AR invoice for an owner against debit AR invoices. Netting is applying Revenue for an owner to AR invoices.)

When you apply the pack to your database, a new checkbox will appear in Owner Maintenance, “No A/R Cross Clear during Rev. Netting.” If the box is checked, the owner will not have any AR credits cleared against AR debits. All existing owners, as well as new owners will default to the box unchecked.

NOTE: If you loaded OGwin 2.0 service pack 4/26/07, this feature was handled with a dropdown list in Owner Maintenance for the Net Rev vs. Exps field.

Load the 6/28/07 patch for the more simplified checkbox.