Calculating Tax Liable for Vendor Invoice

Sally_Hanham · 2008-08-26

How do I handle a vendor invoice when some line items are tax liable and some line items are not tax liable. I have to check off the Tax Liable field in the header in order for the tax liable field to be checked off in the lines of the invoice. I can't uncheck the line items that aren't taxable. If a line item is not taxable I have set up a NONTAX area code, but Navision is not updating the Amount field in the vendor ledger entry correctly. it's calculating it as zero so my vendor detailed report is wrong when I'm using foreign currency. The Amount LCY is correct but the Amount field is incorrect as it is calculating as zero.

Alex_Chow · 2008-08-26

Sally Hanham wrote:

How do I handle a vendor invoice when some line items are tax liable and some line items are not tax liable. I have to check off the Tax Liable field in the header in order for the tax liable field to be checked off in the lines of the invoice. I can't uncheck the line items that aren't taxable. If a line item is not taxable I have set up a NONTAX area code, but Navision is not updating the Amount field in the vendor ledger entry correctly. it's calculating it as zero so my vendor detailed report is wrong when I'm using foreign currency. The Amount LCY is correct but the Amount field is incorrect as it is calculating as zero.

The amount field is updated when the order is released. Have you tried releasing the order? If it's released, try re-opening then releasing it.

Sally_Hanham · 2008-08-26

I tried to Release the invoice but the problem is if I have a non tax line item, the Amount Including Tax is getting calculated as zero amount when this gets posted to the vendor ledger table, the Amount field is zero. For example:

Tax Liable is checked off in header and I fill in the Tax Area code.

Line 1 = type Item, Quantity = 1, direct unit cost = 100, tax liable yes, tax area = GST.

Line 2 = type Item, Quantity = 1 direct unit cost 200, tax liable = yes, tax Area code = NON TAX.

When I release the invoice, Line 1 Amount Including Tax = $105.00
Line 2 = Amount Including Tax = $0.

So when it posts, the Amount field in vendor ledger = $105.00, but it should be $305.00 - even if I release the invoice

ssingla · 2008-08-27

You can define different tax group code on items and define the setup.

Alex_Chow · 2008-08-27

Sally Hanham wrote:

When I release the invoice, Line 1 Amount Including Tax = $105.00
Line 2 = Amount Including Tax = $0.

So when it posts, the Amount field in vendor ledger = $105.00, but it should be $305.00 - even if I release the invoice

This is NOT the standard behavior of NAV. Has your database been modified by your NSC? You might want to start by checking the modifications in this area.

ssingla · 2008-08-28

Alex Chow wrote:

Sally Hanham wrote:

When I release the invoice, Line 1 Amount Including Tax = $105.00
Line 2 = Amount Including Tax = $0.

So when it posts, the Amount field in vendor ledger = $105.00, but it should be $305.00 - even if I release the invoice

This is NOT the standard behavior of NAV. Has your database been modified by your NSC? You might want to start by checking the modifications in this area.

Also check the Line discount %

Alex_Chow · 2008-08-28

ssingla wrote:

Also check the Line discount %

Yes, that too! :oops:

Howdy, Stranger!

Quick Links

Categories

Calculating Tax Liable for Vendor Invoice

Comments