Dynamics Community Forum Thread Details

Tax/VAT codes transactions missing depending on Legal entity using Virtual Tables

HI Everyone,

Appreciate you help here, this very critical. We have five legal entities in same country; they share the same tables for Tax Groups, Item Tax Groups and tax codes using virtual tables.

The problem comes when making an order the tax matrix Tax matrix is working for some companies and not for other companies.

for example: On one legal entity when selling a Tax free item to a domestic client the Vat code ZERO "shows correctly in VAT transaction" but if I make the same order in another legal entity No TAX code appears in the Tax transactions (like a missing i join). The only difference that I see is in the the TaxOnItem and TaxGroupData the RecVersion is 1, I dont know if this has any meaning.

again greatly appreciated for your time and support.

VAT group = Cust/Vend Item VAT group = Items	S-DOM	S-EU	S-EU-full	S-3RD	P-DOM	P-EU	P-3RD
A - Full VAT of goods and services	doA	~~euA~~ *(Exempt)	euA	~~3rdA~~ (Exempt)	doA	euA **(Use tax)	3rdA
B - reduced VAT (processed foods)	N/A	N/A	N/A	N/A	doB	euB	N/A
C - reduced VAT (natural foods)	N/A	N/A	N/A	N/A	doC	euC	N/A
ASSET - VAT on assets	N/A	N/A	N/A	N/A	doASSET	N/A	N/A
FUEL - VAT on fuel - half to be deducted	N/A	N/A	N/A	N/A	doFUEL	N/A	N/A
ZERO - Tax free	~~ZERO~~	~~ZERO~~	~~ZERO~~	~~ZERO~~	~~ZERO~~	~~ZERO~~	~~ZERO~~