Journal import

You can import journal transactions into LN from an outside source.

To import journal transactions, use one of the following:

  • Exchange schemes
  • The Post Imported Journal Transactions (tfgld2215m000) session

A default exchange scheme called JVIMPRT is provided in an additional file that you can import using the Import Additional Files (ttadv2270m000) session. You can modify the exchange scheme or you can create new exchange schemes, if you want to use a customized format.

The default exchange scheme is designed to:

  • Read an ASCII file.
  • Retrieve the necessary data.
  • Store the retrieved data in LN tables.
Note

You can access the LN tables in the Post Imported Journal Transactions (tfgld2215m000) session.

The exchange scheme searches four record types in the ASCII file:

  • Batch header records
  • Document header records
  • Document line records
  • Text records

The identification numbers are used to group sets of records in the ASCII file which belong to the same transaction. The identification numbers are used to select the data, which is imported into the general ledger. A one to one relationship exists between identification numbers and batch numbers in the general ledger.

When a batch has been successfully imported, the batch is treated in the same way as other nonfinalized transactions. The normal processing procedures are followed for maintenance and finalization of the transaction.

When a batch is processed, the detail records are removed from the import tables. The batch-header record remains and you can view the status of the imported journals in the Imported Journal Files (tfgld2513m000) session.