CMS Fund Accounting - Finance Data Integrity - A Deposit Record Does Not Exist For Deposit Item XX-X

PROBLEM: When running the Finance Data Integrity utility at the End of Month/End of Year, you are getting an error message stating that "A Deposit record does not exist for Deposit item..."

SOLUTION:  Write down the deposit number(s) that the Finance Data Integrity lists as a problem.  Click OK at the following message.  You can follow these steps in lieu of calling CMS.


Make a backup of your system before beginning.  Do not skip this step, do not overwrite the backup until the problem is resolved.

Once that backup has been completed, click File | Utilities | CMS File Editor. 

Click OK at the warning message, as you do not need supervision from CMS is you are following these instructions and have completed your backup.

Click Select Table to Edit.


With your mouse, right-click the first number listed in the Receipt Number column (not the column header "Receipt Number" but the first actual number).  Left click the word Filter.


Enter the Deposit Number from the error message on the Finance Data Integrity process, click OK.

You should be see only that Deposit number listed on the display.  You may see that number listed once or several times.  Click the Empty Table button at the top of the display.


That should empty out the display.  If you have another deposit number that caused an error, repeat these steps to delete those deposit item references.

Click Close when complete.

Click File | Utilities | Finance Data Integrity | Process.

The Finance Data Integrity process should complete without errors, and you will receive a reminder to run the Calculate Balances process to update your accounts.

From CMS Ledger & Payables, click Process | Calculate Balances | Finish to complete this process.

Proceed with End of Month/Year process.

Have more questions? Submit a request



Please sign in to leave a comment.