Inventory Price-Cost Percentage Change

You use this program to make global changes to either the selling price or the inventory cost of your stock items.

Toolbar and menu

Field Description

Start Processing

Changes the prices according to your selections in the Price/Cost Percentage Change Criteria pane.

You are prompted to enter missing information that the program requires to complete processing and to confirm that you want to process the changes.

Change Criteria

Change the criteria in the Price/Cost Percentage Change Criteria pane.

Price/Cost Percentage Change Criteria

Field Description

Change function

 

Percentage based on

When the Percentage based on is set to Cost then a negative percentage can be used. For all other selections, you need to use the Increase/decrease options to change the price/cost.

The option you select here determines which other criteria are made available in this pane.

Select this to change prices for existing price codes by a specific percentage.

Select this to change prices held against price codes based on a percentage of another price code.

Select this to change prices associated with a price code by adding a percentage to the unit cost of a stock item.

Select this to make global changes to your inventory costs.

Any changes to the inventory unit costs are recorded in the inventory journal table. In addition, for each stock code against which you are retaining stock movements (Stock Codes) changes are recorded in the stock movement table.

If Inventory is linked to the General Ledger in summary or detail (General Ledger Integration) then details of the ledger codes involved in each cost change transaction are printed.

This field is disabled when using the pricing engine, i.e. when the Pricing method setup option is defined as Price groups (Setup Options > Configuration > Distribution > Sales Orders), as this not catered for in the Price List Review program.

Rounding method options

 

Rounding method

Select this to indicate that you want the new price/cost to be rounded according to a specific number of decimals.

Select this to enter a specific value according to which you want the new prices/costs to be rounded.

No. of decimals

Select the number of decimals required for rounding. An entry of 0 (zero) indicates that you want the new price to be rounded to a whole integer, while entries of 1, 2, 3, 4 or 5 indicate the decimal to which you want the new prices/costs to be rounded.

Value

Indicate the specific value according to which you want the new prices/costs to be rounded.

Print options

 

List changes on printer

Select this to print a list of all stock codes that were changed during processing within the current run of the program.

You can print an audit trail of any changes made to either the price of stocked items or the pricing basis of stocked items using the Inventory Price History program.

Print prices without updating

Select this to view the effect of the price changes you entered without actually updating the prices.

When you select this option, the option: List prices on printer is automatically selected and a report of your intended changes is produced.

If, after you have checked the report, you are satisfied with the results, you can re-enter the changes and update the prices.

Percentage information

 

Percentage change

Indicate the percentage by which the price held against prices codes must change.

If you selected Percentage based on - Another price code, then an entry of 0.00 here, enables you to copy a price code without changing the actual price.

If you selected Percentage based on - Cost, then an entry of 0.00 here enables you to make the price equal to the unit cost.

Increase/decrease

Indicate whether to increase or decrease the price.

Increase

Select this to increase prices by the percentage specified.

Decrease

Select this to decrease the price by the percentage specified.

Price codes to change

 

Price code selection

Select this to apply the price changes for all price codes held on file.

Select this to apply the price changes to a selective list of prices codes.

Select price codes for a stock code

This option only applies when Price code selection is List and Stock code selection is Single.

Select this to apply the list of price codes to a single stock code.

Price code list

Select this to enter a list of price codes for which to change prices. The list is only applicable to a single stock code when Select price codes for a stock code is enabled, otherwise the list applies to All stock codes or a Range of stock codes as specified at the Stock code selection option.

Price change based on another price code

 
Basic price code Indicate the price code from which the price change must be calculated.
Price code to be updated

Indicate the price code to which the price change must be made.

A new price code entry is not created if a zero value is held against the price code from which the change must be calculated.

Create price code if not on file

Select this to create a new price code if your entry at the Price code to be updated field is not defined for any of the selected stock codes.

Commission code for changed price code

 

Change code selection

Select this to indicate that no commission is applicable to the price code being changed.

Select this to assign a new commission code to the changed price code.

Commission code

Indicate the commission code that you want to assign to the changed price code.

Warehouse for cost

 

Warehouse to use for cost

Indicate the warehouse from which the cost of the stock item will be extracted to update prices.

Warehouse description

This indicates the description of the warehouse code you selected.

Inventory cost percentage change

 

Cost change journal reference

Select this to optionally enter a reference for the cost change to print on the Inventory Journal Report report. This reference defaults to 'cost-chg'.

Posting information

 

Period month

 This indicates the Inventory period to which entries must be posted.

Period year

This indicates the Inventory year (within for the period) to which entries must be posted.

Stock codes

 

Stock code selection

Indicate the stock code(s) for which to change the price assigned to price codes.

Warehouses

 
Warehouse selection Indicate the warehouse(s) for which to change the price assigned to price codes.

This is only available when the Inventory cost option at the Percentage change function field is enabled.

Product classes

 

Product class selection

Indicate the product class(es) for which to change the price assigned to price codes.

Suppliers

 

Supplier selection

Indicate the supplier(s) for whom to change the price assigned to price codes.
Countries of origin

This lets you filter stock codes by their country of origin.

When a single country of origin is selected, only stock codes matching that country are returned for processing. The default is All, which returns stock codes regardless of their country of origin.

After processing completed

These options are displayed within programs that can be automated. They let you indicate the action you want to perform once processing is complete.

Price/Cost Percentage Change Review

This pane displays the results of the processing function you selected once processing is complete (unless you selected the option to close the application from the After processing completed section).

Hint and tips

  • You can use the Inventory Price History program to print an audit trail of changes made using this program.

Notes and warnings

Restrictions and limits

  • This program ignores any items that use Actual costing (Inventory Setup) when processing a cost change or when processing a price change based on cost.

  • When the Percentage based on option is set to Cost or Inventory cost, then all warehouses with a costing method of FIFO or LIFO are ignored (Inventory Setup or Warehouses). Items in warehouses using FIFO or LIFO costing are therefore not updated.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the eSignature Setup program.

eSignature Transaction Description

Inv Change price by percentage

Controls access to the Price code Change function of the Inventory Price-Cost Percentage Change program.

Inv Change price percentage on other price

Controls access to the Another price code Change function of the Inventory Price-Cost Percentage Change program.

Inv Change price by percentage on cost

Controls access to the Cost Change function of the Inventory Price-Cost Percentage Change program.

Inv Change cost by percentage

Controls access to the Inventory cost Change function of the Inventory Price-Cost Percentage Change program.