This is an old revision of the document!
Compile date: November 15, 2018
Compile date: February 26, 2019
Compile date: May 28, 2019
Compile date: Pending
We discovered that some user installs still had records in the DZ Tax Detail Supplement table with exempt tax detail ID's and these unexpected records had their import status set in such a way that was preventing the rate and boundary import from fully and properly updating the related tax schedules. The following query should return zero records:
select * from DZ00400 where TAXDTLID like '%X'
If any records are returned, they can be removed with the following query:
delete from DZ00400 where TAXDTLID like '%X'
We have fixed this problem by including a step in the import that automatically removes these bogus records. The above workaround is only required if you encounter this problem but are unable to upgrade to the latest build.
When an address has a zip code but no city and/or state, the DynamicZip tax schedule selection process's selection message was “Geocode not found”. While it is true that no geocode was found, the schedule selection process could have continued and returned the default tax schedule for that zip. This update fixes this problem.
The Thomson Reuters ONESOURCE Complete+ Database contains lines that have a city tax but that tax is for a city not found in the line's zip and therefore that tax schedule doesn't get selected. Please see USPS city name not the incorporated city name for more information. These relatively rare situations are now handled by importing the foreign city tax rate as a district tax rate which prevents the resulting schedule from being rejected due to the city name conflict.