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
dynamiczip:faq:clean_reimport_database_faq [2015/05/19 20:39] connidynamiczip:faq:clean_reimport_database_faq [2019/03/20 18:28] (current) 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:Frequently Asked Questions]] +[[dynamiczip:faq:Frequently Asked Questions|FAQ]] 
  
dynamiczip/faq/clean_reimport_database_faq.1432067940.txt.gz · Last modified: 2015/05/19 20:39 by conni

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki