SQL Optimized Tax Schedule Assignment

Added to the DZ Assign Customer Tax Schedules window in DynamicZip Build 73.9.
Added to the DZ Assign Vendor Tax Schedules window in Build 74.

As of DynamicZip Build 74, the stored procedure has been replaced with Dexterity pass-through SQL statements.

NOTE:The error message “Unhandled script exception: [Microsoft][SQL Server Native Client x.x][SQL Server]Could not find stored procedure”can occur after upgrading from any build older than DynamicZip Build 73.9 to a newer version of Build 73. Please see Assign Schedules Unhandled Script FAQ for help with this error.

This option modifies the assign customer tax schedules process to run using SQL stored procedures. By using SQL stored procedures, the time it takes for the assign customer tax schedules process to complete can be greatly reduced.

This option enables DynamicZip to select tax schedules based on the Geocode stored in the DZ Customer Address Supplement window

• If a customer address record's Geocode is blank, then DynamicZip will select a tax schedule based on the Customer Address Maintenance window City, State, and ZIP code.
• If a customer address record's Geocode is not blank, then DynamicZip will select a tax schedule based on the ZIP code and Geocode

This is the original functionality used for customer tax schedule assignment and is strictly address based. DynamicZip will only use the Geocode saved in the DZ Customer Address Supplement window if it is valid for the Customer Address Maintenance window City, State, and ZIP code. If the Geocode is not valid, then it is ignored .
NOTE:If the Use Usps City Names option is selected, then the non-optimized process will consider the Geocode valid if it matches the USPS City Name and ZIP code combiniation.

Both the SQL Optimized and non-optimized processes update the DZ Customer Address Supplement window Geocode to match the Geocode stored in the DZ Tax Schedule Supplement table for the selected tax schedule.