GL Imports

GL Imports


GL Tab

Select New (If nothing shows up in the pick list – if there are items in the pick list, choose any of them)

Cancel (out of create new group)

File -> Import External File

Choose NEW



Import Code: GL

Description: GL Import (Prepost Detail)

File Type: DBF (this is the only one I can get to work)

Save (Check)


Add GLPREPOST_DETAIL system table (upper right hand window)

Add IMPORT FIELDS:

GLACCT

  • Double Click on the sqk statement field.  Type in select id  from glacct where acct = '%s' 

DEBIT

CREDIT

DESCRIPTION

DATE

GLPREPOST_CYCLE_ID

  • Double click on the sql statement field.  Type in “select %f from dual”.  (Do not include the quotes


Save (Check)


.


You will need a DBF file that has the following information:

GL Account 

Debit amount (need amount or 0.00)

Credit amount (need amount or 0.00)

Date for transactions (Ex. 01/31/04 – a date you are posting for)  You will need to set the date format (Ex. mm/dd/yy) - optional

Reference (Ex. Jan 2004)


If you do this in excel, highlight the data (select) and do a save as .dbf (file type).  See additional workbook and note tabs for example data/formulas.


Each period needs it’s own dbf file.  (2004-1.dbf, 2004-2.dbf, etc.)


After you have a dbf file saved, note location because within the import external function you will need to find the file.


Open the External Import File template….see above

Go to File -> Open Import File

Find your dbf file and open it within the import window.




Match the import fields to the table fields.  Left click and hold down on the field in the import table window (bottom section).  Drag it up to the field that matches in the import field window (middle section)



​ ​ ​



After fields are matched up, click on the icon Load the import file to the system GL prepost table(s).




Choose a GL prepost date (should be within period you are importing)

In the example above I chose 05/29/04

When completed a confirm window showing import is done will appear.  Click on OK.



Close window

Refresh General Journal entry screen

Make sure entry balances.  If not, it will not post to the GL



Post.  

Go to the GL Activity to assure posting show up.  Also, run Balance Sheet and Income Statement to assure they match original reports.  


If correct, go on to next import.




    • Related Articles

    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...

    • GL Account Setup for Standard Costing

      ​ ​ G/L Account Required for Standard Costing & PIT Summary This document helps explain some of the common accounts that are required for using EIQ in a Standard Costing environment when the transactions will be journalized.   Note that some of these ...

    • Things to look at for PIT

      ​ ​ Comparing Perpetual On Hand to the General Ledger Inventory Accounts The procedure for comparing the perpetual on hand at standard cost to the general ledger inventory accounts should be as follows: Process ALL Post Inventory Transaction Types  ...

    • Reconciliation PIT

      Often times when the perpetual on hand inventory at standard cost differs from that of the balance in the general ledger for the corresponding account some of the following scenarios are the cause. Transaction Date Floor dispositioning and any other ...

    • Comparing Perpetual On Hand to the General Ledger Inventory Accounts

      ​ ​ Comparing Perpetual On Hand to the General Ledger Inventory Accounts The procedure for comparing the perpetual on hand at standard cost to the general ledger inventory accounts should be as follows: Process ALL Post Inventory Transaction Types  ...