CMS Contribution - OOPS! I Accidentally Posted to the Wrong Fund!

PROBLEM:  You just realized you accidentally posted an entire batch of contributions to the wrong fund.

SOLUTION: You can easily change the fund on a batch prior to posting.  

From your CMS Contribution System, click Enter Contributions. Select the Batch where the wrong fund was entered.  Enter a zero ( 0 ) in the incorrect fund and enter the correct dollar amount in the correct fund.  

Reprint the edit list to ensure you've corrected all of the erroneous funds.

If you've already posted the batch of contributions, there are just a few more steps involved.
Make sure you have a backup of your data before beginning this process.
You will need to know the Batch Number, the fund number that was used, and the fund number that should have been used when posting.
From CMS, click File | Utilities | CMS File Editor | click OK at the warning message.
Click the Select Table to Edit button and open the DETAIL.DB table.
You will see a screen with several columns and rows of data.  One of the columns is Batch Num.  Right-click the first number you see under the Batch Num column (not the words Batch Num, but the actual number) and choose the word Filter.

At the Filter for Batch Num field, type in the batch number with the wrong fund.  Click OK.

Now the only batch number you should see is that batch number, probably repeated in many rows.
Click the Edit button at the top of the screen.
Single left click into the Fund column (the date, not the column header "Fund").

Click the Locate and Replace button at the top of the screen. 

Verify the Field = Fund.
Click into Value and type the incorrect fund number.
Click into the Replace With field and type in the correct fund number.
Click OK.

At the "Found a Match" display, choose the last option of Change All Occurrences and click OK.
The system will find all of the incorrect fund numbers and replace them with the corrected fund numbers.  The system will not give you a notice when complete, it will just stop.  Click Close.
Next, click File | Utilities | Repost Utility | Process.

This will recalculate all of your QTD, YTD, and Calendar YTD totals, based on the new information. Once complete, go back into the Contribution System.
Click Process | Calculate Pledge Balances | Process.  This will recalculate any Drive to Date and pledge balance totals.

Have more questions? Submit a request



Please sign in to leave a comment.