Ledger History (tfgld3501m000)

Use this session to view history data for a range of ledger accounts.

To view history data:

  1. Specify a selection range based on financial company, period type, fiscal year, and fiscal period.
  2. If required, use any of the Options fields to further restrict your selection.
  3. Click Recalculate Balances.

To display the ledger account details, double-click the ledger account line.

 

Selection Range
All Companies
If this check box is selected, the selection applies to all companies.
Reporting Currency Group
The reporting currency group for which LN displays the history.
Financial Company
The financial company for which LN displays the history.
Period Type
The period type for which LN displays the history. The period type can be Fiscal or Reporting.
Year
The fiscal year for which LN displays the history.
Period
The financial period or range of periods for which LN computes the amounts and quantities.
Recalculate
To (re)calculate the balance amounts, click this button.
Amounts
Closing Balance Quantity
The total quantity posted to the ledger account during the fiscal year up to the end of the range of fiscal periods for which you display the history data.

If the period range ends with the current, open period, this field displays the total amount posted to the ledger account to date.

Opening Balance
The opening balance of the selected ledger accounts for the fiscal year for which you display the history data.
Up to Balance
Actual Amount
The total amount posted to the ledger account during the fiscal year up to the end of the To fiscal period.
Budget
The total amount budgeted for the ledger account in the fiscal year up to the end of the displayed fiscal period.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance
The difference between the actual amount and the budgeted amount.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance %
The difference between the actual amount and the budgeted amount, expressed as a percentage.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Movements
Actual Amount
The total amount posted to the ledger account during the selected range of fiscal periods.
Budget
The amount budgeted for the ledger account for the selected range of fiscal periods.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance
The difference between the actual amount and the budgeted amount.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance %
The difference between the actual amount and the budgeted amount, expressed as a percentage.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Closing Balance
Actual Amount
The total amount posted to the ledger account during the fiscal year up to the end of the range of fiscal periods for which you display the history data.

If the period range ends with the current, open period, this field displays the total amount posted to the ledger account to date.

Budget
The total amount budgeted for the ledger account for the selected range of fiscal periods.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance
The difference between the actual amount and the budgeted amount.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Variance %
The difference between the actual amount and the budgeted amount, expressed as a percentage.

If you defined a budget for the ledger account in the Controlling module, this field has a value.

Home Currency
The home currency in which LN displays the amounts.

From the Tools menu, choose Rotate Currency to switch home currencies.

Options
Include Non Finalized Transactions for Totals
If this check box is selected, LN includes non-finalized transactions to calculate the total amounts.
Note

Non-finalized transactions are considered only if the update method of the account type is Real Time Processing.

Accounting Scheme
The accounting scheme for which you display the history data.
Budget
If you want to compare the actual amounts with budgeted amounts, select a budget.

If you defined a budget in the Company Parameters (tfgld0503m000) session, by default LN displays this budget.

Ledger Account
The ledger account.

To display the amounts for a ledger account, select the ledger account. LN displays the amounts in the Amounts section.

Search Key
The ledger account's search key.
Account Sublevel
The ledger account's sublevel.
Account Type
The account type, which can be Balance Sheet or Profit & Loss.
Opening Balance
The opening balance of the selected ledger account for the fiscal year for which you display the history data.
Up to Balance
The total amount posted to the ledger account during the fiscal year up to the end of the To fiscal period.
Movements
The total amount posted to the ledger account during the selected range of fiscal periods.
Movements Debit
The total debit amount posted to the ledger account during the selected range of fiscal periods.
Movements Credit
The total credit amount posted to the ledger account during the selected range of fiscal periods.
Closing Balance
The total amount posted to the ledger account during the fiscal year up to the end of the range of fiscal periods for which you display the history data.

If the period range ends with the current, open period, this field displays the total amount posted to the ledger account to date.

Statutory Parent Account
If the account has a statutory parent account, this field displays the parent account.
Complementary Parent Account
If the account has a complementary parent account, this field displays the parent account.
Dual Accounting Indicator
The accounting scheme to which the ledger account belongs.

The accounting scheme can be either statutory or complementary.

Integration Account
If this check box is selected, the account is an integration account.
Debit/Credit
Indicates the main use of the account.

For example, the main use of a cost account is Debit.

Allocation Type
Indicates which costs can be posted or allocated to this account. This data is used in the Controlling module.
Compression of Transactions
If this check box is selected, LN automatically compresses the transactions on financial reports.
Dimension Used Y/N
Indicates whether amounts posted to the account must also be posted to dimensions of the dimension type.
Daily Balance
If this check box is selected, LN maintains daily balance information for the ledger account.
Balance by Business Partner
If this check box is selected, LN maintains balance information by business partner for the ledger account.

If this check box is selected, you can click Distribution by Business Partner to start the Distribution by Business Partner (tfgld3530m000) session.

Unit 1
The unit in which the displayed quantities are expressed.

If you specified Unit 1 for the ledger account in the Chart of Accounts (tfgld0508m000) session, LN also displays the history for the quantities.

Opening Balance
The opening balance of the selected ledger account for the fiscal year for which you display the history data.
Up to Quantity
The total quantity posted to the ledger account during the fiscal year up to the end of the To fiscal period.
Movements Quantity
The total quantity posted to the ledger account during the selected range of fiscal periods.
Unit 2
The unit in which the displayed quantities are expressed.

If you specified Unit 2 for the ledger account in the Chart of Accounts (tfgld0508m000) session, LN also displays the history for the quantities.

 

Statutory Parent Account
Selects the statutory parent account of the currently selected account and displays the parent account's history.

If the selected ledger account has a statutory parent account, you can use this command.

Complementary Parent Account
Selects the complementary parent account of the currently selected account and displays the parent account's history.

If the selected ledger account has a complementary parent account, you can use this command.

Display Child Dimensions
Company
Period
Currency Analysis
Dimension
Business Partner

You can only use this command for accounts for which you selected the Business Partner Balance check box in the Chart of Accounts (tfgld0508m000) session.

Finalized Transactions
Non-Finalized Transactions
Date

You can only use this command for accounts for which you selected the Daily Balance check box in the Chart of Accounts (tfgld0508m000) session.

Recalculate Balances
Recalculates all amounts displayed.