Repairing General Ledger Integrity

This article applies to:  All Sage MIP Accounting products, all versions

Purpose

The GL Rebuild script is designed to rebuild all General Ledger balance records based upon existing General Ledger detail records.  This will generally repair integrity problems identified by the following General Ledger integrity checks: 1, 3, 4, 5, 6, 9, 11, and 13.

Instructions

1. Download MIPQry.exe. The GL Rebuild script is executed using a program called MIPQry.exe.  Please refer to the "Related Articles" section on the right hand side of this screen and click on the "MIPQry Instructions" article for more details.

2. Choose the version of the script for your operating system and MIP product version.

FOR MIP ACCOUNTING V5.1 and PRIOR VERSIONS

For Windows 2000, click here to download 48247GLRebuild.sql.
For Windows XP with no Service Pack, Click here to download 48247XP_GLRebuild.sql.

For Windows XP with Service Pack 1 or later, click here to download 48247_XPsp1_GLRebuild.sql.

FOR SAGE MIP ACCOUNTING V6.0 and LATER VERSIONS

For Windows 2000, click here to download 48247_60andLaterGLRebuild.sql.

For Windows XP with no Service Pack, Click here to download 48247XP_60andLaterGLRebuild.sql.

For Windows XP with Service Pack 1 or later, click here to download 48247_XPsp1_60andLaterGLRebuild.sql.

3. Save the script file into the MIPQry folder (It is located at C:\MIPQry by default) on your workstation.

4. Back up your organization database(s).

5. Run all General Ledger integrity checks. If any of these integrity checks fail:  2, 7, 8, 10, 12, 14, 15,16 -> do not execute the script; it will only compound the problem. The database will need to be sent to MIP for repair of these failures.

6. Execute the script as part of the MIPQry.exe process.

7. Run all General Ledger integrity checks. All should pass.