CMS Fund Accounting - Rebuilding the Ledger & Payables System

Once all of these tables are rebuilt, try your process or report that was giving you an error again. It should now be working for you!

From CMS Fund Accounting, click File | Utilities | Table Repair.

On the Table Repair Utility Screen, click Browse in the upper right corner. Find the table ACCOUNTS.DB and click Open.

Jot down the Number of Records, located about half way down the left side of the screen. You'll need that number in a few seconds.

Click the Verify Button at the bottom of the screen. It will come back with either "Table and Header Verify Okay" or "Table Requires a Rebuild". Jot down this message and click OK.

Click the Rebuild Button at the bottom of the screen. When complete, it will come back with a Number of Records Successfully Recovered. That number should match the number you jotted down previously. Click OK | OK.

Repeat these steps with the following tables:

  • BILLITEMS.DB
  • BILLS.DB
  • CHECKS.DB
  • PAYBILLS.DB
  • RECEIPTS.DB
  • RECITEMS.DB
  • JOURNALS.DB
  • JRNITEMS.DB
  • VENDORS.DB

Click Close when complete and try the report or process that was giving you an error!

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.