Tax Calculation in Microsoft Dynamics NAV 2013

(0) Share

Report

Posted on by Rishi1109

155

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

_________________
Thanks and Regards
Rishi

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Saurabh Shah 4,560 on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

Hi,

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
Suggested answer

Community Member on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

hI,

Check the structure order lines there would be some mismatch in the Order sequence . Please delete the structure order lines and post
ManishS 80 on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

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.
Rishi1109 155 on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

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.
Rishi1109 155 on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

Thanks for your reply Narayan but if the problem is in Structure then why the Tax amount is visible in Statistics ?
Community Member on at

Like (2)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

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?
Community Member on at

Like (0)

Report

RE: Tax Calculation in Microsoft Dynamics NAV 2013

Hi,

The problem arises in the structure only. Please check the structure order lines