1. Home
  2. /
  3. User Guides
  4. /
  5. Financials
  6. /
  7. General Ledger
  8. /
  9. Advanced enquiry functions
  10. /
  11. Working with query groups
  12. /
  13. Make an enquiry using...

Make an enquiry using an existing query group

Related topics

  1. Select the Balances and budgets enquiry program.
  2. You access Balance/budget enquiry template selection where you select an existing template or create a new. Click OK.
  3. You access Balance/budget enquiry. Click Query groups.
  4. On the Query group selection panel, select the query group you want to use. Click OK twice to see the result of your query group.
  5. You access Balance/budget query groups with the result from your enquiry. The columns shown are defined in Work with balance enquiry templates. On this panel you can view the balance and budget information per accounting period for the values selected for the balance enquiry template.
    • First line displays the total values per column type and key combination. Totals = The total of the opening balances and periods selected.
    • Second line displays the Opening balance, if any, for balance types that support opening balances and for balance accounts only. If you generated a “normal” Balance/Budget enquiry, then the Opening balance = the values for the previous year. If you generated a Balance/Budget query group enquiry, then the Opening balance = the values before the first period in your selection for the applicable year(s).
    • The remaining lines display the period values.

    Click Subtotals and drill down to access information on a more detailed level (i.e. the total per account combination).

    Note: If you have created opening balance transactions in the Close accounting period routine for the last period, these will not be displayed on the opening balance line in this enquiry. They are included in the total for the first accounting period, but can be displayed in the G/L transactions enquiry as automatically generated opening balance transactions.

    Note: The function keys available depend on the type of enquiry you are viewing. Either the “normal” Balance/Budget enquiry or Balance/Budget query groups enquiry.

    Tip: When running the Balance/Budget enquiry, you can generate as many enquiries as you want against the same template in one session, differentiating them by the key value you enter for the key. You also have the option to accumulate the retrieved balance/budget totals.

  6. You access Balance/budget query groups – subtotals, Period. This panel displays the subtotals of the balance and/or budget information for the retrieved key values in the query group.

    7. You can view up to nine columns on this panel. The type of value displayed in each column is defined in the Balance enquiry template. If the query group contains more than three columns (as defined in the Balance enquiry template you are working against), you can toggle all columns by clicking the Column X functions, where X stands for the number of the previous or next column to be displayed.

    View transactions

    Mark one of your account combinations to view your transactions and click OK. The system will then display the transactions that build up the balance. Tip: Click Position file to position yourself in the sub-totals. Exit the routine.

Related topics