Hello,
There is a change in NAV 2018 when the system gets the sales prices, but I don't know if this is new behavior or an error. This is the new functinallity:
In Cronus, the customer 01121212 has setting up as "Bill-to Customer No." the customer 01454545. In previous versions, when we use the customer 01121212 in a sales document trought the "Sell-to Customer No." field, NAV got the price setting up for the customer 01454545, in other words, NAV got the sales price based on the "Bill- to Customer No."
In NAV 2018 the system searches the price based on the "Sell-to Customer No." field. I don't know if it is a change or an error, because when I use "Sales pricing groups" NAV still gets the "Sales Price Group" set on the "Bill- to Customer No." instead of getting the "Sales Price Group" set on the "Sell-to Customer No" .
Anybody has any idea about this new behavior?
Thanks a lot!
VÃctor.
*This post is locked for comments
Thank you Suresh!!!
I found the code before I asked you about the problem, but doubts came to me bacause I didn't know if it was a functionallity change or a bug. I think it is a bug or an incomplete change of functionallity.
I will modify this function up to a new cumulative will be released.
Thank you for your answer.
VÃctor.
You are wrong Suresh. That function is not in the table 37 (Sales Line). Is also in the Codeunit 7000. The best way to modify this is subscribing to the event "OnGetCustNoForSalesHeader" and overwriting the CustNo. It seems like a bug, because in other parts of the codeunit that require to search sales prices, they use the "Bill-to Customer No.". Lets see next cumulative update...
Victor,
That is true, I just verified and in NAV 2018 they are using Sell-to Customer No. and I think that is a bug. To fix you need to modify the GetCustNoForSalesHeader function in the Sales Line Table to use Bill-to Customer No. Hopefully, they can fix this in next cumulative update. Nice Catch.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156