Display balance information

Use this procedure to display overall financial information in the form of balances for selected balance dimensions over a specified period.

Before you start

  • Balance keys, which indicate the information stored in the balance file and the order in which this information is displayed, are activated in 'GL Balance File Key. Open' (GLS690). User access authority to balance keys in (GLS215) can be restricted using the object access group field on (GLS690/E). If a balance key has an object access group authority restriction, users who do not belong to the object access group cannot access any records in (GLS215) that are connected to the balance key.
  • The balance keys are updated with values in 'GL Balance File. Update with Outcome' (GLS915) and 'GL Balance File. Update with Budget’ (GLS920).
  • A column template is created in 'Column Template – Balance Inquiry. Open' (GLS216).
  • If the column template is used to retrieve budget values, the 'Budget' check box must be selected for the balance keys to be used in combination with the template on 'GL Balance File Key. Open' (GLS690/E).
  • There are transactions registered in the system.

Follow these steps

  1. Start 'GL Balance File. Display' (GLS215/B).
  2. Specify the period and select a column template. The period for the column template is always based on the period displayed on-screen.
  3. Select a balance key to regulate the balance dimensions displayed. Specify the 'From' and 'To' values for the balance dimensions.
  4. To display detail lines with zero entries in both columns, select F13 = Settings and select the 'Display zero lines' check box on (GLS215/P).
    Note: The heading lines and total lines are always displayed.

    At the central company level, you can also select currency and exchange rate type on the P panel. This can be useful when a central user wants the balance file to display converted values from different divisions having different currencies. The exchange rate used is the rate valid on the last day of the period specified on (GLS215/B), retrieved from the division in which the transaction originated.

  5. Select a sorting order. This determines how many of the seven dimensions in the balance key are displayed.
  6. To display additional information, select option 5 = Zoom. This raises the value of the sorting order by 1, still using the selected ID as the range for the balance key.