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

Next revision
Previous revision
dynamiczip:faq:clean_reimport_database_faq [2015/04/16 21:09] – external edit 127.0.0.1dynamiczip:faq:clean_reimport_database_faq [2019/03/20 18:28] (current) 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 File 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:Frequently Asked Questions]] +[[dynamiczip:faq:Frequently Asked Questions|FAQ]] 
  
dynamiczip/faq/clean_reimport_database_faq.1429218564.txt.gz · Last modified: 2015/05/19 20:38 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki