Templates control the retrieval and sequencing of data. You can create/customise as many templates as desired, thereby retrieving just the information you are looking for. A/R enquiry templates can be created in two ways:
- Adding a new template through the Work with A/R enquiry templates menu item.
- Saving your entered selections as a template when working in the A/R enquiry programs. Click Save as template on any of the A/R transactions enquiry panels to prompt a pop-up window where you can directly save the selections and sequences that you are currently working with, either in a new or an existing template.
Once you have selected a template it will follow you through the different enquiry programs. The last template you used will be the one defaulted when you enter the enquiry the next time. To create a new template according to the first option above, do as follows:
- Select the Work with A/R enquiry templates menu item.
- On the Work with A/R trans enquiry templates, click Add.
- You access the first of three panels of the program. Complete the following fields:
- Template
- Enter a code that represents the template that you are creating. Note: Once the template has been created, this field cannot be changed.
- Description
- Enter a description for the template.
- Debtor number
- Document type
- A/D
- Enter the code for ASCENDING for both sequences.
- Caution:
Scroll or click Previous/Next to toggle the selection and sequence panels. If you click Back, then you will return to the Enquiry program selection panel and your recent entries, those which are not saved in the template, are erased
Selection part 1 and 2
Enter the selection parameters you want to include in this template. Selection can be made via range selection or combined selection, depending on the parameter. Enter selections, for example, in the following fields:
Sequence
Scroll down to the sequence part of the Work with A/R trans enquiry templates panel, which is the third panel. The sequence you define determines how the information is presented. Sequence 1 gives the primary sort order, sequence 2 sorts the information further within each selected parameter selected with sequence 1, and so on. Enter sequence 1 for Debtor number and 2 for Document type.
Click OK. You can continue to enter templates, change values for existing templates, or exit the routine.
Related topics
- About making enquiries on A/R transactions, balances and statistics
- Make an enquiry on A/R transactions
- Show A/R balances
- Show A/R statistics
- Drill across to the Distribution invoice enquiry
- Drill down to A/R settlement details from the main settlement document
- Drill down to A/R settlement details from other documents