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 Infor 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), Infor 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. Infor 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.

 

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

Company
Period
Currency Analysis
Dimension
Business Partner

Starts the Distribution by Business Partner (tfgld3530m000) session.

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

Starts the Distribution by Date for Ledger Account (tfgld3533m000) session.

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.