Import General Ledger Journals

Here you can import company journals and group journals from a text file. The file may have been exported from an external system like the general ledger. The file being imported must be saved as a text file, and its content must be structured according to a specified format.

It is not possible to import automatic journals with this menu option. To enter automatic journals, use Maintain/Special Utilities/Automatic Journals/Data Entry - Automatic Journals.

Procedure

  1. On the Transfer menu, click External Data/Import General Ledger Journals. The Import General Ledger Journals window opens.
  2. In the Import File text box, enter the path and file name of the file you want to import.
  3. In the Field Delimiter text box, enter the type of delimiter that separates data in the file. Commas (,) or semi-colons (;) are the most common delimiters.
  4. Click the Add to Queue button to add the specified file to an import queue. Click the View Queue button to view all files on queue.
  5. Click the Import button. All journal files in the import queue are imported. A message box displaying import statistics appears.
  6. A log report of the import can be viewed or printed from the Transfer menu, Log Reports, when the General Ledger Journals tab is selected.