Review journal information to trace each transaction back to its original source.
General Ledger prints a separate page for each balancing segment value. For each journal line, the report prints the account affected, the concatenated description, the journal line amount, and the beginning and ending account balance. Additionally, for each journal line, the report prints journal details including source, category, journal name, and effective date. The report lists accounts in ascending order by account segment value, and it prints a "CR" next to credit amounts.
Note: If you use the Enter Budget Amounts form to update budget balances, General Ledger does not generate journal entries to reflect your changes. This will cause the General Ledger Report to flag discrepancies between a budget balance and the budget journals for that period.
When you request this report, General Ledger prompts you to enter the following:
Ledger/Ledger Set: 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.
Ledger Currency: If you chose a ledger set in the Ledger/Ledger Set field, choose a ledger currency of one of the ledgers in the ledger set. The ledger currency filters the data in the report to only report on those ledgers for which the currency matches the ledger currency specified.
If you use reporting currencies (journal or subledger level), and your ledger set includes reporting currencies, you can choose the currency of a reporting currency for this field.
If you chose a ledger or reporting currency, the currency of the ledger or reporting currency will automatically default and cannot be changed.
Currency Type: Choose Total or Statistical.
Choose Total to view balances that have been converted to the ledger currency. This includes balances that were entered using the ledger currency, as well as any foreign entered balances that were converted to the ledger currency.
If you use reporting currencies (journal or subledger level), choose Total to view balances that have been converted to the reporting currency. This includes balances that were entered using the currency of the reporting currency, as well as any foreign entered balances that were converted to the currency of the reporting currency.
Choose Statistical to only view STAT balances.
Type: Choose Document Number, Entry Item, Line Item, or Source Item as follows:
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.
Choose Entry Item to generate a report showing EXTERNAL_REFERENCE from the GL_JE_HEADERS table. This reference may help you identify the origin of the journal entry and appears only if you provided one in the Enter Journals form or if you used Journal Import.
Choose Document Number to generate a report showing the sequence number of the journal containing your journal line. A sequence number will only appear in your report if you are using sequential numbering and you have assigned a number to the journal containing your journal line.
Balance Type: Choose Actual, Budget or Encumbrance balances.
Budget or Encumbrance Name: If you chose the Budget balance type, you must select a budget name. If you chose the Encumbrance balance type, you must select an encumbrance type. Finally, if you chose the Actual balance type, General Ledger automatically enters N/A.
Starting/Ending Period: Choose the range of accounting periods for your report.
Account From/To: Choose the range of accounts for your report.
Refer to the selected heading descriptions below for additional information.
Description/Sequence Name: If you selected the Line Item, Entry Item, or Source Item Type, General Ledger prints the journal description for each journal line. If you selected the Document Number Type, General Ledger prints the name of the sequence used to number the journal containing your line.
Line Item/Entry Item/Source Item/Document Number: If you selected the Line Item Type, General Ledger prints REFERENCE_1 from the GL_JE_LINES table. If you selected the Source Item Type, General Ledger prints REFERENCE_4 from the GL_JE_LINES table. If you selected the Entry Item type, General Ledger prints EXTERNAL_REFERENCE from the GL_JE_HEADERS table. Finally, if you selected the Document Number Type, General Ledger prints the sequence number of the journal containing your journal line.