====== SQL Optimized Tax Schedule Assignment ======
Added to the [[dynamiczip:windows:DZ Assign Customer Tax Schedules window]] in [[dynamiczip:install:mods:release:build73:build739|DynamicZip Build 73.9]]. \\
Added to the [[dynamiczip:windows:DZ Assign Vendor Tax Schedules window]] in [[dynamiczip:install:mods:release:build74:build74|Build 74]].

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

**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:install:mods:release:build73:build739|DynamicZip Build 73.9]] to a newer version of Build 73. Please see [[dynamiczip:faq:assign_schedules_unhandled_script_faq|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. 

==== SQL Optimized VS Non-Optimized ====

=== SQL Optimized ===

This option enables DynamicZip to select tax schedules based on the [[dynamiczip:glossary:Geocode]] stored in the [[dynamiczip:windows:DZ Customer Address Supplement window]] 

  * If a customer address record's [[dynamiczip:glossary:Geocode]] is blank, then DynamicZip will select a tax schedule based on the [[dynamics:windows:Customer Address Maintenance window]] City, State, and ZIP code. 
  * If a customer address record's [[dynamiczip:glossary:Geocode]] is not blank, then DynamicZip will select a tax schedule based on the ZIP code and [[dynamiczip:glossary:Geocode]] 

=== Not SQL Optimized ===

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

\\ 
Both the SQL Optimized and non-optimized processes update the [[dynamiczip:windows:DZ Customer Address Supplement window]] [[dynamiczip:glossary:Geocode]] to match the [[dynamiczip:glossary:Geocode]] stored in the [[dynamiczip:tables:DZ Tax Schedule Supplement table]] for the selected tax schedule.\\ 
\\