Quantity Discounts

Standard ERP contains three methods that you can use to control pricing if you need to charge different prices for a particular Item depending on the quantity sold:
  1. You can offer different discounts, depending on the quantity sold. This method uses the Discount Matrix register in the Pricing module and is described on this page. If you offer this method to a Customer, it can be in combination with a standard Price List (i.e. the discount can be applied to an Item's Base Price or to a price in a Price List). This method can print the discount percentage on the paperwork (e.g. Invoices) that you send to Customers and, if you are using the Post Discount option in the Account Usage S/L setting, it will post to a Discount Account in the Nominal Ledger. This method also allows you to apply quantity discounts based on weight, volume or value sold, in addition to quantity sold.

  2. You can charge different prices depending on the quantity sold. This option uses "Qty Dep Values" Price Lists and the Quantity Dependent Prices setting and is described here. If you offer this method to a Customer, it will be in place of a standard Price List. This method changes the Unit Price in a sale, so there will be no discount percentage to be printed on paperwork or to post to a Discount Account in the Nominal Ledger.

  3. You can offer a discount on one Item that depends on another Item being purchased (for example, "Buy one get one free" and "Buy any three Items from a selection for a fixed price" offers). This option is described on the Multi-Buy Discounts page.
You can use any of these options in isolation, or you can use them in any combination.

To set up a quantity discount system, you will use two registers that are both in the Pricing module: Quantity Dependent Discounts and Discount Matrices. You should define Quantity Dependent Discounts first, as they are used by the Discount Matrices.

When you enter Quotations, Orders or Invoices, quantity discounts will be applied automatically as appropriate, after an Item's Unit Price has been determined by reference to any Price Lists that may apply.

You can also use quantity discounts on the purchase side, in Purchase Quotation Requests and in Purchase Orders. As on the sales side and with no differences, use the Quantity Dependent Discount and Discount Matrix registers to configure the quantity discounts for the purchase side.

In planning such a discount structure, follow these steps:

  1. Enter the Items with their Base Prices, using the Item register. An Item's Base Price should be its standard sales price. Assign each Item to an Item Group.

  2. Define the various quantity breaks using the Quantity Dependent Discount register in the Pricing module. Quantity breaks can be based on quantity, weight, volume or value. You can define different quantity breaks for different Items, by entering as many Quantity Dependent Discount records as necessary.

    Quantity Dependent Discounts are described in detail here.

  3. The next step is to define the discount percentages for each quantity break, using the Discount Matrix register in the Pricing module. A single set of discount levels (i.e. a "Discount Matrix") can be applied to every Item, or to specific Items or Item Groups.

    Discount Matrices are described in detail here.

  4. You can now assign a Discount Matrix to each Customer or Customer Category. If you use Loyalty Cards, you can also assign a Discount Matrix to each Loyalty Card Membership Level. This will allow you to offer different discounts depending on the level of the Loyalty Card that a Customer holds.

    When you enter a Quotation, Order or Invoice for a particular Customer, the Discount Matrix will be used chosen as follows.

    1. If the Customer has a Loyalty Card, the Discount Matrix will be brought in from the relevant row in the Loyalty Card Membership Level Structure setting in the Point of Sales module.

    2. The Discount Matrix will be brought in from the 'Pricing' card of the Customer's Contact record.

    3. The Discount Matrix for the Customer Category to which the Customer belongs will be used.

    As you add Items to the Quotation, Order or Invoice, discount percentages will be placed in the % discount field in each row. The discount will be updated each time you change the quantity.

    On the purchase side, you can assign a Discount Matrix to each Supplier, using the Supp. Disc Matrix field in the Suppliers’ Contact records ('Pricing' card). This Discount Matrix will be brought in to each Purchase Quotation Request and Purchase Order.

Please follow the links at the end of steps 2 and 3 for more details about those steps for more details and refer here for an illustrated example.


The Pricing module in Standard ERP:

Go back to: