Spire’s Price Matrix allows the user to set pricing for customers and groups of customers in many different ways.
Add/Edit Price
Save – Saves the price.
Save & Close – Saves and closes the price.
Copy – Copies a price record.
Whse – Warehouse for the price. If this is left blank then the price applies to all warehouses.
Part No – The item getting the price.
Unit of Measure – The UOM of the item getting the price.
Product Code – Used if applying the price to a product code. Can only be used if Part No is blank.
Customer – The customer getting the price.
Ship To – Use this if the price is restricted to only one of the customer’s Ship To’s.
Territory – Use this if the price applies to a complete territory.
User Type – Select a ‘User Type’ from the lookup list if the price is for a group of customers. Each customer would then get assigned to that group in customer edit/General/Type.
Date Range – The starting and ending dates for this price. Many ranges can be added as long as they do not overlap. If a sales order is created for a past date, and a price matrix record exists for that date the order will be given this price.
High Priority – Makes this price the highest priority. It overrides all other methods that a could be assigned even if there is a lower possible price for this customer for this item. (See Price Matrix Scoring Below)
Price Method – The method for this price. The choices are:
- Price – A set price for this item.
- Discount – A discount off of ‘Default Price’ as described above.
- Margin – If selected the sell price will be based on this formula. InventoryCurrentCost / (100-Margin%/100)
Cost Method – The cost used for a margin calculation. Choices are Current, standard or average.
Promotion – The reason this price is being offered. It could be a contract number of something like ‘FLYER’. This reason will appear on the sales order detail line.
Vendor – If there is a GL account in Company Settings/General Ledger/Differential GL Account then a vendor can be added and a contract cost added below.
Contract Cost – The cost that will be applied when selling to this customer. If this cost is different than the average cost, the difference will be posted to the GL account set in Company Settings/General Ledger/Differential GL Account. This is usually a vendor rebate account. This way when selling an item that has a contract cost the inventory GL account is still credited by the average cost.
Default Price – The price the customer would get if they did not get this special price. It comes from the level that the customer is set for and this is the price that price matrix discounts would be based on.
Average Cost – The average cost from inventory.
Current Cost – The current cost from Inventory.
Standard Cost – The standard cost from Inventory.
Add – Add a price, discount or margin.
Delete – Deletes a price.
- Min Qty – Adds a quantity if the price has a minimum quantity.
- Price – The Price, Discount or Margin amount.
- Price per X – If an item and warehouse has been selected then a unit of measure can also be selected for this price.
- Margin – The margin that this item will obtain based on this price. Only shows is item and warehouse are selected.
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. The customer will be given the price that has the highest score, unless the company setting -> Sales Orders -> Orders ‘Match Lowest Price in Price Matrix’ is set. If it is set, then the lowest matching price will be given to the customer.
Click this link to download the price scoring spreadsheet
Price Matrix List
This list can be filtered and exported if mass updates need to be done using the Spire import routine. Be sure to include the record number if the import should replace the prices that are already there. If it is not included and a price already exists then the user will get a duplicate error on import.
Purge Previous – Allow to set a date the Spire can use to determine which Price Matrix entries to remove.
Save Prices from Sales Order
Prices can also be added from a sales order or quote. Once an order is created the user can select the prices button and choose:
- Store All Price – This will store all prices from this sales order to the customers price matrix file.
- Store Selected prices – This will save the edited prices to the customers price matrix file.
Once clicked the user will be given these options.
Update Records in the price matrix based on the following criteria:
- Create Records for regular prices – Even if the price is note edited this will add a record to the customers price matrix file. They will get regular price for this item. However if the regular price changes they will still continue to get this stored price unless the user also updates it.
- Apply to all Warehouses – Apply the price to all warehouses. This way the customer gets the same price even if they go to another location.
- Restrict records to shipping address – If selected then only the ship to on this sales order gets this added to their price matrix file. If not selected then the billing and all ship to addresses get this price. If a ship to is not on the order then it is grayed out.
Once added and saved the user can view or edit them on the list.