Purchase Order Price Change Review Grid

When creating or Modifying a Purchase Order, changes in purchase costs can initiate suggestions to update the sell price. Additionally, the Vendor Markup and Price Model features will initiate suggestions or requirements for price changes.

In cases where price change suggestions are being identified by an increase from the previous price or a change made to a Vendor Markup or Price Model, these items will be displayed in the Price Review Grid. No change in prices and the grid will not be shown.

The Price Grid provides the user with one place to make pricing decisions for the items on the Purchase Order. It also provides the user with valuable analysis data related to variances and profitability goals.

Field and Feature Details

Key/Name - From this screen the user can double click on any item to view the Item Record.

Price Each - This is the current price on the Purchase Order

Extra Cost - This reflects the assigned value for freight or other costs added in the subtotal section.

Current Sell - This is the Sell Price currently in Item Record

Amount Change - When the New Sell price is changed, the difference between that price and Current Sell is shown here.

% Change - Same as Amount but in a percentage format.

Margin % - This reflects the current Margin % based on the New Sell and Price Each displayed.

New Sell - This will show what the Sell Price will be updated to if the Save button is selected.

New Retail - Same as Sell

New Floor - Same as Sell

Update for all locations -

Leaving this selected (recommended in most cases) means that any items associated with the line item by a Header will also have their prices updated to what is on the grid.

If that feature is unchecked, only the key/item on the PO will change. If you have a Bulk Header on the PO, when the item is received and serialized, that bulk serialized key/item will not have the updated pricing. Bulk items do not use the header to establish price when received.

Typically, a user would only uncheck this feature when they sell items under the same header for different prices at other locations - it is best to put the location’s bulk item on the PO... not the header. Or, if you have older non-bulk serialized items (older model of power tool) and you want the prices of these older items to remain different than the newer items you will be receiving. Because non-bulk, serialized items use Header pricing when received, they will capture this new pricing but the ones already in the system will remain unchanged.

Option - This is where Quantity Discount pricing can be updated. This grid will also suggest pricing to maintain margins.

Show only price or cost changes - When unchecked, all items on PO appear in the grid.

Apply suggested sell price -

- This feature will adjust the Sell Price to maintain the Margin% you were getting from the previous Purchase Price.

- Markup % or Price Model applied: This feature will not do anything. The Markup % or Price Model will calculate the price.

 

Reset - This will put the whole grid back to the state it was in when it first opened. You can also right click on an individual row and Reset it.

Other Right Click features (not available to user when a Price Model is used):

- Apply Current Sell Price: If there was a calculation that changed the Sell Price, this will put it back to the current value.

- Apply Suggested Sell Price: This is a row level option for that performs the same as the check box detailed above for all rows.

 

Save - Updates the Sell, Retail and Floor prices as shown for the key number presented. Plus, any 'related by Header" items at all locations with that option checked.

Security features - Security settings are required to make edits within the Price Review Grid

New Sell Color References

Green - This indicates a Markup or Price Model formula is calculating the New Sell price.

Yellow - This reflects a calculation to maintain current Margins due to a price change.

Blue - This reflects an edit has been made overriding any displayed pricing.