Repairing Accounts Receivable Integrity
This article applies to: All products, all versions
Purpose
The AR Rebuild script is designed to calculate the Accounts Receivable subledger balances, beginning dates, and ending dates based upon existing General Ledger detail records. It then replaces the existing values in the Accounts Receivable subledger document records with the calculated values. It will also rebuild all Accounts Receivable subledger transaction records based upon existing General Ledger detail records.
IMPORTANT: Do not execute the AR 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 Receivable integrity problems.
Instructions
- Download MIPQry.exe. The AR 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 48249ARRebuild.sql
For Windows XP, click here to download 48249XP_ARRebuild.sql
For Windows XP with Service Pack, click here to download 48249_XPsp1_ARRebuild.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 Receivable 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 Receivable integrity checks. All should pass.
- If any Accounts Receivable integrity checks still fail, then this is not a database problem. It is an entry error (see Note on AR Integrity Check #26 below)
Note on AR Integrity Check #26
After running the AR Rebuild script, it is possible to still fail AR Integrity Check #26. This is usually an indicator that AR entries have been entered into a prior, closed fiscal year without updating the current year. Please refer to the "Resolving A/R Subledger Issues" article in the "Related Articles" section.
