Journal Import

Tips:

The imported file must have a defined Import Control Record, which is identified by the Import Control ID.
Do not confuse the Journal Import with the Journal Import Post. The Journal Import pulls in the journal entry transactions to a temporary file. The post moves the transactions from the temporary file into the appropriate Period of the general journal.
Do not confuse the Import Exception Report with the daily General Journal Exception Report or the General Journal Import Report. This report prints errors detected by the Journal Import routine.
The report is available in the following formats:
80-Column Format: Set during System Parameters at the Print tab.
132-Column Format: Set during System Parameters at the Print tab.
Enhanced View: Set during Print View at the View menu.
If you see the following error, there may have been an error when you last ran the Journal Import Post. Correct the error and re-run the post before continuing.
To see the timing for the import procedure, refer to the Daily Checklist in the General Ledger Runbook.

Click Utilities from the Menu Bar.
Click Imports Menu.
Click Journal Import.

Tip: Or, use the keyboard shortcut: [ALT] [t] [i] [i].

Journal Import Window Example:

Journal Import Prompt Options

Tip: To see more information about a field, click the hyperlink for the field name.

Enter the Import Control ID. (up to 20 characters)

Required

Tip: To Search for the Import Control ID, click Search .

Enter the Import File path and file name. (up to 80 characters)

Tips:

The Source File defaults to the File Name and path defined for the Import Control ID. However, you can override the path here.
To search for the file using Windows® Explorer, click Browse .
Keyboard shortcut: [ALT + b]

To import the data from the file, click Proceed or press [ENTER].

Keyboard shortcut: [ALT + p]

Notes:

Proceed only imports the data. It does not print the exception report. To see the exception report, you must click Print View after clicking Proceed.
If the data fails to import, you will see the following message:

View the exception report to analyze the problem.

To print the exception report to the Print View screen, click here.

Tip: This does not run the Import routine.

To escape from the routine, click Cancel.

Keyboard shortcut: [ALT + c]

To see an example of the report, click Journal Import Exception Report Sample.

Journal Import File Sample: