Introduction
The following screen displays the opening balance and closing balance of the corporate or division general ledger account. This screen also allows you to compare the amount and percentage differences in the forecasts for the periods.
Menu path
- Go to Logistics/Reports/Search/Items, define the search criteria, and then click Show. In the Search: Items screen, select an item, and then click Divisions: Financial under the Monitor section. In the Item card: Divisions: Financial screen, select a general ledger account in the Asset: G/L, Costs: G/L, Purchase G/L, or Revenue G/L column, and then click Balance under the Monitor section.
- Go to Financial/Setup/Master data/G/L Accounts, and then select a general ledger account in the G/L column. In the G/L Account (Corporate) screen, select a general ledger account in the G/L column, and then click Balance under the Monitor section.
- Go to Financial/Reports/G/L Accounts/Chart of G/L’s, and then select a general ledger account in the G/L (Corporate) column.
- Go to HRM/Setup/Organization/Divisions, define the search criteria, and then click Show. In the HRM: Divisions screen, select a division in the Name column, and then click Chart of accounts under the Monitor section. In the Financial: Chart of accounts screen, select a general ledger account in the G/L (Division) column.
- Type the item code or name in
Items on the left menu bar, and then click 
. In the Search: Items screen, select an item, and then click Divisions: Financial under the Monitor section. In the Item card: Divisions: Financial screen, select a general ledger account in the Asset: G/L, Costs: G/L, Purchase: G/L, or Revenue: G/L column, and then click Balance under the Monitor section.
Roles & rights
All users can view the opening balance and closing balance of the general ledger account for the division.
For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh and then click the required link under the Role column.
Button
Show
Click this to display the results based on the defined search criteria.
Refresh
Click this to display the new search results based on the newly defined search criteria.
Note: This is available only if you have clicked Show.
Reset
Click this to clear the defined search criteria.
Close
Click this to exit.
Description
Criteria section
G/L
Type or select a general ledger account to view the opening balance and closing balance of the general ledger account. By default, the general ledger account selected from the previous screen is displayed.
Division
Type or select a division to view the opening balance and closing balance of the general ledger account for the division. If you are viewing the opening balance and closing balance for corporate general ledger accounts, select a division group, and then select a division from the selected division group.
Type
Select the transaction type to view the opening balance and closing balance of the general ledger account with the selected transaction type. You can select any of the following transaction type:
Leave the field blank to view the opening balance and closing balance of the general ledger account with any transaction type.
Cost center
Select the type of cost center group, and then type or select a cost center from the selected cost center group to view the opening balance and closing balance of the general ledger account from the selected cost center.
Item
Select Item to view the opening balance and closing balance of the general ledger account with the type of item selected or Assortment to view the opening balance or closing balance of the general ledger account with the type of assortment selected. If you have selected Assortment, type or select an assortment. By default, Item is selected.
Assortment: Properties
Select the assortment category, and then type or select the type of assortment from the selected assortment category to view the opening balance and closing balance of the general ledger account with the selected assortment.
Note: This is available only if you have selected Item at Item.
Currency / Factor
Select a currency, and then select the factor to view the opening balance and closing balance of the general ledger account with the selected currency and factor. By default, the default currency defined in Exact Synergy Enterprise is selected and “1.00” is selected for the factor.
Warehouse
Type or select a warehouse to view the opening balance and closing balance of the general ledger account with the selected warehouse. You can leave the field blank to view the opening balance and closing balance of the general ledger account with any warehouse.
Item
Type or select the range of items to view the opening balance and closing balance of the general ledger account with the selected items. You can leave the fields blank to view the opening balance and closing balance of the general ledger account with any items.
Note: This is available only if Item is selected at Item.
Data section
Data / Scenario
Select the type of data that you want to be included in the opening balance and closing balance of the general ledger account. You can select any of the following:
Select the type of scenario that you want to be included in the opening balance and closing balance of the general ledger account. You can select any of the following:
This is enabled only if you have selected Budget or Forecast at Data. Budget scenario is available only if you have selected Budget at Data.
Year / Period
Select a year to view the opening balance and closing balance of the general ledger account.
Type the period or range of periods to view the opening balance and closing balance of the general ledger account for the selected year.
Note: This is available only if you have selected Actual or Budget at Data.
Year / Period (Actual + Budget)
Select a year to view the opening balance and closing balance of the general ledger account.
Type the actual period or range of periods to view the opening balance and closing balance of the general ledger account for the selected year. Once you have clicked Refresh, the budgeted forecast period for the year will be displayed.
Note: These fields are available only if you have selected Forecast at Data.
Budget Exchange rates
Click this link to view the exchange rate for the budget for the selected year.
Note: This is available only if you have selected Budget or Forecast at Data.
Compare with
Data / Scenario
Select the type of data that you want to be included in the opening balance and closing balance of the general ledger account by comparing this data with the data defined at Data under the Data section. You can select any of the following:
You can also leave the field blank to view only the opening balance and closing balance of the general ledger account defined under the Data section.
Select the type of scenario that you want to be included in the opening balance and closing balance of the general ledger account by comparing this scenario with the scenario defined at Scenario under the Data section. You can select any of the following:
This is enabled only if you have selected Budget or Forecast at Data. Budget scenario is available only if you have selected Budget at Data.
Year / Period
Select a year to view the opening balance and closing balance of the general ledger account by comparing the selected year with the year defined at Year under the Data section. This is enabled only if you have selected Actual, Budget, or Forecast at Data.
Type the period or range of periods to view the opening balance and closing balance of the general ledger account for the selected year by comparing the selected period(s) with the period(s) defined at Period under the Data section. This is enabled only if you have selected Actual, Budget, or Forecast at Data.
Year / Period (Actual + Budget)
Select a year to view the opening balance and closing balance of the general ledger account by comparing the selected year with the year defined at Year under the Data section.
Type the actual period or range of periods to view the opening balance and closing balance of the general ledger account for the selected year by comparing the selected period(s) with the period(s) defined at Period under the Data section. Once you have clicked Refresh, the budgeted forecast period(s) for the year will be displayed.
Note: These fields are available only if you have selected Forecast at Data.
Related document