Sales Prices with Template Item

  • 28 October 2023
  • 3 replies

Userlevel 3

We have a scenario on hand.  


Assume that we have a Template Item SKU as Parent001 with three combination SKUs as follows: 




Each of these products is being sold at a base price of $20

Next let us say on the Sales Prices screen we have defined a quantity break of 5 and a price of $16. 


On the Sales Order, if we add Child001 with the quantity as 10, then the price reflects as expected to show it as $16 each.   

Our customer has a requirement that if someone buys 3 qty of Child001 and another 3 qty of Child002, thus exceeding the break qty of 5 defined at the Template parent level, the Sales Prices should kick in since the discounted break qty price is based defined at the parent level.  


Any thoughts here to achieve without a customization?  


Thanks in advance !!! 






Best answer by Kandy Beatty 1 November 2023, 20:52

View original

3 replies

Userlevel 4

In case the pricing in Acumatica cannot work the way you need it to, there are some great additional pricing products that may be able to help with this functionality.   Rockton Pricing Management could possibly do this, allowing pricing to be driven by more than one line.  With RPM, pricing could be driven from multiple lines on the document, rather than just the current line, but the order of the line items are important when being entered on the document. If interested, you can check out the short video in the Acumatica Marketplace. This video may not show the discounts using multiple lines, but it gives you an idea about what the product can do.  You can also reach out to them to discuss your specific scenarios to see if this product would work for your needs before diving into a customization.

Userlevel 7
Badge +16

@Sai Chettiar 

There is no tiered functionality in Acumatica for what you are looking for. You would almost need a condition on the Sales Prices to state IF 10 were bought of this inventory item, then when 3 are bought of item B it would discount. 


I know it does not help right now, but you could create an idea for what Acumatica could add in the future. 

Userlevel 3

Agreed @kandybeatty49  Thats the situation right no. We are preparing to go ahead with a customization for now since the customer’s business needs this as a key requirement., 


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 — 2024  Acumatica, Inc. All rights reserved