Language:


The Price Register - The 'Calculate Price Lists' Function

You can run this function can be run after you have defined your Items, Price Formulae and Price Lists. For each Item on each Price List, this function 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 you change a price that is used as a base price by a Formula, you should run the function again to update the Price records. You should also run the function regularly if you have Price Lists in foreign Currencies with exchange rates that change frequently.

To use this function, ensure you are in the Sales Ledger using the [Select Module] button in the Master Control panel 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 Lists setting, Sales Ledger
Enter the code identifying the Price List you want to update. Leave the field blank to recalculate all Price Lists.

Item Group
Error in Link (FOP0106SETTINGS_Item_Groups,Item Groups, 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 you do not specify a Price List, prices will be recalculated for all Price Lists in which the Item Group is included.

Item
Paste Special    Itemregister
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).

Supplier
Paste Special    Suppliers in Customer register
Enter a Supplier Number to limit the Price recalculation to Items that have a Default Purchase Item in the name of that Supplier. This field will only be visible if you have the Purchase Orders Value Pack.
When you click [Run], the function may take a few minutes to run, depending on how many prices you are updating.