Producing the Journal Postings Audit Report

The Journal Posting Audit Report identifies the journal numbers that have been assigned to journals in the ledger. A journal number is assigned to a journal when the posting procedure begins. If, for any reason, the journal is not posted the journal number remains assigned to this journal and is not reused. Therefore, you can use this report to identify any 'unused' journal numbers, that is journal numbers that do not appear on the journal listings.

The status shown on the report indicates the current state of the journal. A status of Journal Posted OK (1) indicates that the journal was posted successfully, a status of Incomplete Journal (0) indicates that it is being posted. Any other status indicates that the journal was not posted.

Note:  This report includes any journals numbers assigned to journals that were not posted.

You can restrict the report to journals by journal type, journal creation date and journal status. The report prints one line for each journal and includes the following journal audit information:

  • The journal number and type
  • The last status of the journal
  • The date the journal was created
  • The SunSystems function used to create the journal
  • The operator who created the journals
  • The provisional posting indicator.
  • The entry period
  • The total debits and credits included in the batch, displayed in the base currency only.

Journal Posting Audit Report

Business Unit
The business unit to be reported.
Ledger Code
The ledger to be reported.
Journal Number
A journal number, or range of journal numbers, to be included in the listing. Leave this field blank to include all journal numbers in the listing.
Last Status
The status code for which journals are listed on the report.
Journal Type
A journal type, or range of journal types, to be included on the report. Leave this field blank to include all journal types in the listing.
Date Created
The date, or range of dates, on which journals must have been created to appear on the report.