CMS Fund Accounting - Finance Data Integrity - No Bill Exists for Check XXXX dated XX/XX/XX.

PROBLEM: When running the Finance Data Integrity utility at the End of Month/End of Year, you are getting an error message stating that "Finance Data Integrity - No Bill Exists for Check XXXX dated XX/XX/XX...."


SOLUTION:  Write down the check number 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, from the CMS Ledger & Payables Main Menu, click Entry | Checks, View, Void and Delete. 

Click Find | By Check Number and enter the problem check number.

From the Checks display, you'll notice that the top half of the check is correct, displaying the Vendor and check amount.  But the bottom half of the display is missing the associated Bill.

Click the Delete button at the top of the display to delete this check.

The system will ask you to confirm that you want to delete the check, answer yes.


The system will attempt to recreate the bill, however, this bill will not be re-created.  Click OK.

Click Close

Click Enter Bills and re-enter the bill that this check originally paid.  Once the bill information has been entered, click the Assign Check Number button on the right and re-assign the same check number to this bill.  

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.