Price List
This report, available from the Pricing and Sales Orders modules 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 window 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 Group register, Sales Ledger
- Range Reporting Alpha
- To limit the report to a single Item Group, enter an Item Group Code here.
- If both a range of Items and a range of Item Groups is specified, the report will cover only those Items in the range which are members of the specified Item Groups.
- Price List
- Paste Special
Price List register, Pricing module
- 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 to the 'Pricing' card of the Item screen.
- Language
- Paste Special
Languages setting, System module
- Enter a Language Code here to produce a Price List using translated Item Names (as entered on the ''Texts' card of the Item screen). If there is no translation for the selected Language, the main Description entered in the header will be used.
- Function
- These options control the format of the report.
- External
- Select this option to print sales prices together with the Item Code and Description.
- Internal
- This option prints sales prices, cost prices, gross profit and gross margin.
- 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 with Balance
- Select this option if you only want Items of which you have stock to appear in the Price List.
- 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.
- Multiply with rate (Currency from Price List)
- If the Price List has a Currency, but you would like to show its Prices converted to the home Currency using the current exchange rate, use this option.
- Sorting
- The report can be sorted by Item Number, Item Group or Item Name.