EDI Viewer - Saskatchewan GL Upload Window

EDI Viewer can create a GL Batch file for importing to your accounting system.

Before trying to create the GL Batch file, make sure you have done the following 2 steps:

  1. Open the SK Cost Center Maintenance window (CC on the toolbar) and Retrieve data for any company. This inserts new wells into the cost center table that are not already in there. They will have empty cost centers that you will need to enter before creating your GL Upload file. Any well with a blank cost center is not included as part of the upload file.
  2. Make sure you have setup your GL Accounts in the GL Accounts Maintenance window.

Procedures to create the GL Batch File are:
  • Pick a Company Code from the list box at the top of the GL Upload window.
  • Pick an Invoice from the list box at the top of the GL Upload window.

  • Include Provisional Royalty as 1 Line Entry - choose whether you want to include an entry for Provisional Royalty in your GL upload file. You must have imported the Provisional Royalty file first and setup a GL Account for Provisional.

  • Include Non-Compliance as 1 Line Entry - choose whether you want to include an entry for Non-Compliance in your GL upload file. You must have imported the Non-Compliance file first and setup a GL Account for Non-Compliance.

  • Include Compensatory as 1 Line Entry - choose whether you want to include an entry for Compensatory in your GL upload file. You must have imported the Compensatory files first and setup a GL Account for Compensatoryl.

  • Freehold Volumes - choose how you want Freehold Volumes to appear in the GL Upload file.

  • Suspense Entries - if EDI Viewer cannot find any matching entries for the Previous Calc amount, checking this box will create an entry for the Previous Calc amount booked to the Suspense account type. You must setup a Suspense account type in the GL Accounts Maintenance window.
    If EDI Viewer can find matching entries for the Previous Calc amount, it will reverse these original entries.

  • Unit Invoice Amounts January 2013 and after - For January 2013 and after, unit wells will have dollar amounts on the invoice. Prior to this, they were always zero. You can choose to keep this the same as it always has been (Create using Unit Cost Centers) or now create your entries at the Unit Well Cost Center lever by clicking Create using Unit Well Cost Centers. Only choose this option if your Unit Wells do have valid cost centers.

  • GL Batch Header - this will change depending what financial system you are using. Fill in your information.

  • 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.
    Always end your filename with .txt as in the example below.
  • 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 Wells without cost centers in your system. 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 wells without cost centers and your batch file will not balance.


    Click Yes to continue and create the GL Batch file.

  • When the GL Batch file as been created, run the GL Batch Summary and Detail reports on the GL Reports tab to make sure the batch is balanced and all entries will be transferred to the financial system. If the batch does not looked balanced, you can create the GL file as many times as you need.

    There are usually 2 reasons the GL Batch may not be balanced:
    1. There are wells that are missing cost centers. Wells missing cost centers are not included in the upload process.
    2. You may be missing a GL Account for 1 of the GL Account types, eg. if there is no gl account for Freehold,
    no Freehold entries will be included in the upload file.