Error on Purchase Statistics

(0) Share

Report

Posted on by Sandra Van den Hecke

In de BE Dynamics Nav 2016

When you have multiple Purchase invoices with VAT and you request the statistics page for 1 invoice the calculations are wrong. The system is adding values from the previous invoice VAT lines.

Is there a hotfix available????

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

There is an issue fixed related to the statistics in CU4

377895 When you change the VAT amount in the purchase invoice statistic line, the VAT amount in the statistics header does not change unless the page is closed and reopened.

Try applying that hotfix.

Was this reply helpful? Yes No
Sandra Van den Hecke 15 on at

Like (0)

Report

Sorry but that is not the issue

The calculation itself is all wrong, We didn't change anything.

The system is calculating with values from other records.

This problem occurs even in the new CU11

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Have you made any customizations in the database ?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

It seems like some customization done on the page . Kindly take help from developer or contact partner

Was this reply helpful? Yes No
Sandra Van den Hecke 15 on at

Like (0)

Report

The problem was noticed by one of our customers so we installed the latest complete version at out company last week.

So no changes were made.

We traced the problem back to I to the VAT lines. And I think the problem starts if you use Non-deductible VAT.

If you post the invoice everything is correct but if before posting you open the statistics screen you get a mix of numbers.

The problem is reproducible

Was this reply helpful? Yes No
Sandra Van den Hecke 15 on at

Like (0)

Report

Nope clean install latest CU BE localization.

Problem is reproducible

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Did you try to reproduce in latest update of clean BE version?

if yes then you can report it to Microsoft.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

As Mohana said, try this in a default DB and if the issue still exists then report it to Microsoft. They will provide you and separate hot-fix or add the issue to next CU.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

To me it looks like a bug. You should report it to your partner and to Microsoft.

Was this reply helpful? Yes No