Change Prices by a Factor of Cost

Accolent ERP provides various utilities that allow for maintenance and updating of Costs and Prices. These utilities are accessed from Price/Cost > Adjust Costs and Price > Change Costs / Price Options. There are three options available: (1) Change Costs and/or Price by a Specified Percentage; (2) Change Prices by a Factor of Costs; and (3) Change one Cost using another Cost. There are a series of wiki articles explaining each of these options. This wiki explains how to change Prices by a Factor of a specified Cost.

Price/Cost Utilities

• The Price/Cost Utilities are accessed from Price/Cost > Change Cost / Price Options.
• The three Change Cost / Price Options wikis are:
  • Change by a Specified Percentage
  • Change Price by a Factor of Cost
  • Change one Cost using another Cost

Select Products

• Use the filters to create a population of products for which the Costs and/or Prices need to be changed.
• In this example, select products AF-ECO, AF-EHD, AF-HDU and AF-STD from Vendor Air Filters R Us.
• Look up List Price, Standard Cost and Alternate Cost for Warehouse 1 for each item:

Change Prices by a Factor of Cost

• Go to Price/Cost > Change Cost / Price Options > Change Price by a Factor of Cost.
• Select Vendor Air Filters R Us.
• Select Warehouse 1.
• Enter a Factor.
• Then select which Cost to use.
• This updates only the Prices based on the Factor x the selected Cost.
• E.g., Select Vendor=107; Warehouse=1; Factor=1.50; Cost=Standard Cost.

• Click on Process button.
• Message indicating success updating 4 records.

Verify Updated Records

• Go to Product AF-ECO.
• List Price = $6.38 x 1.5 = $9.57.

• Updated on Pricing UOM tab.

• Standard Costs are unchanged.

• Similarly, Prices were updated correctly as 1.5x Standard Cost for AF-EHD, AF-HDU and AF-STD.
• Costs were left unchanged.