Archiving or Deleting Audit Log Data

Mekorma automatically archives check information. If the Disable Check Archiving option in the Mekorma Systems Options window is not marked, you might have millions of records in your company audit log tables. Because the tables that store the archived check information are scanned during the check printing and posting process, performance could be impacted. Archiving or deleting past audit log data will help improve the check printing and posting process.

!Be sure to back up the company database that you will be archiving or deleting before running this process.

If you choose to archive your data, it will be moved from the following tables to an archive version of those tables. You will NOT be able to view the information in the archive tables.

If you choose to delete your data, it will be removed and will no longer be available.

*We recommend that you avoid running this process during regular business hours while users are actively using Dynamics GP. Archiving 100k records will take approximately 1-2 minutes. Please be aware that the time increases with the number of records that you are archiving.

1. Back up the company database.

2. Open the Long-Term Archive window. Mekorma > Setup > System > System Options > Options button > Archive > Long-Term Archive

3. Select to archive or delete.

4. Select a date in the Audit Logs Before field. The date that is used to select records is the Post Date (POSTEDDT) field in ME240459. When you tab off of this field, the table will display or redisplay the data that will be archived or deleted.

5. Click Process.

When the process is complete, a message will be displayed.