General Ledger Workbench selection pane
The selection pane in the General Ledger Workbench (tfgld8350m000) session comprises of these sections:
- Company Selection
- Data Selection
- Compare To
- Display Options
You can specify the data in each section and click Apply Selection. The General Ledger data is displayed in the details pane based on the specified data. You can click Save Defaults to save the specified data. The saved data is displayed when you access the workbench next time.
Company Selection section
In this section, you can select the data related to the company:
- Company
- The code of the company for which the General Ledger data must be displayed. For more information, see
- Reporting Currency Group
- The code of the reporting currency group for which the General Ledger data must be displayed. In an environment with multiple financial companies, this code defines the common home currency to be used in reporting and viewing data for those companies that are linked to the code. This field is only applicable if the Currency System is ‘Standard’ in the Companies (tcemm1170m000) session and ‘Multiple Companies’ has been selected in the Company field in this workbench.
- Currency
- The home currency of the company for which the General Ledger data must be displayed.
Data Selection section
In this section, you can select the data related to the General Ledger:
- Period Type
- The period type for which the data is displayed. Possible values:
- Fiscal
- Reporting
This value is displayed only if the Reporting Periods check box is selected in the Group Company Parameters (tfgld0501m000) session.
- Year
- The fiscal year for which the data is displayed. The years defined in the Year (tfgld0606m000) session are considered.
- Period
- The period for which the data is displayed.
- Account Type
- The type of account. Possible values:
- Balance Sheet
- Profit & Loss
- Intercompany
- Intersegment
- Accounting Scheme
- The accounting scheme for which the data is displayed. Possible values:
- Statutory
- Complementary
- Both
By default, this field is set to Statutory.
- Dimension Type
- One of the dimension types that are defined in the Group Company Parameters (tfgld0501m000) session
- Include Non-Finalized
- If this check box is selected, the transactions that have not yet been finalized are also considered.
- Exclude Zero Balances
- If this check box is selected, only the data without zero balance is considered.
Compare To section
In this section, you can select the data for comparison to analyze the selected period data.
- Compare To
- The data based on which the comparison is performed. Possible values:
- Previous Period (selected period minus 1)
- Period Previous Year (default) (same period of previous year)
- Budget (the estimated amounts for the selected year)
- Budget
- The budget based on which the comparison is performed. This field is enabled only if the Compare To field is set to Budget.
Display Options section
In this section, you can customize the data displayed in the details pane.
- Columns
- The data (columns) that must be displayed in the details pane. Possible values:
- Opening Balance
- Debit/ Credit Up to Period
- Movements Up to Period
- Debit/ Credit Period
- Movements Period
- Debit/ Credit Closing Balance Period
- Closing Balance Period
- Variances
- The difference between the actual amount and the comparison amount expressed in amount and/or percentage.
- Priority
- The data that must be displayed in the details pane based on the selection. Possible
values:
- Ledger Account (Default); you can zoom to the dimension distribution distribution using the ‘Go to Details’ button in the line.
- Dimension; you can zoom to the ledger account distribution using the ‘Go to Details’ button in the line.
Note: You can set this field to Dimension only if the Dimension Type is selected in the Data Selection section.