Hi,
We have customer that want to use a pretty simple and common price strategy but to our surprise we are not able to solve that with standard functionality in Business Cental.
Here is the case:
Standard price:
The price that is registered on the items. Let's say 100 $ in this example.
Discount:
Discounts are set on item discount groups and combined with customer discount groups. In this example the combination of customer discount group and item discount group gives a discount of 20%.
Campaign price:
A sales price list for all customers that contain prices for some items that are valid for a limited time period. In this example the campaign price is 90 $.
The problem:
Some customers have good discounts through their customer discount group which means their normal net price (standard price minus discount) is better than the current campaign price. But BC does not honor this, it gives the campaign prize even if that gives some customers a higher net price than they are entitled to through their customer discount group.
In the example above we would like the price to be 100 $ minus 20 % = 80 $ but Business Central gives us the price 90 $.
Is there any way to change this behaviour so that the customers always get the lowest net price that they are entitled to?
Thanks,
Jim