How to set up quantity sold discounts for your products
Description

The Sage quantity sold discount reduces the net selling price of a product.

NOTE: The quantity discount is available in Sage 50 Accounts Professional only and can't be applied to suppliers.

This article uses the following example:

You sell the same product to three different customer types, Retail, Wholesale, and Trade.

  • Retail customers receive a discount of 5% when they purchase 10 or more of this product.
  • Wholesale customers receive a 10% discount if they purchase 10 or more, or a 15% discount if they purchase 50 or more.
  • Trade customers receive a 20% discount on every item and a 25% discount if they purchase 20 or more.
Cause
Resolution

Create a Product quantity discount

NOTE: This procedure uses the example, table A is for retail customers, table B for wholesale customers and table C for trade customers.

  1. Click Products and services and select the product for which you want to create the quantity discount.
  2. Click Edit then click Discount.
  3. Complete the relevant discount table as follows:
    DiscountIndicates the level ofthe discount. This cannot be changed.
    QuantityEnter the quantity of the product required for a customer to qualify for a discount, for example, 10.
    Discount %Enter the discount to be applied when the customer buys the relevant quantity of the product, for example, 5.
    Discount ValueThis calculates automatically and is the net price of the product less the percentage discount you entered.

    NOTE: If you're setting up discounts for different customer types, the discount table selection must be consistent on each Product Record. For example, all discounts for retail customers must be entered on table A, all discounts for wholesale customers must be entered on table B and all trade discounts set up on table C.

    If required, repeat this step for Level 2 and so on, until all of the required levels for this table are complete with the relevant quantity and discount percentages.

    To create another discount table for this Product, click the relevant discount tab and repeat this step.

  4. Click Save then click Close.

For the quantity discount to automatically adjust the net selling price of the product, you must also apply the discount table letter to the customer record. For further information about this, please refer to the section, To apply the discount to the Customer Record.

Copy the Product discount tables

NOTE: This procedure copies all of the discounts from the selected product record. If you want to copy only one discount table, from within the table window, click Copy Matrix then follow the on-screen prompts.

  1. Click Products and services and select any stock code then click Copy discount.
  2. From the Select Product to Copy From list select the product record from which you want to copy the discount table.
  3. From the Select Product to Copy To list select the products you want to copy the discount table to.
  4. Click OK then click Yes and click OK.

The discount tables are now copied to the selected Product Record. For the quantity discount to automatically adjust the net selling price of the product, you must also apply the discount table letter to the customer record. For further information about this, please refer to the following section.

Apply the discount to the Customer Record

  1. Click Customers then select the required customer and click New/edit.
  2. Click Defaults then click Additional Discount and choose the quantity discount you want to offer this customer.

    NOTE: You can only apply one discount table letter per customer.

  3. Click Save then click Close.

    Repeat steps 1 - 3 for any other customers to whom you want to apply a discount.

You've now applied a quantity discount to your customer records. The next time you create a product invoice, the additional discount is applied to the net selling price of the product.

[BCB:121:Limitless - 50 Accounts - Products and Services:ECB]
Steps to duplicate
Related Solutions