Select periods and key values (ANLD5561)

Related topics

• Define a query group

On this panel you can filter information for each valid key in your template. You have several options from which to choose when filtering data as well as several combinations for each option.

Function keys

Template

Displays the selected template with description against which you are running the Query group.

Group

Displays the name of the Query group and its description.

Period range

The default period range is from the first period in the year to the last period in the year. Change to that applicable.

Period relative

By using relative periods you can be certain that the values are retrieved in relation to the actual (current) period. Note: The resulting period range cannot, currently, span over several years. If the Relative period fields are NO, the system will be working with absolute periods which means if you, e.g., type 1 for “From” Period range and 3 for “To” Period range, you will retrieve data for periods 1 through 3.

Note: You always have the option to combine absolute and relative values in your selection.

Example where you want to analyse data in actual period only. (Actual period = October):

• You would enter 0 – 0 (zero) in the Period range fields and Y – Y in the Period relative fields. You will retrieve the values for October.

Example where you want to analyse data in previous period only. (Actual period = October):

• If you enter -1 – -1 in the Period range fields and Y – Y in the Period relative fields, you will retrieve values for September.

Note: When the actual period changes to November and you do not change the values as described in scenario 2 above, you will retrieve values for October.

Example where you want to analyse data in previous period and actual period, where actual period = 10 (October):

• You would enter -1 – 0 (zero) in the Period range fields and Y – Y in the Period relative fields. You will retrieve the values for September and October.

Example where you want to analyse data Year-to-Date. (Actual period = October):

• You would enter 1 – 0 (zero) in the Period range fields and N – Y in the Period relative fields. You will always retrieve values in the first period of your accounting year up until the actual period (in this case October).

Example where you want to retrieve last quarter balances. (Actual period = October):

• Enter -2 – O in the Period range fields and Y – Y in the Period relative fields. You will retrieve values for August, September and October.

Key no

Select the applicable key that you want to filter values on.

Description

Displays the description of the selected key.

From, To and/or Mask

You can narrow down the selection of data that could be retrieved for the selected keys by stating a range (from – to) of values or a mask.

From/To range example:

• If you want to narrow down the selection for the Item key you could, e.g., enter A in the From field and P in the To field. When generating the Balance/Budget Query group enquiry the system will only retrieve data for items A through P.

Mask example:

• In each position of a key field, you can enter a character which corresponds to the values you want to include in the selection.

  For example, 4__________ in the Customer/Supplier field will include only those whose numbers start with a 4. You must complete the positions that are not used with underscore characters.