====== SQL Optimized schedule assignment accepting taxable schedule for exempt customer ======

===== Situation =====

When a customer that already has a valid [[dynamiczip:glossary:taxable_tax_schedule|taxable schedule]] assigned to one or more of its address cards is flagged as exempt in the [[dynamiczip:windows:dz_customer_supplement_window|DZ Customer Supplement window]], subsequently running the [[dynamiczip:windows:dz_assign_customer_tax_schedules_window|DZ Assign Customer Tax Schedules process]] with the SQL Optimized check box selected, the process was accepting the currently assigned taxable schedule instead of switching it to an [[dynamiczip:glossary:exempt_tax_schedule|exempt schedule]]. If the SQL Optimized check box was not selected, then the process would correctly assign the customer an exempt schedule. 

===== Resolution =====

The SQL Optimized assign customer tax schedules process now correctly assigns an exempt tax schedule to exempt customers.

This was completed in the following builds:
  * [[dynamiczip:install:mods:release:build74:build_74_11|DynamicZip Build 74.11]]
  * [[dynamiczip:install:mods:release:build75:build_75_11|DynamicZip Build 75.11]]
  * [[dynamiczip:install:mods:release:build76:build_76_10|DynamicZip Build 76.10]]

----
[[dynamiczip:install:mods:modifications|Modifications]]