I have four taxes set up in my system, and confirmed in the TAX table in the database:
ID Description Rate
1 Sales Tax 0%
2 VAT 15%
3 VAT-EX 0%
4 VAT-ZR 0%
If I create a new item, and select VAT, then check the ITEM table, the TaxID = 3 for that item. You would think that the system would apply the VAT-EX taxation on the item. However, when i do a transaction, it puts the 15% rate on the item and everything seems work out okay, including the reports, which show that VAT was collected. The TransactionEntry table has the proper sales taxes applied based on what tax was selected in the Manager.
If I select VAT-ZR for the item, the TaxID in the Item table is set to 5, which does not exist in the Tax table.
The sales tax analysis report works perfectly.
Let's say I change the tax codes of all items using SQL:
UPDATE Item SET TaxID = 3
When I go back into SO Manager, all of the items show the tax selected is VAT.
It's +/- 1 from the Tax database table.
Weird!!!
Any ideas?