Review journal batches and associated journals for your posted, unposted or error journals entered in any currency. You can run this report with line or source item reference information to help identify the origin of journals created by Journal Import.
This report prints the line number, account, transaction date, description, reference information, and the ledger currency, foreign currency, and statistical debit or credit amounts for each journal line. Totals are provided for all of the debit and credit amounts for each journal and for the batches. In addition, a total is provided for your journal sources, and a grand total is provided for all of the debit and credit amounts included in your report.
For foreign currency entered amounts, the report displays both the entered amount and the accounted amount (the amount accounted in your ledger currency).
For amounts entered using the ledger currency, the entered and accounted amounts are the same.
When you request this report, General Ledger prompts you to enter the following:
Type: 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 number, an invoice date and number, or some other source document information that helps you to identify the origin of this journal.
Posting Status: Choose Posted to generate the Entered Currency Posted Journals Report showing all posted journals in your batch. Choose Unposted to generate the Entered Currency Unposted Journals Report showing all journals in your batch which have not been posted. Choose Error to generate the Entered Currency Error Journals Report showing all journals that errored out during the posting process, possibly due to a control total violation or posting to a closed period. If your error is due to a code combination violation (for example, you tried to post to an account for which posting is not allowed), General Ledger prints the code combination error in place of the account.
Entered Currency: Choose any currency for which you entered journals, including STAT.
Ledger/Ledger Set: (optional) Choose a ledger or a ledger set to run this report for multiple ledgers at once.
Note: You can only choose ledgers or ledger sets that are assigned to your Data Access Set. You must have at least read access to one ledger and balancing segment value or management segment value to choose the ledger
If you use reporting currencies (journal or subledger level), you can choose a reporting currency.
Period: (optional) Choose an accounting period in your calendar for which you entered journals. This field is optional only if you are not entering a Start/End Date.
Start/End Date: (optional) For unposted and error journals, enter the batch effective date range for which you want a report. For posted journals, enter the posting date range. This field is optional only if you are not entering a Period.
Source: (optional) Choose the journal source for your batch. Batches originating within General Ledger include manual journal batches which have a source of Manual, and formula journal batches which have a source of Recurring or MassAllocations. Journals you import have a source corresponding to your feeder system.
Batch Name: (optional) Choose any journal batch containing journals.
Refer to the selected heading descriptions below for additional information.
Transaction Date: The effective date of the journal batch.
Entered Amount: entered amount entered using the Entered Currency.
Accounted Amount: accounted amount that has been accounted in the ledger currency.
Units: statistical amount, if any, associated with your journal line.