Price List
This report, available from the Sales Support module and the Sales Ledger, prints a Price List. It is a report that perhaps might be sent to a text file so that it can be incorporated in your publicity material. To do this, decide upon the contents of the report using the screen illustrated below in the usual fashion. Then, choose 'File' from the Media options at the bottom of the window. When you click [Run], you will be asked to name the text file and to specify where it is to be saved.
Leave all the fields blank if the report is to cover all Price Lists. If it is necessary to restrict the coverage of the report, use the fields as described below.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- To limit the report to a single Item, enter an Item Number here.
- Item Group
- Paste Special
Item Groups setting, Sales Ledger
- Range Reporting Alpha
- To limit the report to a single Item Group, enter an Item Group Code here.
- If you specify both a range of Items and a range of Item Groups, the report will cover only those Items in the range that are members of the specified Item Groups
- Price List
- Paste Special
Price Lists setting, Sales Ledger
- Specify which Price List is to be printed here.
- By default, all Items or, if you have also specified a range of Items and/or a range of Item Groups, all Items in the range, will be printed irrespective of whether or not they have been included in the Price List. The Price shown will be taken from the appropriate Price record or, if there isn't one, from the Base Price of the Item record.
- If you only want to print those Items which fall within the range and which have been included in the Price List, use the Only Items from this Price List option (below).
- Leave this field blank if you wish to print the Base Price of each Item, as entered on the 'Pricing' card of the Item screen.
- Function
- These options control the format of the report.
- External
- Select this option to print sales prices (including and excluding VAT) together with the Item Code and Description.
- Internal
- This option prints sales prices excluding VAT, cost prices, gross profit and gross margin.
- Sorting
- The report can be sorted by Item Number, Item Group or Name.
- Items with Balance only
- Select this option if you only want Items of which you have stock to appear in the Price List.
- Prices Incl. VAT
- Check this box to print prices including VAT in the report. This option applies to the External Price List only.
- Prices Excl. VAT
- Check this box to print prices excluding VAT in the report. By checking this box and the one above, both inclusive and exclusive prices can be shown in the same report. This option applies to the External Price List only.
- Only Items from this Price List
- By default, the report will list all Items in the selected range, irrespective of whether they have been included in the Price List. The Price shown will be taken from the appropriate Price record or, if there isn't one, from the Base Price of the Item record.
- If you only want to show those Items which fall within the range and which have been included in the Price List, check this box.
