# Quantity Based Discount Pricing

### Question Status

rschaefer asked a question on 10 Apr 2014 2:53 PM

Hello,

I'm using Nav 2009 RTC

How do I set up discounts based on the quantity being purchased?  If a customer purchases 1 pc it is \$10 ea, 5 pcs it is \$7 ea, 10 pcs it is \$5 ea etc.

I know it has to be there somewhere, but I can't figure it out.

Thanks for the help!

Rachel

Daniele Rebussi responded on 10 Apr 2014 11:45 PM

Can suit for your requirements using Purchase Prices, where you can define for a single item different unit costs based on the quantity purchased?

msdn.microsoft.com/.../hh173237(v=nav.70).aspx (this link can be applied also to NAV 2009)

Alex Chow responded on 11 Apr 2014 12:12 PM

You're looking for the Sales Price table.

From the customer card click on customer --> prices. Fill in the Minimum Quantity and the Unit price.

Daniele Rebussi responded on 10 Apr 2014 11:45 PM

Can suit for your requirements using Purchase Prices, where you can define for a single item different unit costs based on the quantity purchased?

msdn.microsoft.com/.../hh173237(v=nav.70).aspx (this link can be applied also to NAV 2009)

rschaefer responded on 11 Apr 2014 10:09 AM

What if I wanted an entire product group to have a percentage discount.  If you bought a single piece it was X price, if you bought a box is was 15% off, and if you bought a case it was 25% off.

Alex Chow responded on 11 Apr 2014 12:12 PM

You're looking for the Sales Price table.

From the customer card click on customer --> prices. Fill in the Minimum Quantity and the Unit price.

rschaefer responded on 11 Apr 2014 12:37 PM

No, I don't want it customer specific.

Savatage99 [MVP] responded on 11 Apr 2014 1:09 PM

Do you have table 29 - Item Sales Qty. Disc.

There you can create a code that you set on each item

Set the minimum Qty & a discount %

code - min - discount

A1 - 5 - 5

A1 - 10 - 6

A1 - 15 - 7

rschaefer responded on 14 Apr 2014 1:51 PM

I do not have table 29. :(

Alex Chow responded on 16 Apr 2014 9:11 AM

The Sales Price can be by customer group, for all customer, for campaign. Not only by customer.

rschaefer responded on 16 Apr 2014 9:15 AM

Alex,

How would it be done for all customers instead of just customer groups?  I was checking it out and that would take forever if I did it for all groups.