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
8.0.42603.0
this post still has not been resolved...
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....
what is "build". i'm in navision 2015 if that's what you mean?
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.
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 .
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?
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...?
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.
everything should be USD as I'm in Florida. Nothing under Foreign Trade is filled in.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156