Language:


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.