====== DZ Table Status window ======

Access from [[dynamiczip:windows:DynamicZip Utilities Navigation]]. 

//Permission to access this window is contained in the [[dynamiczip:setup:security:System Utilities Task]].//

===== Window Description =====

The DZ Table Status window lists all of the permanent DynamicZip SQL tables, their conversion status, their path, their physical name and the DynamicZip build number of their last successful conversion.

When upgrading to a new version of DynamicZip, sometimes it will be necessary to convert some DZ tables to their new specifications. You can find out which DynamicZip upgrades include a modification of a permanent table (and which permanent table(s)) by viewing the [[dynamiczip:install:mods:modifications|Modifications]] pages.

===== Fields =====

==== Convert ====

**CAUTION**: No one should be using any sales tax related features of Microsoft Dynamics GP during this process. The safest method is to perform the conversion when no other workstations are logged into Microsoft Dynamics GP. 

  - Click Convert to begin the [[dynamiczip:tables:conversions:Table Conversions|conversion of tables]] whose status is Convert. 
  - If any DynamicZip table has a status of Missing, the table(s) need to be created. Please see [[dynamiczip:utilities:Create Sql Tables|Create SQL Tables]].
  - If any DynamicZip table has a status other than Convert, Successful, or Missing you may need to restore all of the DynamicZip permanent tables and restart the conversion. If a conversion process is unable to open the source file, it may be because of an incorrect build number listed as the last successful conversion. If this is the case, you can attempt the conversion again by setting the conversion status to Convert and entering the build number that you just replaced (upgraded from) assuming that the table worked properly with that build.

==== Print ====

This will print a report listing the DynamicZip permanent tables. The report will be sorted according to the Sort By selected in this window .

  * The [[dynamiczip:reports:DZ Report Temp report]] is used for this report.

==== Sort By ====

You can sort the records by Table Technical Name, Table Display Name, Table Physical Name, Table Series, or Status.

**NOTE:** In the event of a table conversion failure, please refer to [[dynamiczip:faq:Table Conversion Fail Faq|Table Conversion Fail FAQ]]. 

===== DynamicZip Menu: =====
  * [[dynamiczip:windows:View Log File]]((Removed in [[dynamiczip:install:mods:release:build77:build77|Build 77.0]])) 
  * [[dynamiczip:windows:Initialize Log File]]((Removed in [[dynamiczip:install:mods:release:build77:build77|Build 77.0]])) 
  * [[dynamiczip:windows:Log Processes]]((Removed in [[dynamiczip:install:mods:release:build77:build77|Build 77.0]])) 
  * [[dynamiczip:utilities:Create_Sql_Tables|Create SQL Tables]]
  * [[dynamiczip:windows:Reset|Reset]]
  * [[dynamiczip:windows:DZ Table Maintenance window|DZ Table Maintenance]]
  * Force Build Number
  * [[dynamiczip:faq:Recreate DynamicZip Stored Procedures Faq|Create Stored Procedures]]
  * Run Post Conversion Process
  * Debug


----

[[dynamiczip:windows:windows|DynamicZip Windows]]\\ 
[[dynamiczip:windows:DZ Entry And Lookup Windows]]\\ 
[[dynamiczip:utilities:utilities|DZ Utilities]]