dynamiczip:troubleshooting:issues:zero_rate_county_overrides
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:18] – created chuck | dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:32] – chuck | ||
---|---|---|---|
Line 4: | Line 4: | ||
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' | ||
+ | Counties where this issue is known to exist include: | ||
+ | * Las Angeles | ||
+ | * Santa Cruz | ||
+ | ===== Workaround ===== | ||
+ | |||
+ | |||
+ | This query returns the details with a city override of LA county tax: | ||
+ | < | ||
+ | select * from TX00201 where TXDTLDSC like 'LOS ANGELES/ | ||
+ | </ | ||
+ | |||
+ | This statement will update the tax rate for the details returned by the above query to zero: | ||
+ | < | ||
+ | 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