Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

Multi-Level Discounts

Multi Level Discount is a common practice of some of our clients especially for wholesale distributors where multiple discounts are applied to an item/order. Multi-Level Discount is illustrated below.
 
Suppose I have the following details on purchase order for Item X:
Order Qty: 3
Unit Cost: 60
Ext. Cost: 180
Discount Given: 2%, 3%, 4%
 
Above discount has 3 levels which is computed as follows:
For 2%:
Level 1 Discount: 180 * 0.02 = 3.6
Level 1 Net Cost: 180 - 3.6 = 176.4
 
For 3%:
Level 2 Discount: 176.4 * 0.03 = 5.292
Level 2 Net Cost: 176.4 - 5.292 = 171.108
 
For 4%:
Level 3 Discount: 171.108 * 0.04 = 6.84432
Level 3 Net Cost: 171.108 - 6.84432 = 164.26
 
Therefore the Order Total is 164.26
As can be seen from above illustration, the net cost of each level depends on the result of net cost from the previous level. 

Note: Multi-Level Discounts can also be applied in a Sales Order for customer.
  • Gherley Joy Lois Cello
  • Nov 9 2017
  • Already exists
  • Attach files
  • Gabriel Michaud commented
    November 09, 2017 08:04

    Hello Gherley,

    Third level of discounts can be achieved by using group discounts.

    So you can have: 1 level - line discount, 2 level - group discount, 3 level - document discount.