freeside-wa-tax-table-resolve
freeside-wa-tax-table-resolve --help freeside-wa-tax-table-resolve --check [freeside_user] freeside-wa-tax-table-resolve --merge 123,234 [freeside_user] freeside-wa-tax-table-resolve --set-source-null 1337,6553 [freeside_user] freeside-wa-tax-table-resolve --merge-all [freeside_user] freeside-wa-tax-table-resolve --fix-usf [freeside_user]
Display help and exit
Display info on any taxnums considered blocking duplicates
Update all records referring to [source-taxnum], so they now refer to [target-taxnum]. [source-taxnum] is deleted.
Used to merge duplicate taxnums
Update all records for the given taxnums, by setting the source column to NULL.
Used for manually entered tax entries, incorrectly labelled as created and managed for Washington State Sales Taxes
Automatically merge all blocking duplicate taxnums.
If after reviewing all blocking duplicate taxnum rows with --check, if all duplicate rows are safe to merge, this option will merge them all.
Fix routine for a particular USF issue
Search for duplicate districts within the tax tables with
- duplicate district column values - source = NULL - district = NOT NULL - taxclass = USF - tax > 17
Merge these rows into a single USF row for each tax district
Tool to resolve tax table issues for customer using Washington state sales tax districts.
If Freeside detects duplicate rows within the wa sales tax tables, tax table updates are blocked, and a log message directs the sysadmin to this tool.
Duplicate rows may be manually entered taxes, not related to WA sales tax. Or duplicate rows may have been manually entered into freeside for other tax purposes.
Use --check to display which tax entries were detected as dupes.
For each tax entry, decide if it is a duplicate wa sales tax entry, or some other manually entered tax.
if the row is a duplicate, merge the duplicates with the --merge option of this script
If the row is a manually entered tax, not for WA state sales taxes, keep the tax but remove the flag incorrectly labeling it as WA state sales taxes with the --set-source-null option of this script
Once --check no longer returns problematic tax entries, the wa state tax tables will be able to complete their automatic tax rate updates