Repairing Accounts Payable Integrity
This article applies to: All products, all versions
Purpose
The AP Rebuild script is designed to calculate the Accounts Payable subledger balances, beginning dates, and ending dates based upon existing General Ledger detail records. It then replaces the existing values in the Accounts Payable subledger document records with the calculated values. It will also rebuild all Accounts Payable subledger transaction records based upon existing General Ledger detail records.
IMPORTANT: Do not execute the AP Rebuild script if any of the General Ledger integrity checks fail. It will only compound the problem. General Ledger integrity problems should be resolved before attempting to resolve Accounts Payable integrity problems.
Instructions
- Download MIPQry.exe. The AP 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.
- Choose the version of the script for your operating system.
For Windows 2000, click here to download 48248APRebuild.sql.
For Windows XP, click here to download 48248XP_APRebuild.sql.
For Windows XP with Service Pack, click here to download 48248_XPsp1_APRebuild.sql.
- Save the script file into the MIPQry folder (C:\MIPQry) on your workstation.
- Back up the organization database.
- Run all General Ledger and Accounts Payable integrity checks.
- Verify that there are no General Ledger integrity check failures. If any General Ledger integrity checks fail, stop here and refer to the “Repairing General Ledger Integrity” article in the “Related Articles” section on the right side of this page first.
- Execute the script as part of the MIPQry.exe process.
- Run all Accounts Payable integrity checks. All should pass.
- If any Accounts Payable integrity checks still fail, then this is not a database problem. It is an entry error (see Note on AP Integrity Check #17 below)
Note on AP Integrity Check #17
After running the AP Rebuild script, it is possible to still fail AP Integrity Check #17. This is usually an indicator that AP entries have been entered into a prior, closed fiscal year without updating the current year. Please refer to the "Resolving A/P Subledger Issues" article in the "Related Articles" section on the right side of this page.
