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
.
Related topics