EDI Viewer - GL Upload Window


EDI Viewer can create a GL Batch file for importing to your accounting system. The batch file may consist of:

The GL Upload process is :

Procedures to create the GL Batch File are:
  • Pick an Invoice number from the list box in the top left corner of the GL Upload window.
  • Pick a Company Code from the list box. - If you do not see the Company Code list box, you do not need it.

  • Choose the GL Entry options. Set the options for creating your GL Batch by clicking on the check box. The options are:
    • Gross Royalty and Unit Operating Cost - check both to create entries for all Crown Royalty and Injection Credit charges on the invoice. You must setup charge code 996 on the GL Account Xref window to create charges for UOC's.
    • Net Royalty - create entries for all Crown Royalty, Injection Credit and Enhanced Oil Recovery adjustment charges on the invoice.

  • Set the Volumes option by clicking the appropriate check box:
    • Default volumes: is a volume you choose and type in the text box. This volume will be associated with each product in the batch file.
    • Crown volumes: the volumes on the invoice will be included on the GL batch file for each product that is assigned a GL account.
    • Calculated volumes: the EDIviewer will calculate volumes based on the invoice gas reference price, client heat, client volume, and net royalty for each product. When required the MJ factor (megajoule factor), that you type in, will be used to calculate volumes.

  • Create Suspense Entries - a one line summary or a line per stream will be created for all invoice streams that do not pass validation. A GL account 994 (Streams without Cost Centers) is required in the Product Cross Reference window for these entries.

  • Create GL Entries - check Streams for stream level entries and Facility for facility level entries (default: stream level).

  • Create Provisional Assessment Entries at Facility Level - check this to create Provisional entries using cost centers at a facility level.
    If you plan on using this, you must setup facility cost centers on the Facility Cross Reference window (Facility Xref on the toolbar), as well as a Provisional Assessment GL Account for each product. If you do not intend to use this, only create 1 Provisional Assessment GL Account.

  • Condensate - check this option if have imported the Condensate CSV file and want the condensate details by cost center included with the other Crown Invoice entries.
    Leaving this option unchecked will give you a 1 line entry for Condensate.

  • Otherwise Flared Solution Gas - check this to have crown royalty charges reversed for OFSG streams.
    Use the Stream Id Cross Reference window (Stream Xref on the toolbar) to mark which streams are OFSG streams.

  • CCA / CP / UOC / AC Restriction entries - toggle whether you'd like to book entries at a Facility or a Cost Center level. If you choose facility level, you must setup facility cost centers on the Facility Cross Reference window (Facility Xref on the toolbar).

  • Pick a Directory and filename click on the Directory button and navigating through the pop up window to the desired file location. Type in a file name and click save; the GL Batch file will be created and saved in this location under the name you give it.
  • Click the Create GL Batch File button to start the process. You may see a warning message appear, like the one below, indicating there are streams without cost centers in your system or products without GL accounts. This is only a warning and does not stop you from creating the GL Batch file, but you will NOT have GL entries for those streams without cost centers or for products without GL accounts and you batch file will not balance.