Different sales prices for 2 customers, 1 bill-to customer

vissers9

Hi all,

We have a customer with multiple ship to addresses. It's a retailer with different "formulas".
Based on the ship to code (which is a different depot for a retail formula) the sales prices differ.
Our system has been changed so the sales prices are calculated based on Variant codes, but this is messing up a lot in the ILE.

I'm looking for a standard solution in NAV.
What I still want to have is all invoices on 1 customer card!
1. What I tried is to make 2 different customers with the respective ship to addresses and prices. Prices setup through Sales Price. This works, but when I invoice I don't have the invoices on 1 customer.
2. After that I set the bill-to customer of the 2nd customer the same as the first. It turns out the sales prices are looked up based on the bill-to customer, so I don't have different prices.
3. Tried to give different Price Groups on the 2 customers, still having the same bill-to customer. Again, the sales price group is taken from the bill-to customer.
Not giving the result I expected (hoped, actually ).

Is there another way to accomplish this (with standard Nav), still have the invoices on 1 customer card?

Thanks, Rob

Andwian

I never tried, but worth:
Try to setup the Sales Price using Campaign.