incorrect_tax_calculation_when

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 =