Update Item Pricing

Modified on 12/27/2024 08:58 AM by Sharon Duckett — Categorized as: Uncategorized

Table of Contents [Hide/Show]

Locations to Update
Items to Update
Prices to Update
   Examples
      Make Price Level 1 10% less than the List Price
      Make Price Level 1 10% more than the List Price
      Increase the List Price by 12.5%
      Decrease the List Price by 12.5%
      Make the List Price, Price Levels 1 & 2 more than the Published Cost

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.