This DynamicZip build is compatible with Microsoft Dynamics GP 2019 and the KampData TaxEngine v.4.

Compile date: 11/14/2019

• Skipping inactive customers while correcting addresses and assigning tax schedules is now optional. Previously inactive customers were automatically skipped.

Compile date: 3/24/20

• The SQL optimized import was failing to update the Country Code column in the DZ Zip Address Table to the value entered as the Country Code Default in the DynamicZip Setup window when that option is selected. This has been fixed. The workaround was to run the rate and boundary import with SQL Optimize not selected.
• Added support for import of the Sales Tax Systems 5 Digit Platinum Edition Database.
• Added the option to restrict schedule modifications by detail status in the DZ Modify Tax Schedules window.

Compile date: pending

• Added support for import of the Canada tax rates included in the Sales Tax Systems 5 Digit Platinum Edition Database.

The OS Canada Import was terminating with the following error:

Error: The table DZ Boundary Import temp contains no records - import aborted.

Add rate check to the process that identifies existing tax details. This prevents detail thrashing on schedules from import to import. Some tax rate details included in an import source appear to be for the identical tax with only the rate setting them apart. After this fix, the import will scan for a matching rate and if none is found, will then create a new detail or update the rate on an existing detail. Prior to this update, the import would assume the rate has changed and update it. This can result in rate thrashing among otherwise identical details. This was primarily happening with the states AL, CO and LA. When logging at the info level, this issue would show up with import report messages such as these:

 Info:    70301  B LA LAFOURCHE co 9.6% Modified
 Info:       LASNLAFOURC002 LAFOURCHE co removed.
 Info:       LASNLAFOURC003 LAFOURCHE co added.

In this case the only difference between tax detail LASNLAFOURC002 and LASNLAFOURC003 is their tax rate. If the same issue of the same import source database is imported again, you may see messages such as these:

 Info:    70301  B LA LAFOURCHE co 9.6% Modified
 Info:       LASNLAFOURC002 LAFOURCHE co added.
 Info:       LASNLAFOURC003 LAFOURCHE co removed.

As you can see, the tax schedule's total rate stayed the same (9.6%) but one of that tax schedule's detail ID's was thrashing from LASNLAFOURC002 to LASNLAFOURC003 and back from import to import.

In this case (importing the Complete+ database), LASNLAFOURC002 or LASNLAFOURC003 has a tax rate of 4.15% or 4.9%. The two details both for LAFOURCHE county and both have a location code of 30.

It is unlikely that this bug caused any problems for our users as after each import, the tax schedule will have whichever of the two has the correct rate for that tax location. However detail thrashing is undesirable behavior and this problem has now been corrected.

The DZ Zip Address Import window can be used to import addresses from an alternate source. This import was failing for Canadian addresses. The import process was reporting: No importable records found. This has been corrected.