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.
Note: LastClosingBalance should match the balance that Accounts Receivable indicates. In the above example it is -$50.50
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'