Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Quantity Based Discount Pricing

(1) ShareShare
ReportReport
Posted on by 9

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

  • rschaefer Profile Picture
    9 on at
    RE: Quantity Based Discount Pricing

    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.

  • Alex Chow Profile Picture
    4,481 on at
    RE: Quantity Based Discount Pricing

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

  • rschaefer Profile Picture
    9 on at
    RE: Quantity Based Discount Pricing

    I do not have table 29. :(

  • Community Member Profile Picture
    on at
    RE: Quantity Based Discount Pricing

    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 Profile Picture
    9 on at
    RE: Quantity Based Discount Pricing

    No, I don't want it customer specific.

  • Suggested answer
    Alex Chow Profile Picture
    4,481 on at
    RE: Quantity Based Discount Pricing

    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 Profile Picture
    9 on at
    RE: Quantity Based Discount Pricing

    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.

  • Suggested answer
    Daniele Rebussi Profile Picture
    2,480 on at
    RE: Quantity Based Discount Pricing

    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)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans