NOTE: The asterisk in the Tax Schedule ID proved to be confusing and its use has been discontinued as of Build 74.

Upgrading from DynamicZip build 71 or older to Build 72 or Build 73 includes a modification in the tax schedule ID format. The addition of an asterisk in position 10 is used to identify the default city and county combination when more than one city and county exists in a ZIP code. Please read the information on this page to help ensure a smooth transition to the new Zip Code Tax Schedule ID Format.

IMPORTANT: After completing the DynamicZip installation you must complete the Import Rate & Boundary Database Checklist to ensure that the new tax schedule IDs are created and your customer address records are updated. Not completing the Import Rate & Boundary Database Checklist after upgrading can result in zero tax on new sales transactions.

• Please see the complete Upgrade Instructions.

If you are using Contract Administration, then the new tax schedules will need to be rolled out to your existing contracts. Failing to do so can result in invoices created out of Contract Administration having incorrect or zero tax amounts. Please see the following instructions.

1. You must complete the Import Rate & Boundary Database Checklist to update your tax schedules and customers before you can roll out the new tax schedules out to the contracts. NOTE: The two SQL queries below should be run against both the SVC00600 table and the SVC00601 table.
2. The following SQL statement can help you find the contracts that have a tax schedule ID mismatch with the customer address cards.

   SELECT SVC00600.CONTNBR, SVC00600.CUSTNMBR 
   ,SVC00600.TAXSCHID AS 'Contract Tax ID'
   ,RM00102.TAXSCHID AS 'Customer Tax ID'
   FROM SVC00600 AS SVC00600
   JOIN RM00102 AS RM00102
   ON SVC00600.CUSTNMBR = RM00102.CUSTNMBRAND 
   AND SVC00600.ADRSCODE = RM00102.ADRSCODE
   WHERE SVC00600.TAXSCHID != RM00102.TAXSCHID 
   AND SVC00600.CONSTS = 2

3. Run the next SQL statement to update Contract Administration with the new tax schedules.

   UPDATE SVC00600 set SVC00600.TAXSCHID = RM00102.TAXSCHID
   FROM SVC00600 SVC00600
   JOIN RM00102 RM00102
   ON SVC00600.CUSTNMBR = RM00102.CUSTNMBR
   AND SVC00600.ADRSCODE = RM00102.ADRSCODE
   WHERE SVC00600.TAXSCHID != RM00102.TAXSCHID
   AND SVC00600.CONSTS = 2

Installation & Setup
Modifications
Frequently Asked Questions