Issue:
When an order is cloned, its taxes drop completely or calculate incorrectly.
- When shipping is removed from the order by selecting Do Not Ship on the Shipping tab, the taxes calculate correctly. Re-adding shipping drops the taxes to zero.
Resolution:
There is a disagreement in the company's Tax Exemption status. Check the company's record in the account table. Look for the TaxExempt and IsFullyTaxExempt values. If TaxExempt is 0 and IsFullyTaxExempt is 1, change IsFullyTaxExempt to 0.
Warning: The following query set makes changes to the Account table. BACK UP THE DATABASE BEFORE USE OF THESE QUERIES.
Query to locate company ID:
- select ID from account where companyname like '%%'
Query to find tax exemption satuses:
- select taxexempt, isfullytaxexempt from account where id =
Query to update IsFullyTaxExempt status:
- update account set isfullytaxexempt = 0 where id =
See Also
- Backlinks include_pagepage_componentbacklinks
You could leave a comment if you were logged in.