Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

Posted on by Microsoft Employee

The statistics is correct but doesn't match the outstanding invoice total which is incorrect.  It's adding tax individually.  Should add 2 lines and calculate, instead it's calculating sales tax per line.  But the statistic is showing it correctly, as does the tax posting line.  

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    8.0.42603.0

    this post still has not been resolved...

  • Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    The build is 5 digit number which you can find by going -> Help -> About Microsoft Dynamics NAV there it shows something like 8.1.xxxxxx....

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    what is "build".  i'm in navision 2015 if that's what you mean?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    I've done those numbers with 3 different "customers" (me) with the same tax info and got the same result.  I only posted 1 of them though.  I would delete the invoice each time it came out wrong but was having the same issue in all.  

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    What is the Navision build you are running, and can you recreate the same issue ? I believe it is something to do with that order .

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    So, my consultant suggested posting the invoice and when I did that and refreshed the customer page, the outstanding balance is the correct amount.  He thinks it's a NAV glitch.  My worry with it is when we are up and running and the salesmen start entering, they are going to see that "outstanding invoice" $ and give it to the customer and will always collect the wrong tax.  We need to get that resolved before that happens.  any suggestions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    They are both correct, on their own, but together it's off.  It's correct if you print the invoice and on the statistics.  But that Outstanding Invoice amount is wrong.  I did notice that when I did that Ctrl+Alt+F1 and drilled down, table 116 has "Prepayment Tax Calc. Type" and it says Normal VAT.  Would that have anything to do with it?  We are US, we don't have VAT tax.  I Just can't find where that table relates to so I can fix it.  If that has any relevance at all anyway...?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    In your screenshot it shows the outstanding invoice also has the same amount, if you drill down it will show the sales lines which is taking the value from OUtstanding Amount (LCY), if you zoom on the sales line using Ctrl + Atl + F1 and check  the fields value what is the outstanding amount  and outstanding amount ($) are they both same on the line?

    They should be same if they are in same currency, if they are different means your order is not in US dollar.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    everything should be USD as I'm in Florida.  Nothing under Foreign Trade is filled in.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: SALES INVOICE TOTAL DOESN'T MATCH STATISTICS

    The amount it shows in the statistics is in US Dollar, can you check on the order, Foreign Trade Tab if you have currency code filled in. If so the amount you are looking at order Statistics is in order currency, the customer statistics is in US currency.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans