Run Table Maintenance

As third-party products are not included in the Dynamics GP upgrade process, Mekorma provides its own unified table upgrade system for all your GP companies. Table Maintenance must be run after installing Mekorma for the first time, or after upgrading to a more current version. Individual companies can be upgraded at the same time or separately within the Table Maintenance window.

!Only the system administrator is prompted to run the process in both circumstances, so be sure to log in as ‘sa’ after installation.

You must also run table maintenance after a new company is created in GP. Learn more in the video below:

*To manually access the Table Maintenance window, go to the Mekorma Area Page > Setup > System > Table Maintenance

Requirements

• A system administrator user is needed to perform table maintenance. If you are not a system administrator, a warning message displays and the window will close.
• It is imperative that no one is working on a Mekorma product while the upgrade process is running. For example, no one should be printing checks via MICR, Multi-Batch Management, or Enhanced Electronic Payments.
• Verify that you have posted all your batches before upgrading Mekorma products.
• If any registration error occurs, see the section on product registration for more details.

New Mekorma Installation or Product Upgrade:

1. Whether you are creating tables for the first time or upgrading, the process of running table maintenance is the same. The option to run Table Maintenance will only be prompted for the System Administrator (‘sa’) so the user ‘sa’ must log in after a new install or upgrade.

2. Select the companies that need tables created or updated, and click Process & Enable Selected Companies. (You do not need to update all companies at the same time). Registration keys are obtained automatically, so when the table update process is complete, Mekorma Products are ready to use.
   

3. When the process is finished, close the Mekorma Products Table Maintenance window.