One moment please...
 
Exact Synergy Enterprise   
 

Viewing General Ledger Account Opening Balance and Closing Balance

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 http://www.exactsoftware.com/docs/DocBinBlob.aspx?ID=%7bf4a6c823-b796-44ad-8ad1-e2d04498066e%7d Items on the left menu bar, and then click http://www.exactsoftware.com/docs/DocBinBlob.aspx?ID=%7bf9fcc553-a30f-4c39-b0b5-3caf5298904a%7d. 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

Logisctics_Reports_Search_Items_Show_Item_DivisionsFinancial_GL_Balance_CriteriaSection.png

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:

  • Standard
  • Fiscal

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

Logisctics_Reports_Search_Items_Show_Item_DivisionsFinancial_GL_Balance_DataSection.png

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:

  • Actual
  • Budget
  • Forecast

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:

  • Budget scenario
  • MRP

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

Logisctics_Reports_Search_Items_Show_Item_DivisionsFinancial_GL_Balance_CompareWithSection.png

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:

  • Actual
  • Budget
  • Forecast

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:

  • Budget
  • MRP

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

     
 Main Category: Support Product Know How  Document Type: Online help main
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.869.462
 Assortment:  Date: 27-09-2010
 Release:  Attachment:
 Disclaimer