Notifications
Announcements
No record found.
Hi All ,
My client has created a Purchase Invoice with single line having a particular item. Now since Item was a gift Item they put 100 % Line discount. But The Item was received through Courier they created another line with Charge(Item). After calculating structure they found that Tax is calculated only for the Charge Amount. But When they post it they got G/L inconsistency Error. I checked through Code and got to know that No Tax Entry is being created. The Nav version is Microsoft Dynamics NAV 2013 (Indian Version) and the database is in SQL Server 2008. Any help will be highly appreciated.Thanks a lot in advance
*This post is locked for comments
Hi,
The problem arises in the structure only. Please check the structure order lines
Hi Rishi
Microsoft Dynamics NAV
---------------------------
The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table. Check where and how the CONSISTENT function is used in the transaction to find the reason for the error.
Contact your system administrator.
Tables can be marked as inconsistent during comprehensive tasks, such as posting. This prevents data from being updated incorrectly.
OK
Is this the same error you got?
Thanks for your reply Narayan but if the problem is in Structure then why the Tax amount is visible in Statistics ?
Yes Oommen I am getting the same error I checked through Code that Tax Entry is not being generated although It is visible in Statistics Window before posting.
There is a codeunit which shows you the Debit and Credit entries for GL CONSISTENT.
Search on web.
Check with that code unit for which account you are having issue and what is the amount.
hI,
Check the structure order lines there would be some mismatch in the Order sequence . Please delete the structure order lines and post
Delete the lines from purchase invoice and recreate it again. after creating the purchase line check the structure order line and tax details which in action of lines and make sure that there is no tax amount is there.
If it is still there then it is something bug and needs to take care.
-saurabh shah
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
