Reporting on the Import Process

The Ledger Import Validation Report (FPLI1.srdl) is produced automatically by the Ledger Import process. This report lists some or all of the journal transactions processed from a selected import file.

The results of the Ledger Import process are summarized on the Ledger Import Validation Report dialog. This dialog includes a Print action that allows you to view and print the Ledger Import Validation Report.

The Ledger Import Validation Report dialog also allows you to determine the type of transactions to be included on the report. You can include or exclude:

  • valid transactions
  • invalid, rejected, transactions
  • substituted transactions
  • generated transactions.

Identifying the Rejections and Substitutions

Any rejected transactions or transactions with substitutions are clearly identified in the leftmost report column, alongside the relevant transaction details.

The Transaction Rejected message appears if the transaction has been rejected. The '^' caret character is printed beneath each field that contains invalid data.

The reasons the transaction was rejected are explained beneath the transaction details alongside the {Rejection} note.

If a transaction contains invalid data that has been replaced by default valid data, these substitutions are identified alongside the {Substitution} note beneath the transaction details.

Note: If you are using over expenditure checking, and an imported transaction takes the account over budget, the posting report highlights this but does not prevent the transaction from being posted.

Selecting the Report Format

You can choose different layouts for the report by changing the setting of the Layout Code field in the Reporting tab on the Ledger Import Run-Time Parameters.

The following default report layouts are available:

Report designed for: Format Code
Journals generated by Corporate Allocations and posted by Ledger Import. This report is stored automatically. LICOR
Journals generated by any other system or function and imported using Ledger Import. LIALL
Note: You can also create new report layouts and change existing report layouts using Report Designer.