Compile date: 11/14/2019
Compile date: 3/24/20
Compile date: 9/9/2020
The OS Canada Import was terminating with the following error:
Error: The table DZ Boundary Import temp contains no records - import aborted.
The Tax Schedule Supplement Report was referencing an obsolete table and was depreciated as a result. The report has now been enhanced to provide more information. The detailed version of this report now includes the tax schedules' associated tax details and detail supplement information.
The Import Exempt Customer Taxable Status menu had a couple of problems.
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.
Compile date: 10/21/2020
When SQL Server is set to use the binary (case sensitive) sort order, character casing becomes critical. This release corrects character casing problems.