Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Changes in Sales Prices

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Changes in Sales Prices

    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.

  • TryFunction Profile Picture
    TryFunction on at
    RE: Changes in Sales Prices

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

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,895 on at
    RE: Changes in Sales Prices

    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans