Diff. item qty disc. for diff. customers

Business Central/NAV Developers Forum
1

I’m wondering why it isn’t possible to create different quantity discounts for differet customers (table 29) or have I missed something??! It have to be possible in the current db I’m working on and I’m very reluctant to change the primary key of table 29 in order to achieve my goal. Anybody with similar problems who already solved it ?? Kind regards Brian Christensen

2

I believe you can create different quantity discounts for different customers by using the Item/Cust. Disc. Gr. field. At the extreme, this approach could require a different code for each customer and for each item. [Navision Help says: The customer/item discount depends on both the customer and the item. The size of the discount is determined by which customer discount group the customer belongs to and which item discount group the item belongs to. ] Dave Studebaker das@libertyforever.com Liberty Grove Software A Navision Services Partner

3

David, the Customer/Item discount is given regardless of the Qty the customer purchases. IMHO Brias wish is quite relevant, and can be solved relatively easy. Lars Strøm Valsted ------------------------- Why can’t programmers tell the difference between Christmas and Halloween? Because OCT(31) = DEC(25)

4

Mea culpa. By just adding a Customer code to Table 29? Or do you have another method in mind? Dave Studebaker das@libertyforever.com Liberty Grove Software A Navision Services Partner

5

My idea is to add Customer Qty Discount Code on table 29 and on the customer table as well. Then on Sales Lines, you need some code to find the right discount. It is quite simple, as far as I see it, but maybe I’m wrong - that has happened before :slight_smile: Lars Strøm Valsted ------------------------- Why can’t programmers tell the difference between Christmas and Halloween? Because OCT(31) = DEC(25)