Setting Up Price Lists For Parts Discounts

Price Lists can be used for, amongst other things, creating customer discount structures for parts sales. For example, you may have some customers on a ‘Standard’ price list, who receive no discount, and some customers on a ‘Preferential’ price list, who receive various levels of discount depending on the category of parts they are buying.

Price Categories

Before setting up a Price List, you first need to consider how to categorise your parts for issuing discounts. These categories are known as price categories, and can be named however you wish. Some companies give their price categories a letter (e.g. A, B, C, D etc.) and some companies give their price categories a description (e.g. Filters, Consumables, Major Parts, Minor Parts etc.) Each part can only appear in one price category.

  • To setup your price categories, go to System > Stock > Price Categories
  • In the Stock Price Category column, enter the name or description you wish to use for each category
  • The Percentage Margin column can be left as 0.00% for all categories – this screen isn’t used for specifying the actual discount
  • Click Close once you have setup all of your price categories

The price categories can then be assigned to stock records using the dropdown list on the Stock Enquiry screen

Price Lists

Now you have defined the price categories and applied them to your stock records, you can setup your customer price lists.

  • Go to System > Price Lists. You can see the prices lists that are already setup using the Price List dropdown at the top left of the screen. In the example below, we are looking at the Default price list

  • You can create a new price list by typing over the name of the price list displayed, and press enter on the keyboard. In this example, a price list has been created called ‘10% Discount’

  • Next, you need to define what the Default Price Calculation will be. This applies to any parts that either don’t have a price category, or if the price category isn’t selected within the price list. There are various options for price calculations as follows:
    • Actual Cost Plus %: This would use the average cost of the part and add a percentage uplift
    • Actual Cost Plus Value: This would use the average cost of the part and add a set value on top
    • Standard Cost Plus %: This would use the standard cost of the part and add a percentage uplift
    • Standard Cost Plus Value: This would use the standard cost of the part and add a set value on top
    • Standard Price Less %: This would use the standard sell price of the part and apply a percentage discount
    • Standard Price Less Value: This would use the standard sell price of the part and deduct a set value
    • Supplier RRP Less %: This would use the supplier’s recommended retail price for the part and apply a percentage discount
    • Supplier RRP Less Value: This would use the supplier’s recommended retail price for the part and deduct a set value
  • For a basic price list, you only need to fill in the Default Price Calculation line to achieve a set discount ‘across the board’. In the above ‘10% Discount’ example, the Price List is set to discount 10% from the standard price of all parts
  • For a more complex price list, you may wish to setup some Price Category Exceptions beneath the Default Price Calculation. In the example of the ‘Preferential Discount’ below, the customer gets a range of discounts from certain price categories, but for any price categories that aren’t selected, the default price calculation of standard sell price is used

  • Finally, it is possible to setup exceptions for individual parts. In the below example, the part selected will always be priced at £150 to customers on the Preferential Discount price list, regardless of fluctuations in cost or sale prices

  • Once you have finished setting up the price list, you can either Close the screen, or create another price list by carrying out the above steps again

Allocating Price Lists to Customers

Price lists can be allocated to customers within the Accounts tab of their customer record using the Price List dropdown. If a customer has multiple sites, each site record can have a different price list, so you must ensure each one is setup individually

Was this article helpful?

Related Articles

Leave A Comment?

You must be logged in to post a comment.