Inconsistency Error.

Deep

Hi,

I am getting an inconsistency error while posting a purchase invoice.
The transaction includes line discount on every line(2%) and VAT 12.5%.

I have already used ara3n's SingleInstance Codeunit to find out the difference.
The difference is somewhere in VAT only and is -0.02.
I have checked all the setups, I tries removing roundings, but no use.
Kindly help.

](*,) ](*,) ](*,)

matttrax

I want to say you can look at Statistics or something and change the VAT amount there. We've done something before where we get a similar problem. I remember it was a link off the actual order and we didn't have to change code or go into any tables to fix it.

I hope that's a start anyway.

Deep

I want to say you can look at Statistics or something and change the VAT amount there.

I have tried to change the tax amount over statistics. But once I start posting, it again gets changed to the original one.
](*,)

Alex_Chow

What version are you using?

It's most likely caused by rounding being used in one place but not the other. You might want to look to see if any service packs addresses the issue.

kine

Your NAV version?

David_Singleton

Hi Deep,

I will take a guess that you are using NAV with the Indian tax system. This is fraught with problems, and rounding issues is one of them. You are going to need to work out the exact version Service pack and hot fix you have. Then try to reproduce the error on a Cronus DB. if you can then you need to contact MS to see if there is a fix for it.

If you can't reproduce it then you need to see if you have made any code changes that might of caused it.

Dave_Cintron

An old trick, if you haven't used it, and have the courage:

Comment out the CONSISTENT statement in CU12.
Post out of balance.
Evaluate the results and fix the problem.
Manually correct G/L to be in balance.
Remove comment on the CONSISTENT statement.

David_Singleton

Dave Cintron wrote:

An old trick, if you haven't used it, and have the courage:

Rashed's solution with a single instance code unit is easier, faster and safer.