The following process is an alternative method that can be used to convert the DZ Customer Tax by State table from build 69 or earler to Build 70 or later. The DZ Table Status window provides the standard method for table conversions.

1. Create a temp table to store the contents of the existing permanent table.
2. Copy the records from the existing permanent table to the new temp table.
3. Drop & Recreate the existing permanent table to replace it one having the new format.
4. Copy the records from the temp table to the new permanent table.
5. Drop the temp table.

Use the attached SQL scripts to perform steps 1, 2, 4 and 5 above. You will need to modify the name of the company database from MACRO to whatever is appropriate for your installation.

dz01102-1-createtemp.sql
dz01102-2-copytotemp.sql
dz01102-4-copytonew.sql
dz01102-5-droptemp.sql

DynamicZip Tables
Table Conversion Scripts