Inventory > Transaction Processing > Price-Cost Percentage Change

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.

See Restrictions and limits.
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.

Option Description
Price code Select this to change prices for existing price codes by a specific percentage.
Another price code Select this to change prices held against price codes based on a percentage of another price code.
Cost

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

See Restrictions and limits.
Inventory cost Select this to make global changes to your inventory costs.

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

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

See Restrictions and limits.
Rounding method options  
Rounding method
Option Description
0-5 decimals Select this to indicate that you want the new price/cost to be rounded according to a specific number of decimals.
Specified value 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
Option Description
All Select this to apply the price changes for all price codes held on file.
List 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
Option Description
No code change Select this to indicate that no commission is applicable to the price code being changed.
Change code 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.
After processing completed

These options are displayed within programs that can be automated. They enable you to indicate the action you want to perform once processing is complete (see Automation Design).

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.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.