The Price Register - The 'Calculate Price Lists' Function

This function can be run once you have defined Items, Price Formulae and Price Lists. For each Item on each Price List it will calculate a new price using the Formula specified and save it in a Price record. This will result in there being a single, unique, Price record for each Item/Price List combination, making the use of Price Lists in Orders and Invoices extremely fast. As a consequence, each time a price that is used as a base price by a Formula is changed, the function should be run again to update the Price records. The function should also be used regularly if you have Price Lists in foreign Currencies with exchange rates that change frequently.

If, in a particular Price List, the Qty Dep Values option is being used, this function will save to the Quantity Dependent Prices setting instead of the Price register. Again, this setting will feature a single, unique, Price record for each Item/Price List combination. Note, however, that these records will not be updated when the function is run on later occasions.

If there is both a Price record and a Quantity Dependent Price record for the same Item/Price List combination, priority will depend on how the Price List has been defined. If the Price List is of Discount Type, the Price record will be used, while if it is of Qty Dep Value Type, the Quantity Dependent Price will be used.

To use this function, ensure you are in the Pricing module using the Modules menu and select 'Maintenance' from the File menu. Double-click 'Calculate Price Lists' in the subsequent list. The following dialogue box appears:

Leave all fields blank and click [Run] to calculate all prices. To restrict the calculation process, use the fields as described below before clicking [Run].
Price List
Paste Special    Price List register, Pricing module
Enter the code identifying the Price List you want to update. Leave the field blank to recalculate all Price Lists.

Item Group
Paste Special    Item Group register, Sales Ledger
Limit the calculation to a single Item Group. Prices will only be recalculated if the Item Group is explicitly included in the grid of the Price List specified in the field above. If no Price List is specified, prices will be recalculated for all Price Lists in which the Item Group is included.

Paste Special    Item register
Limit the calculation to a single Item. The Item does not have to be explicitly included in the grid of the specified Price List: its Price will also be recalculated if its Item Group is in the grid or if the first column of the grid is blank (i.e. if the Price List includes all Items).

Paste Special    Supplier register
Enter a Supplier Number to limit the recalculation to a single Supplier. Prices will be recalculated for Items that have a Default Purchase Item in the name of that Supplier.

Add Item Markup to Base
Select this option to apply the Markup % (specified on the 'Pricing' card of the Item record) before the Price Formula.
When you click [Run], the function may take a few minutes to run, depending on how many prices you are updating.