- Select the Balances and budgets enquiry program.
- You access Balance/budget enquiry. Click Query groups.
- On the Query group selection panel, click Maintain groups.
- You access Query group maintenance. Click Add.
- On the detail panel, complete the following fields:
- Query group
- Enter a name of the query group. This is the name you will refer to when you want to run the query group.
- Description
- Enter a description of the query group.
- You access Select periods and key values, Query group maintenance. Complete the following fields:
- Period range
- Enter a period range if you want to override the period range defined for the query group. Both relative and absolute periods can be entered. Tip: Blanks in period range means Actual period.
- Relative
- Set to YES if you want the period to be relative to actual period.
- Key
- Enter the keys you want for this query group. The first key in every sequence must also be the first key in the query group. The other keys in the sequence must not be included. Click Selectable keys to view the keys from which you may choose.
- Description
- The description of the selected key field is automatically retrieved. Tip: Click Description to view the description for the keys you have selected.
- From value
- Enter the range start value.
- To value
- Enter the range end value. If you leave the field blank, then the system will use the last number in the range.
- Mask value
- Enter a mask value. For example, a mask value for accounts beginning with C.
Click OK.
Tip: Click Fold to view the length and type for the keys you have selected. Click OK and exit the routine.