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:38] connidynamiczip:faq:clean_reimport_database_faq [2017/09/06 23:01] conni
Line 7: Line 7:
 **CAUTION:** When this method is used, you will return to the point you were at before you originally imported the Rate & Boundary Database and before you created any manual tax details and tax schedules. Typically simply re-importing is the best and safest approach. This method normally should only be used in the case of a new install of Microsoft Dynamics GP and DynamicZip. **CAUTION:** When this method is used, you will return to the point you were at before you originally imported the Rate & Boundary Database and before you created any manual tax details and tax schedules. Typically simply re-importing is the best and safest approach. This method normally should only be used in the case of a new install of Microsoft Dynamics GP and DynamicZip.
  
-  - On the Microsoft Dynamics GP menu, point to Maintenance, and then click Clear Data. 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. +  - On the Microsoft Dynamics GP menu, point to Maintenance, and then click Clear Data.  
-  - 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:+  - 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. 
 +  - 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