Select Balance Information

Explanation

Use this activity to select balance information from the general ledger.

Prerequisites

Before selecting the balance information, the authority rules for making queries must be specified in General Ledger/Authority.

System Effects

As a result of this activity, the selected balance information will be displayed. You can use the Zoom-in feature to redefine how the balances should be displayed by selecting the lines in the GL Balance Analysis window.

GL Balance Analysis

Related Window Descriptions

GL Balance Analysis/Balance

Procedure

To view the GL balances of session company:

  1. Open GL Balance Analysis window.
  2. Query for the balances that you want. If you want to view balances connected to a attribute then select the Attribute from the List of Values before querying for balances. Note: If you want to view all the balances irrespective of the selected attribute, you have to select Show All Balances check box.
  3. In the Zoom-in dialog box, define how the balances should be displayed by selecting the relevant check boxes.
  4. Click OK.
  5. If you want to redefine how the balances should be displayed,
    - Select the lines that are displayed in the GL Balance Analysis window, click Zoom-in, and select or clear the relevant check boxes or else repeat steps 2 - 4.

 

To view the GL balances of multiple companies:

  1. Open GL Balance Analysis window.
  2. Select the Multi Company Check box in order to view the balances of the multiple companies.
  3. In the Search dialog box, use Company or Company Group fields to select the companies. Alternatively, Accounting currency and Parallel Currency fields can also be used to select the multiple companies.
  4. Select the relevant check boxes in the Zoom-in dialog box to define the level of detail with which the GL balances of the multiple companies should be displayed.

          Note: The additional zoom-in parameters are available for analyzing the multiple company balances. They are Company, Accounting Currency and Parallel Currency.

  1. Click OK.
  2. If you want to redefine how the balances should be displayed, select a row in the GL Balance Analysis window and click Zoom-In. If not, repeat steps 2-5.

 

To view the planning balances:

  1. Open GL Balance Analysis window.
  2. Select the required GL balance set for GL Balance Set field. Use List of Values to select the relavent GL balance sets.

          Note: You can use either attributes or Multi-Company option with GL balance sets to query planning balances.

  1. Repeat steps 3-6 in GL balances of multiple companies procedure above.