Inconsistency Error In Navision 3.7 with HF11

diptish.naskar

I am using Navision 3.7 with hotfix 11 [India Localization], while posting a sales invoive I am having an inconsistency error. Does nayone have the solution...

Luc_VanDyck

Try posting the same Sales Invoice on the same database without hotfix 11. Yo do have a backup of that database prior of the hotfix installation, right? If you can post the Sales Invoice on that database, it's likely that hotfix 11 is the cause of it. You then need to contact Microsoft India who has created that hotfix.

chrispaul

Hi diptish there is a consistency code in Codeuni 12 try posting your invoice blocking that 2 or 3 line code if it works then i can tell u where exactly the problem lies
Go to codeunit 12 and find the word consistent, there u will find that code

ara3n

A better solution can be found in here on how to see the GL entries for inconsistent entries.

http://www.mibuso.com/forum/viewtopic.php?t=11142&highlight=single+instance

diptish.naskar

I have tried posting the same in the sales invoice but the biggest issue is all the other areas are hit except the G.L entry table. I have found the code in the codeunit 12 and commented the same and at time time it worked....but with a little complication..this is specially for chris...all the areas are hit except the g/l entries.

I have changed the code to Consistency(true);

Can you please help me regarding the same

Soumyadip

Check all your customizations in posting routines. Specially all those scary comments....what i feel is the tax amount in your Gen Jnl is not being populated properly from sale invoice.

ssingla

Can you specify the exact error message appearing.
Also in the Indian localization there is problem with codeunit "Calculate Indian Sales Tax " which creates GL inconsistency error due to decimal calculation.
Try changing quantity/value in the sales lines and then post. It might work as i have done the same a couple of times.

veerabhadra

Hi

Check for Invoice Rounding Precision & Excise rounding precision in General Ledger set-up and Invoice Rounding Precision in Curriencies set-up and be ensure that the values are same in both the setup's