Ledger History (tfgld3501m000)
Use this session to view history data for a range of ledger accounts.
To view history data:
- Specify a selection range based on financial company, period type, fiscal year, and fiscal period.
- If required, use any of the Options fields to further restrict your selection.
- Click .
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.
- 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 Distribution by Business Partner (tfgld3530m000) session.
to start the - 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.