Repairing Encumbrances Integrity

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

Purpose

The Encumbrance Rebuild script is designed to rebuild all Encumbrances balance records based upon existing Encumbrances/General Ledger detail records. It is also designed to calculate the Encumbrances subledger balances, beginning dates, and ending dates based upon existing Encumbrances/General Ledger detail records.  It then replaces the existing values in the Encumbrances subledger document records with the calculated values.  Finally, it will rebuild all Encumbrances subledger transaction records based upon existing Encumbrances/General Ledger detail records.  This will generally repair integrity problems identified by the following Encumbrances integrity checks:  38, 39, 40, 41, 42, and 43.

Instructions

1. Download MIPQry.exe. The Encumbrance 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 detail.

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

FOR SAGE MIP ACCOUNTING V5.1 and PRIOR VERSIONS

For Windows 2000, click here to download 48252EncRebuild.sql
For Windows XP with no Service Pack, click here to download 48252XP_EncRebuild.sql

For Windows XP with Service Pack 1 and later, click here to download 48252_XPsp1_EncRebuild.sql

FOR SAGE MIP ACCOUNTING V6.0 and LATER VERSIONS

For Windows 2000, click here to download 48252_60andLaterEncRebuild.sql
For Windows XP with no Service Pack, click here to download 48252_XP_60andLaterEncRebuild.sql

For Windows XP with Service Pack 1 and later, click here to download 48252_XPsp1_60andLaterEncRebuild.sql

FOR SAGE MIP FUND ACCOUNTING V7.0 and LATER VERSIONS

For Windows 2000, click here to download 48252_70andLaterEncRebuild.sql
For Windows XP with Service Pack 1 and later, click here to download 48252_XPsp1_70andLaterEncRebuild.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 Encumbrances integrity checks.

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

7. Run all Encumbrances integrity checks.  All should pass.