dynamiczip:troubleshooting:issues:zero_rate_county_overrides
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:27] – chuck | dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:36] (current) – chuck | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Zero Rate County Overrides ====== | ====== Zero Rate County Overrides ====== | ||
- | This issue affects [[dynamiczip: | + | This issue affects [[dynamiczip: |
- | The [[dynamiczip: | + | The [[dynamiczip: |
When a county tax rate is reduced to zero for one or more cities, DynamicZip build 73 and prior failed to zero out or remove the standard county tax rate. This results in overstating the tax schedules' | When a county tax rate is reduced to zero for one or more cities, DynamicZip build 73 and prior failed to zero out or remove the standard county tax rate. This results in overstating the tax schedules' | ||
Line 9: | Line 9: | ||
* Las Angeles | * Las Angeles | ||
* Santa Cruz | * Santa Cruz | ||
+ | |||
+ | ===== Workaround ===== | ||
+ | Build 73 and prior used the county name followed by /T: as the description for county override tax details. | ||
This query returns the details with a city override of LA county tax: | This query returns the details with a city override of LA county tax: | ||
Line 15: | Line 18: | ||
</ | </ | ||
- | This statement will update the details' (returned by the above query) tax rates to zero: | + | This statement will update |
< | < | ||
update TX00201 set TXDTLPCT = 0 where TXDTLDSC like 'LOS ANGELES/ | update TX00201 set TXDTLPCT = 0 where TXDTLDSC like 'LOS ANGELES/ | ||
+ | </ | ||
+ | |||
+ | The [[dynamiczip: | ||
+ | < | ||
+ | update sup set KDImportStatus = 2 | ||
+ | from DZ00400 as sup | ||
+ | inner join TX00201 as dtl on dtl.TAXDTLID = sup.TAXDTLID | ||
+ | where TXDTLDSC like 'LOS ANGELES/ | ||
</ | </ | ||
dynamiczip/troubleshooting/issues/zero_rate_county_overrides.txt · Last modified: 2019/05/22 12:36 by chuck