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
Import Code: GL
Description: GL Import (Prepost Detail)
File Type: DBF (this is the only one I can get to work)
Add GLPREPOST_DETAIL system table (upper right hand window)
Add IMPORT FIELDS:
- Double Click on the sqk statement field. Type in select id from glacct where acct = '%s'
- Double click on the sql statement field. Type in “select %f from dual”. (Do not include the quotes
You will need a DBF file that has the following information:
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.
Refresh General Journal entry screen
Make sure entry balances. If not, it will not post to the GL
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.