Review your general ledger actual account balances and activity in detail. You can run this report for balances and activity entered in your ledger currency, foreign currency, or STAT. You can also report on translated balances by specifying a balance-level reporting currency.
The report prints a line for each of your accounts and lists them in ascending order by account segment value. For each account, the report prints the account segment value, account segment value description, beginning balance, period activity, and ending balance for the period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.
When you request this report, General Ledger prompts you to enter the following:
Ledger/Ledger Set: Choose a single ledger, reporting currency, or a ledger set to run this report for multiple ledgers at once.
To view translated balances, choose the Balance-level reporting currency that was used as the target ledger during translation.
Ledger Currency: If you chose a ledger set in the Ledger Set field, choose a currency of one of the ledgers or reporting currencies in the ledger set. The Ledger Currency filters the data in the report to only report on those ledgers or reporting currencies for which the currency matches the ledger currency specified.
If you chose a ledger or reporting currency, its currency will default and cannot be changed.
Currency Type: Choose Total, Entered, or STAT as follows:
Choose Total to view the ledger currency total balances or to view translated balances that were translated to a balance-level reporting currency.
By specifying a ledger and the Currency Type Total, all balances that were entered using the ledger currency, as well as any foreign entered balances that were converted to the ledger currency will be retrieved.
By specifying a balance-level reporting currency and the Currency Type Total, you can view Translated average balances.
By specifying a reporting currency (journal or subledger level) and the Currency Type Total, all balances that were entered using the reporting currency, as well as any foreign entered balances that were converted to the reporting currency will be retrieved.
Choose Entered and specify a currency in the Entered Currency field to report on average balances that were entered in a specific currency.
Choose Statistical to report on Statistical average balances.
Entered Currency: If you chose the Entered Currency Type, choose a currency.
Pagebreak Segment: Choose any account segment other than your account segment. General Ledger prints a separate page for each value of the segment you choose.
Pagebreak Segment Low/High: Enter the range of Pagebreak Segment values for your report.
Period: Choose any open accounting period in your calendar.
Amount Type: Choose PTD (period-to-date), YTD (year-to-date), or PJTD (project-to-date).
The title of the report changes depending on the Currency Type specified:
If the currency type is Total or Statistical, the report title is Detail Trial Balance.
If the currency type is Entered, the report title is Entered Currency Detail Trial Balance.
Refer to the selected heading descriptions below for additional information.
Account: account segment value for each account.
Description: description of your account segment value.
Account: the full accounting flexfield.