Two Tax Groups Having the Same City and Zip Codes

There are two tax groups having the same City/District and zip codes in the Tax Groups page. The two tax groups are system generated as indicated of having negative Internal ID's.  Users should also observe that one of the Tax Groups is inactive.

The duplicate Tax Group is caused by updating tax rates through the Use State Sales Tax Tables page. Whenever we upload Sales Tax Tables, it updates the Tax Codes to its most recent rates.  If the update in Tax Group involves only changes in Tax Codes Rates, then the system just overwrites the old Tax Codes in the Tax Group. However, if the changes in the Tax Group involves either a replacement of Tax Code or there will be an additional Tax Code, then the system will create a replacement Tax Group and inactivate the old one.

An example of additional Tax Codes:

CA_MARIN CO_SAN RAFAEL_EERH and CA_MARIN CO_SAN RAFAEL_EERH_EGQL

CA_MARIN CO_SAN RAFAEL_EERH (inactive) has the following Tax Codes:

Tax Code	Tax Rate	Type
CA_CA	6.5%	State
CA_MARIN CO	1.0%	County
CA_SAN RAFAEL	0.5%	City
CA_EERH	0.75%	Transit

 

While CA_MARIN CO_SAN RAFAEL_EERH_EGQL has the following Tax Codes:

Tax Code	Tax Rate	Type
CA_CA	6.5%	State
CA_MARIN CO	1.0%	County
CA_SAN RAFAEL	0.5%	City
CA_EERH	0.75%	Transit
CA_EGQL	0.25%	Other 1 Sales Tax

 

Notice the additional Tax Code = CA_EGQL 0.25%  Other 1 Sales Tax

An example of replacement in Tax Code is shown below:

TX_VILLAGE OF THE HILLS_EGQT_ and TX_VILLAGE OF THE HILLS_EGQT

TX_VILLAGE OF THE HILLS_EGQT _ (inactive) has the following Tax Codes:

Tax Code	Tax Rate	Type
TX_TX	6.25%	State
TX_VILLAGE OF THE HILLS	0.75%	City
TX_EGQT_	1.0%	Other 1 Sales Tax

 

While TX_VILLAGE OF THE HILLS_EGQT has the following Tax Codes:

Tax Code	Tax Rate	Type
TX_TX	6.25%	State
TX_VILLAGE OF THE HILLS	0.75%	City
TX_EGQT	1.25%	Other 1 Sales Tax

 

Notice that TX_EGQT_  1.0%  Other 1 Sales Tax is replaced by TX_EGQT 1.25%  Other 1 Sales Tax