Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Problem with sales order list page when there is an error in one sales order line

(0) ShareShare
ReportReport
Posted on by

We sometimes have users who do not enter a sales tax group code on one line of a sales order.  When someone searches for a particular sales order by paging down, NAV throws an error that the sales tax group code is missing but doesn't give the sales order number.  After this error, the person gets a blank list.  The only way to fix this that we have found is to enter "TAXABLE" as the sales tax group code on the offending line and then everything works fine.

It appears that NAV is checking every single sales order when you page down the sales order list.  In older versions of NAV, you would not get the error flagged until you posted the sales order.

Can anyone tell me if there is a fix for this problem?

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: Problem with sales order list page when there is an error in one sales order line

    You could modify the error message so that it includes the No. of the order that is missing the Tax Group Code.

    Do you know how to do this? This article explains fairly well.

    msdn.microsoft.com/.../dd355305(v=nav.90).aspx

  • Community Member Profile Picture
    on at
    RE: Problem with sales order list page when there is an error in one sales order line

    I have used the debugger and the error usually is a sales order line with a missing Tax Group Code.  We have corrected the problem each time and put the Tax Group Code on customers so it defaults on new sales orders but the main issue is that NAV apparently scans ALL sales orders in on the list page.  If the missing Tax Group Code is on the second page, the error is caught when you page down.  NAV doesn't tell you which sales order is causing the problem.  I understand that scanning all sales orders even though you are only looking at a list might be valuable but this error stops the entire company from working on sales orders when it happens.

  • Community Member Profile Picture
    on at
    RE: Problem with sales order list page when there is an error in one sales order line

    I've started through the CUs and hotfixes but have not found the answer yet.  Thanks for the suggestion though.

  • Verified answer
    AJAnsari Profile Picture
    5,754 on at
    RE: Problem with sales order list page when there is an error in one sales order line

    In addition to Alexander's response, if you are on an older build / Cumulative Update (CU) of NAV 2017, check this list of released CUs for NAV 2017:

    support.microsoft.com/.../released-cumulative-updates-for-microsoft-dynamics-nav-2017

    Here, you can click through the builds / CUs newer than the one you have, and look/search through the list of hotfixes in the build. Perhaps it has been addressed already in a recent CU.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Community Member Profile Picture
    on at
    RE: Problem with sales order list page when there is an error in one sales order line

    Hi Myrmel,

    Which version of NAV are you using? Also, my suggestion would be to use the debugger in NAV and find which line of code is causing the error message.

    This blog gives a pretty good explanation of how to use the debugger. https://saurav-nav.blogspot.com/2012/08/debugging-in-nav-2013-client.html 

    Regards,

    Ted

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Problem with sales order list page when there is an error in one sales order line

    Are you using US localization? To me it looks like a bug so far, which should be reported...

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans