The List Wizard can be used to view, sort, print and export data to various file formats.
The list wizard can be accessed on ANY Masterfile screen. i.e. anywhere there is an Enquire or Maintain menu item.
You access the list wizard by clicking in the Code field for the Enquire or Maintain program, then clicking the F2 function on your keyboard, then F11 to open the list wizard screen.
An example of using the List Wizard for Supplier Masterfiles.
The example below uses Supplier Masterfile data, but the process is same for all Masterfile (Maintain or Enquire) programs.
Go to Suppliers, Masterfiles, Suppliers, Enquire.
Select Find F2 in the Masterfile on the Supplier Code.
Choose Output (F11) to open the List Wizard.
The screen opens in the Show Default Columns view but you can switch to Show All Columns or add individual columns by using the Add Columns button.
Click in the Search for a column field and type the field name you require or scroll up and down to find the field.
Field names are generally similar but may be slightly different to the field labels in the Masterfile. At the end of this article is a list of equivalent field names.
You can search for parts of the field labels to find the required fields.
Click and drag the required columns from the Add Columns window to the column header area (you will see arrows up and down when it's int the correct place).
You can also move or remove fields by clicking and dragging left or right, or upwards out of the table to remove them.
To apply a filter to the data, hover your mouse over the column header to display the funnel icon in the top-right corner.
When you have finished making the report, you can click Print All to print all the results to screen.
Alternatively, click Print Selected or Print Not Selected by clicking and dragging down the required records from the selection column at the far left of the table.
After printing to screen, print it or export it to your required format, for example, CSV or XLSX.
