Journals by Document Number Report

Review detailed information for each journal associated with a specific document sequence.

General Ledger prints the journals in ascending order by document number. For each journal, the report prints the creation date, batch name, journal name, category, posting status, posted date, currency, and journal amounts. The report also indicates which document numbers do not have an associated journal.

Note: Segment security rules defined to restrict user access to segment values in your accounting flexfield are not extended to this report.

Parameters

When you request this report, General Ledger prompts you to enter the following:

Sequence Name: Choose any document sequence defined for your ledger.

If you use reporting currencies (journal or subledger level), you can choose any document sequence defined for your reporting currency.

Document Number From/To: (optional) Enter the range of document numbers for your report. If you leave these fields blank, the report will include all journals for the document sequence you choose.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Status: one of the following statuses for each document number:

Entered: There is a journal with this document number.

Not Entered: No journal was entered with this document number.

Deleted: The journal with this document number was deleted.

General Ledger only prints additional information, such as creation date, batch name, and header name, for document numbers with the Entered status.