Spire’s Price Matrix allows the user to set special pricing of inventory items or product groups for individual or groups of customers when entering Sales Orders in many different ways.
A list of all Price Matrix records can be seen within the module list grid, and can be filtered or searched within. Each record has a unique ID code determined by the program when the record is created. You can add new records directly from here, or from within a Sales Order if you choose to Store Prices for the customer.
Purge Previous – Delete all price matrix records that have an End Date earlier than a specified date.
Edit Price Matrix
Save – Saves the price record and leaves the screen open.
Save & Close – Saves the price record and closes the screen.
Copy – Copies this price record to create a new record.
Whse – Warehouse for the special price. If this field is blank then the price applies to all warehouses.
Part No – The inventory item for the special price. If this record is to give a special price for all items within a Product Code, the Part No can be blank.
Unit of Measure – The UOM of the item receiving the special price, which is only available after the item is selected for a specific warehouse. Choose from or a particular unit.
Product Code – Applying the special price to all items assigned this product code. You can only enter a value when the Part No field is not used.
Customer – The customer getting the special price. If this record is to give a special price for all customers within a Territory or Customer Type, the customer can be blank.
Ship To – The shipping address code of the customer receiving the special price, which is only available after the customer is selected. Leave this field blank to use the special price for all addresses of the selected customer.
Currency – Applying the special price to all customers assigned this currency code. You typically would use this field instead of assigning a specific customer.
Territory – Applying the special price to all customers assigned this territory code. You typically would use this field instead of assigning a specific customer.
User Type – Applying the special price to all customers assigned this type value. The field label is customizable in Company Settings, and is usually used for categorizing customers into groups. You would use this field instead of assigning a specific customer.
Date Range – The starting and ending dates for this special price to be used in Sales Orders. Multiple price matrix records can be created with different date ranges and prices, as long as the date ranges do not overlap.
High Priority – This special price overrides all other methods that a price could be assigned to a Sales Order, even if there is a lower possible price for this customer for this item. (See Price Matrix Scoring Below)
Price Method – How the special price is determined, which updates the amount column title in the grid below. The choices are:
- Price – A set price for this item.
- Discount – A discount by percentage from the unit price of the inventory item.
- Margin – The sell price will be calculated from inventory item unit price and the cost value selected below.
Cost Method – The cost value used from the inventory item for the margin calculation. Choices are Current, Standard or Average cost.
Promotion – The reason this price is being offered, if desired. It could be a contract number or a sale price source such as ‘FLYER’. This reason will appear on the sales order detail line, along with optional promotion colour formatting, when this price matrix record is used to set the price. You can also create special prices by quantity ordered across multiple items that use the same promotion code – for more information about this, read the Cumulative Quantity Breaks manual topic.
Vendor – Used in conjunction with the Contract Cost value below to assign a special Cost of Sale amount when this customer orders this item, supported by your company purchasing the item from this vendor.
Contract Cost – Used in conjunction with the Vendor value above to assign a special Cost of Sale amount when this customer orders this item. Any cost difference will be accounted for in a Cost Variance account you specify in Company Settings. For more information about this, read the Contract Cost manual topic.
Default Price – The unit price of the selected inventory item, based on the sell price level of the customer if one is selected. Price Matrix Discounts are calculated from this amount. It is also helpful as a reference when determining a special Price amount for the customer and item.
Average Cost – The average unit cost value from the inventory item.
Current Cost – The current unit cost value from the inventory item.
Standard Cost – The standard unit cost value from the inventory item.
Add – Add another price, discount or margin value if you are using different prices by quantity ordered.
Delete – Deletes the highlighted price row by quantity ordered.
Prices grid
- Min Qty – Specify the minimum quantity a customer must order to receive the price on this line. Multiple price lines can be entered using different minimum quantities, typically with lower prices assigned to higher quantities.
- Price – The Price, Discount or Margin amount as determined from the method.
- Price per X – If an inventory item and warehouse has been selected, this column is visible and displays the unit price for the selected unit of measure.
- Margin – If an inventory item and warehouse has been selected, this column is visible displays the margin that this item will obtain based on this price. It also replaces the Price column when the price is defined with Margin as the Pricing Method.
Price Matrix Scoring
Since a customer can qualify for a price with more than one price matrix entry, each type of price is given a score based on an internal ranking method. The customer will be given the price that has the highest score, unless the Company Setting within Sales Orders for ‘Match Lowest Price in Price Matrix’ is set, or if one Price Matrix record has been configured as High Priority. The customer then always receives the High Priority or lowest possible price.
Click this link to download the price scoring spreadsheet
Save Prices from Sales Order
Price Matrix records can also be added from a sales order or quote. When an order is edited, you can select the Prices button and choose either:
- Store All Prices – This will save or update the prices from all inventory items on this sales order to price matrix records for this customer.
- Store Selected Price – This will save or update the prices from highlighted inventory items on this sales order to price matrix records for this customer.
When the price storage method is chosen, a screen will appear with some options:
- Create records for regular prices – Even if the price on the order was not changed from the default item unit price, a Price Matrix record will be added for this customer. This locks in the item price for this customer even if it changes in the future.
- Apply to all Warehouses – The price matrix record is created with a blank warehouse field value, meaning that the customer will be charged the same price for this item even if they order it from a different warehouse location.
- Restrict records to shipping address – You can only enable this option if a ship to value was selected on the order. The price matrix record is created with the customer shipping address from the order, meaning that the special price only applies when this customer ships the item to that address.
Continuing from this screen will add or update the price matrix records for the specified items for the customer.