407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 5824)

Invalid tax code 'Y' passed to ReturnTaxableBooleanBasedOnTaxCode

This information applies to :

Article ID
5824

Created/Updated
April 7, 2016

Category
Updates


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
In QuoteWerks receive error about Invalid tax code 'Y' passed to ReturnTaxableBooleanBasedOnTaxCode

Cause:
Some of the data migrations from builds prior to Build 28 to a newer build.
SPECIAL NOTE:
This only applies to users with the Canadian Tax Scheme. Do not use this if you switch between US or Other Tax Scheme to Canadian and vice versa. This can be rectified by running two separate SQL Commands. You may want to contact QuoteWerks Technical Support to walk you through this process.

Solution:
Note, this solution is for QuoteWerks:
1. No one can be in QuoteWerks when you do this.
2. Make a backup of your DOCS.MDB file in the root of your QuoteWerks directory.
3. To use the SQL Commands, Go to the Start->Programs->QuoteWerks ->Tools & Information menu and select Medic Utility.
4. Click Utilites -> Data Manager for QuoteWerks databases...
5. Password --> Data
6. Select the Docs.MDB database.
7. Paste the following in your SQL Command box:
update documentitems set extratext01="B" where extratext01="Y"
8. Press Execute/Run
9. Paste the following in your SQL Command box
update documentitems set extratext01="N" where extratext01="N"
10. Press Execute/Run
11. Exit the Medic Utility and Launch QuoteWerks.

New Search