Importing Journal Entries

Use the Import Journal utility in the China Localization to import journal transactions from a text file. When the data is loaded, the original account and unit code are converted to the appropriate account and unit code, according to the mappings maintained in the Account Cross Reference form. The data is loaded into the appropriate journal ID according to its original journal ID.

For each journal ID and transaction date (and/or control number and/or CH-GL voucher number), the transaction total amount must be zero. The Reference Control Number for the new journal entry is set as described in this topic.

To import the transactions from a text file:

  1. Open the Import Journal form.
  2. Specify the import file name, including the path. The default value in this field is c:\temp\Datled.dat.
  3. Specify the error log file name, including the path. This is the text file where any import errors are logged.
  4. Select an option for generating the new transaction's control number:
    • Control Number: Use this option to set the newly created journal entry's Control Number to the original ledger's Control Number. If the original ledger transaction's control number is empty, the transaction data is sent to the error log file and that transaction is not imported.
    • Chinese General Ledger (CH-GL) Voucher Number: Use this option to set the newly created journal entry's Control Number to the original ledger's CH-GL Voucher Number. If the original CH-GL voucher Control Number is blank, the transaction data is sent to the error log file and that transaction is not imported.
    • Regenerate: Use this option to generate a new Control Number when the data is imported. If some consecutive transactions are on the same date, their Control Number should be the same.
  5. Click Process to import the transactions.
  6. Check the error log file for any transactions that failed to import. Make any corrections and import those transactions again.