Language:


Changing the Prices of Items in Batches

You can change the Base Prices of many Items at one stroke using the 'Update Item Base Prices' Maintenance function in the Sales Ledger. 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, ensure you are in the Sales Ledger using the [Select Module] button in the Master Control panel 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 Groups, 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.

% Adjustment
Enter here the percentage by which the Base Prices of the selected Items are to be recalculated. For example, to increase prices by 10%, enter "110". To reduce prices by 10%, enter "90". 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 the specified percentage adjustment.

If necessary, you can deny access to this function using Access Groups.