Review source, category and reference information to trace your ledger's currency, foreign currency, or STAT transactions back to their original source. You can run this report for a single ledger or a ledger set to view amounts that have been converted to the ledger's currency or only amounts entered using a specific currency. You can run this report with entry, line or source item reference information to help identify the origin of journals created by Journal Import.
This report prints the journal entry lines and beginning and ending balances of the accounts you request. For each journal entry line, the report prints the source, category, batch name, journal entry name, account, description, entry/line/source item reference information, and the debit or credit amount.
When you request this report, General Ledger prompts you to enter the following:
Type: Choose Entry Item to generate a report showing EXTERNAL_REFERENCE from the GL_JE_HEADERS table. This reference appears only if you provided one in the Enter Journals form or if you used Journal Import. Choose Line Item to generate a report showing REFERENCE_1 from the GL_JE_LINES table. Choose Source Item to generate a report showing REFERENCE_4 from the GL_JE_LINES table. These references appear only if you used Journal Import and included a journal voucher.
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.