Previous	Next		Contents	Index	Navigation	Glossary	Library

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.

Parameters

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.

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.

Currency: Choose either the functional currency for your set of books or STAT.

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.

Flexfield From/To: Choose the range of accounts for your report.

Selected Headings

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.