web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Changes in Sales Prices

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Verified answer
    Suresh Kulla Profile Picture
    50,241 Super User 2025 Season 2 on at

    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.

  • TryFunction Profile Picture
    on at

    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...

  • Community Member Profile Picture
    on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans