The following process is an alternative method that can be used to convert the DZ Tax Detail Supplement table from build 69 or earlier 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.

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

DynamicZip Tables
Table Conversion Scripts