The List Wizard can be used to view, sort, print and export data to various file formats. The example below uses Supplier Masterfile data, but the process is same for all Masterfiles.
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 can also move or remove fields by clicking and dragging left or right, or upwards 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 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.