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 revisionNext revisionBoth sides next revision | ||
dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:28] – chuck | dynamiczip:troubleshooting:issues:zero_rate_county_overrides [2019/05/22 12:32] – chuck | ||
---|---|---|---|
Line 9: | Line 9: | ||
* Las Angeles | * Las Angeles | ||
* Santa Cruz | * Santa Cruz | ||
+ | |||
+ | ===== Workaround ===== | ||
+ | |||
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 18: | Line 21: | ||
< | < | ||
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