Solved

How to Configure Discounts to achieve these four goals

  • 24 August 2021
  • 3 replies
  • 213 views

Userlevel 5
Badge +1

Please help us configure discounts to achieve these five goals:

 

  1. Customer Price Classes with 10%, 15% and 18% discounts on some, but not all, Item Classes.
     
  2. Volume Price Discounts of 10% for aggregate purchases of $2,000 from specified Item Classes and discounts of 15% for aggregate purchases of $3,500 from specified Item Classes.  Products from any of the specified Item Classes count to achieving the volume purchase levels. n
     
  3. The customer would get the higher of the Customer Price Discount or the Volume Discount, but not both.  In other words, the customer gets the higher / better of the discounts and cannot “stack” the discounts.
     
  4.  No matter what discount applies, the discount amount is booked on the GL so we can track discounts.
     
  5. The amount of the discount shows on the invoice so the customer can see it. 

Your ideas and help are greatly appreciated.  

icon

Best answer by kristianharianja 27 August 2021, 11:41

View original

3 replies

Userlevel 5
Badge +1

I left off a sixth requirement.  The discounted price for each item must show up on the invoice  

Userlevel 4
Badge +2

Try using group discount with combination of customer price class and item price class and create sequence for system to look up the applicable discount.

Discount Code:

Seq 1: For customer price class 10%.

 

Add customer price class 10% here:

 

For specified item price class that you can link to item class:

 

Seq 2: For customer price class 15%. The break amount of $2K is not relevant here because the customers under this price class will get 15% off discount anyway.

15% customer price class here:

 

and so on, same idea for customer price class 18%.

Note: I am not sure of what purchase quantity (count) affect here as you didn’t put detail for it.

Also, discount amount will be posted to GL after releasing invoice if you specify discount account in customer record (tab GL Accounts).

Userlevel 5
Badge +1

Thank you.  I will test this our sandbox.  I greatly appreciate your ideas.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved