CMS Fund Accounting - Finance Data Integrity - A Beginning Balance Entry Does Not Exist For Beginning Balance 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 Beginning Balance Entry does not exist for Beginning Balance Item..."

SOLUTION:  Write down the beginning balance entry 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.

Open BBITEMS.DB

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

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

You should be see only that Beginning Balance Entry 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 Beginning Balance Entry number that caused an error, repeat these steps to delete those Beginning Balance Entry 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

Comments

0 comments

Please sign in to leave a comment.