User Tools

Site Tools


dynamiczip:faq:clean_reimport_database_faq

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
dynamiczip:faq:clean_reimport_database_faq [2015/05/19 20:39] connidynamiczip:faq:clean_reimport_database_faq [2017/09/06 23:01] conni
Line 10: Line 10:
   - Change the series to Company and insert the table Sales/Purchases Tax Master. (This is actually a group of tables which includes the Microsoft Dynamics GP tax schedules, details, period history, etc.)    - Change the series to Company and insert the table Sales/Purchases Tax Master. (This is actually a group of tables which includes the Microsoft Dynamics GP tax schedules, details, period history, etc.) 
   - Click OK to clear data on this group of tables.   - Click OK to clear data on this group of tables.
-  - Open the [[dynamiczip:windows:DZ Table Maintenance window]]. Change the procedure to Clear Data. Insert the following tables and click Process to clear data on them:+  - Open the [[dynamiczip:windows:DZ Table Maintenance window]].  
 +  - Change the procedure to Clear Data.  
 +  - Insert the following tables and click Process to clear data on them:
     - [[dynamiczip:tables:DZ Update History table]]      - [[dynamiczip:tables:DZ Update History table]] 
 +    - [[dynamiczip:tables:DZ Rate Set Index table]]
 +    - [[dynamiczip:tables:DZ RateSet Calculation table]]
     - [[dynamiczip:tables:DZ Tax Detail Supplement table]]      - [[dynamiczip:tables:DZ Tax Detail Supplement table]] 
 +    - [[dynamiczip:tables:DZ Tax Schedule Supplement table]]
     - [[dynamiczip:tables:DZ Tax Schedule Update table]]      - [[dynamiczip:tables:DZ Tax Schedule Update table]] 
     - [[dynamiczip:tables:DZ Zip Address table]] (this will remove zip addresses for all companies)     - [[dynamiczip:tables:DZ Zip Address table]] (this will remove zip addresses for all companies)
-  - At this point the tax details and schedules should be gone. You can now re-import the Rate & Boundary Database.+  - At this point the tax details and schedules should be gone. You should now run the Checklinks process then re-import the Rate & Boundary Database.
  
 ---- ----
dynamiczip/faq/clean_reimport_database_faq.txt · Last modified: 2019/03/20 18:28 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki