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.

If you access this session using LN UI (through Ming.le) and the Business Intelligence server is configured with Ming.le, the fields in the Amounts group box are not displayed and a graph presenting the cumulative ledger balances (overview of the transactions posted to ledger accounts till the current date) for the selected ledger account are displayed.

Note: 
  • To view the graph, you must select a record .
  • The graph is displayed for the number of periods defined for the group of companies. The first period includes opening balances and the last period includes correction periods.
  • The graph can be displayed for a maximum of thirteen periods. If more than twelve periods are used in a group of companies (excluding correction periods), LN determines the thirteen periods by dividing the total number of periods by thirteen. The last (thirteenth) period includes the rest of the periods.

Example

Customer has 73 periods defined. LN determines the periods (73/13=5,615) and displays the periods in the graph as:

5, 10, 15, 20, 25, 30, 35, 40, 45, 50, 55, 60, 73.

Field Information

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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
Opening Balance

The opening balance of the selected ledger accounts for the fiscal year for which you display the history data.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
Up to Balance
Actual Amount

The total amount posted to the ledger account during the fiscal year up to the end of the Period fiscal period.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
Movements
Actual Amount

The total amount posted to the ledger account during the selected range of fiscal periods.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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.

Note: This field is not displayed if the application is accessed using Infor LN UI (through Ming.le) and Business Intelligence server is configured with Ming.le.
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 Finance 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.

Print Sequence

The sequence in which LN displays the ledger accounts.

LN displays ledger accounts for which you do not enter a print sequence in numeric order or in alphanumeric order on the reports.

To display the ledger accounts in a specific order other than the alphanumeric order, enter a print sequence number. For example, you can use the print sequence number to display the child accounts followed by their parent account. Ledger accounts for which you define a print sequence are displayed at the end of the reports, in the order of their print sequence numbers.

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 previous 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.

Business Partner Balance

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 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 Quantity

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 Period 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.