Discounts for product groups?

manifold

Hello!

Is it somehow possible to define a discount-% for several different products easily? Let's say that there are 50-100 customers who should all get 15% off from all products that belong to a product group "INDUSTRY" (which includes 1500-2500 different products)...

At the moment, it seems that you allways have to pick the products one-by-one to some Customer Discount Group... Another option is of course to define (one-by-one again) which products belong to some Item Discount Group and then tell Navision that certain Customer Discount Group should include this Item Discount Group. (Hopefully you understand what I mean ;-)

The only problem is that we have thousands of products and the "one-by-one" method requires a lot of work to create and update (for example every time a new product arrives to specific product group, you must remember to add it also in Customer or Item Discount Group) :-(...

There must be some more easier way to handle discounts?

Best Regards,

Timo

zimiwings

Yes, you can define "Item Disc. Groups" and select which products go in that Group. Then you can define a "Customer Disc. Group" (and link the respective Customers to that Group) and link those two groups with the discount they should get.

manifold

Hello!

The basic problem is the selection phase... In our company we use Product Groups (in Item Form: "Product Group Code") and each product group can include over 1000 products.

We wanted to link this Product Group directly to some "Customer Disc. Group"... Because :

1) I assume that otherwise we must pick the products to a "Item Disc Group" one-by-one (takes lot of time to select these on the list).

2) If new products arrive, we always define a Product Group Code... But if there is no way to link Product Group Code to discount groups, we must also remember to add every new product manually to a specific discount group :-/...

In our old ERP system, we had an option to tell the system for example:
- Customer XYZ belongs to discount group ABC.
- ABC discount group means 15% discount for all products in PRODUCT GROUP 1234.
- (We had even an option: ABC discount group means 15% discount for product codes "AA* to DE*", meaning products AA002, BA4324, CC12321, DE12321...)

Regards,

Timo

kine

You can easily customize the Item table that after filling Product group with some code, the discount group will be filled with same code... :-)

themave

We just created a non-printing report to update the discount group based on the filters we set. That way we can change it when needed, just by running a report.

basic idea of report is "If product group = X then Item disc group = X"