Note: Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup solution.


SQL Query run to clear balances where error reads '2984: has a balance discrepancy.  Accounts Receivable indicates a balance of ($50.50).  The last closing balance indicates a balance of $50.50 as of 3/4/2008':



The SQL query reads:

Update Customer Set LastClosingBalance = -$50.50 Where AccountNumber = '2984'

Note: LastClosingBalance should match the balance that Accounts Receivable indicates. In the above example it is -$50.50