Quantity Based Discount Pricing

(1) Share

Report

Posted on by rschaefer

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

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Daniele Rebussi 2,480 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
rschaefer 9 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Alex Chow 4,481 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
rschaefer 9 on at

Like (0)

Report

No, I don't want it customer specific.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
rschaefer 9 on at

Like (0)

Report

I do not have table 29. :(

Was this reply helpful? Yes No
Alex Chow 4,481 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rschaefer 9 on at

Like (0)

Report

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.

Was this reply helpful? Yes No