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.