Price-Cost Percentage Change

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.

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 Code Maintenance) 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 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.

Price code list

Select this to enter a list of price codes for which you want to change prices.

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 that you want 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 will be posted.

Period year

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

Stock codes

Stock code selection

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

Warehouses

Warehouse selection

Indicate the warehouse(s) for which you want 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 you want to change the price assigned to price codes.

Suppliers

Supplier selection

Indicate the supplier(s) for whom you want 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

The results of the processing function you selected are displayed in this pane once processing is complete (unless you enabled the option to close the application from the After processing completed section). You use this section to print or email this information.

Hint and tips

You can use the 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 - General tab) when processing a cost change or when processing a price change based on cost.
When the Percentage based on is set to Cost or Inventory cost, then all warehouses with a costing method of FIFO or LIFO are ignored (Inventory Setup or Browse on 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 Electronic Signatures program.

eSignature Transaction	Description
Inv Change price by percentage	Controls access to the Price code Change function of the Price-Cost Percentage Change program.
Inv Change price percentage on other price	Controls access to the Another price code Change function of the Price-Cost Percentage Change program.
Inv Change price by percentage on cost	Controls access to the Cost Change function of the Price-Cost Percentage Change program.
Inv Change cost by percentage	Controls access to the Inventory cost Change function of the 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.

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.
Right-click any form field.

You can also click the triangle menu icon that appears in the title area of a pane.
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.

Select the Close icon in the right-hand corner of the application help pane.
Confirm that you want to delete the pane.