This feature allows a price or the published cost to be increased or decreased based on a percentage of itself or another price or the published cost. For example, you can make Price Level 1 10% less than the list price.
To use this feature, 1) Select the locations to update, 2) Select which item(s) to update, and 3) Select which prices to update.
Locations to Update
Update | Master UOM | Local Inventory Items |
All Locations | Updated | Items for all locations will be updated regardless of whether they use master-level pricing. |
All Master Pricing Locations | Updated | Only items for locations using master pricing will be updated. |
Non-Master Pricing Location(s) | Not Updated | Only items for the selected location(s) not using master pricing will be updated. |
Items to Update
Update by | Local Inventory Items |
Item | Updates only the item selected. |
Manufacturer | If Product Line is not selected updates all items assigned to the selected manufacturer. If a Product Line is selected, refer to Product Line. |
Product Line | Updates all items assigned to the manufacturer and product line selected for that manufacturer. Items in sub-product lines for the selected product lines are not updated. |
Product Group | Updates all items assigned to the product group selected. Items in sub-product groups for the selected product group are not updated. |
Prices to Update
Examples
Make Price Level 1 10% less than the List Price
If the List Price is $100.15, Price Level 1 would become $90.14. 10% less than the List Price is 90% of the List Price. (100% - 10% = 90%)
90 is the percentage you would enter: $100.15 x 90% = $90.14
Make Price Level 1 10% more than the List Price
If the List Price is $100.15, Price Level 1 would become $110.17. 10% more than the List Price is 110% of the List Price. (100% + 10% = 110%)
110 is the percentage you would enter: $100.15 x 110% = 110.17
Increase the List Price by 12.5%
If the List Price is $99.15, the List Price would become $111.54. 12.5% more than the current List Price would be 112.5% of the List Price. (100% + 12.5% = 112.5%)
112.5 is the percentage you would enter: $99.15 x 112.5% = $111.54
Decrease the List Price by 12.5%
If the List Price is $99.15, the List Price would become $86.76. 12.5% less than the current List Price would be 87.5% of the List Price. (100% - 12.5% = 87.5%)
87.5 is the percentage you would enter: $99.15 x 87.5% = $86.76
Make the List Price, Price Levels 1 & 2 more than the Published Cost
If the Published Cost is $42.95, then the List Price would become $57.98, Price Level 1 would become $55.84, and Price Level 2 would become $53.69.