User Tools

Site Tools


dynamiczip:install:mods:release:build82:build82

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dynamiczip:install:mods:release:build82:build82 [2019/12/09 19:45]
chuck [Modifications]
dynamiczip:install:mods:release:build82:build82 [2020/09/17 15:01] (current)
chuck [Build 82.2]
Line 9: Line 9:
 ===== Build 82.1 ===== ===== Build 82.1 =====
  
-Compile date: pending+Compile date: 3/24/20
  
 ==== Modifications ==== ==== Modifications ====
-=== Country Code === 
-The SQL optimized import was failing to update the Country Code column in the [[dynamiczip:​tables:​dz_zip_address_table|DZ Zip Address Table]] to the value entered as the Country Code Default in the [[dynamiczip:​windows:​dynamiczip_setup_window|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. 
  
 +  * The SQL optimized import was failing to update the Country Code column in the [[dynamiczip:​tables:​dz_zip_address_table|DZ Zip Address Table]] to the value entered as the Country Code Default in the [[dynamiczip:​windows:​dynamiczip_setup_window|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 [[dynamiczip:​glossary:​sts|Sales Tax Systems 5 Digit Platinum Edition Database]].
 +  * Added the option to restrict schedule modifications by [[dynamiczip:​glossary:​detail_status|detail status]] in the [[dynamiczip:​windows:​dz_modify_tax_schedules_window|DZ Modify Tax Schedules window]].
 +
 +===== Build 82.2 =====
 +
 +Compile date: 9/9/2020
 +
 +==== Modifications ====
 +  * Added support for import of the Canada tax rates included in the [[dynamiczip:​glossary:​sts|Sales Tax Systems 5 Digit Platinum Edition Database]].
 +
 +==== Bug fixes ====
 +=== OS Canada Import ===
 +The OS Canada Import was terminating with the following error:
 +<​code>​
 +Error: The table DZ Boundary Import temp contains no records - import aborted.
 +</​code>​
 +
 +=== Tax Schedule Supplement report ===
 +The [[dynamiczip:​reports:​dz_tax_schedule_supplement_report|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.
 +
 +=== Import Exempt Customer Taxable Status ===
 +
 +The [[dynamiczip:​windows:​import_exempt_customer_taxable_status|Import Exempt Customer Taxable Status menu]] had a couple of problems.
 +  - The Excel worksheet got created with //​Expiration Date// in cell E1. Then when attempting to read the worksheet, the code was expecting //​Expriation Date// and failing with an error message if it failed to find that misspelled heading. (The workaround was to change the column heading in cell E5 to be //​Expriation Date//.
 +  - The above mentioned error message indicated that the problem was in column 3. It correctly stated E1 but incorrectly stated the column number as 3 instead of 5. This has also been fixed.
 +
 +=== Existing tax detail identification ===
 +
 +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 [[dynamiczip:​glossary:​import_source|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:
 +<​code>​
 + ​Info: ​   70301  B LA LAFOURCHE co 9.6% Modified
 + ​Info: ​      ​LASNLAFOURC002 LAFOURCHE co removed.
 + ​Info: ​      ​LASNLAFOURC003 LAFOURCHE co added.
 +</​code>​
 +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:
 +<​code>​
 + ​Info: ​   70301  B LA LAFOURCHE co 9.6% Modified
 + ​Info: ​      ​LASNLAFOURC002 LAFOURCHE co added.
 + ​Info: ​      ​LASNLAFOURC003 LAFOURCHE co removed.
 +</​code>​
 +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.
 +
 +=== Import of Canadian postal codes ===
 +
 +The [[dynamiczip:​windows:​dz_zip_address_import_window|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.
  
dynamiczip/install/mods/release/build82/build82.1575920752.txt.gz ยท Last modified: 2019/12/09 19:45 by chuck