Language:


Changing Prices of Items in Batches

Another method for changing the Base Prices of many Items at one stroke is the 'Update Item Base Prices' Maintenance function in the Pricing module. This function allows you to change Base Prices using a formula, so it will be useful if, for example, you want to change all Base Prices by 10%.

To use this function, move to the Pricing module using the Modules menu and choose 'Maintenance' from the File menu. When the 'Maintenance' list is opened, double-click 'Update Item Base Prices'. The 'Specify Item Prices' window is displayed:

Item Group
Paste Special    Item Group register, Sales Ledger
Enter an Item Group here if you want to update the Base Prices of all Items belonging to that Item Group.

Items
Paste Special    Item register
Range Reporting    Alpha
Enter an Item Number or range of Item Numbers here if you want to update the Base Price of a specific Item or of a range of Items. You must enter either an Item Number here or an Item Group in the field above, otherwise no Base Prices will be updated. Do not leave both fields empty in the hope of updating the Base Price of every Item in the database.

Price Formula
Paste Special    Price Formula register, Pricing module
Enter here the Price Formula record that is to be used to recalculate the Base Prices of the selected Items. If this field is left blank, Base Prices will not be changed.
When you click [Run], the Base Price of each selected Item will be recalculated using to the specified formula.

A similar function, 'Update Item Cost Prices' (also in the Pricing module) allows you to change the Cost Prices of many Items at one stroke. This operates in an identical manner to the 'Update Item Base Prices' function. Another Maintenance function, 'Update Item Cost Price' in the Stock module, changes Items' Cost Prices to the latest purchase prices (i.e. to the prices in the latest Goods Receipts). This function, which can be applied to Stocked Items only, is described here. If necessary, you can deny access to these functions using Access Groups as described here.