Data Integrity Check

Parent Previous Next

The Data Integrity Check should be performed on a regular basis. It is recommended that you perform this check at regular intervals and after performing major changes to your Set of Books. It is good practice to perform a Data Integrity Check on your Set of Books before you make a Backup and after you have restored from a Set of Books.

If you are operating in a multi-user environment (i.e. in a networked environment and other users are using the same Set of Books as you are) then ALL users need to exit the Set of Books before the Data Integrity Check is started.


Run the Data Integrity Check

To Perform a Data Integrity Check:

1.Click on the Tools → Data Integrity Check menu. The Data Integrity Check screen is displayed:

2.Select one of the available options:

a)Select a Set of Books by clicking on the From List down arrow (drop-down list) and select an available Set of Books.

If the Set of Books on which you wish to perform the data integrity check is open on the system, the Data Integrity Check will be performed for that Set of Books.

If no Set of Books is open on the system, the Data Integrity Check will be performed for the Set of Books that was open before the Data Integrity Check was initiated, unless another Set of Books is selected.

The full path or directory and name of the selected Set of Books on which the Data Integrity Check is to be performed, if the Check button is clicked on, will be displayed directly under the Data Integrity Check title bar.

b)Select the type of function, the data integrity check has to perform. It is recommended that in most cases, all of these functions should be selected (with a tick).

3.Click on the Check button and the process will be performed. The word Finished will be displayed next to each function when the process for that function is completed. When the whole process is completed, the Data Integrity Check report will be generated.

4.Click on the Close button.

5.Study the report to determine if there is any data corruption or errors.

Check for any errors on the report. If there are any errors, see if you can fix these errors. If these errors cannot be fixed, the Set of Books may have to be restored from your last backup disks. You may have to re-enter some data from the last backup to the last transaction entered before the problem/s arose.


View Data Integrity Check Reports

As soon as the Data Integrity Check process is completed, the Data Integrity Check Report will be printed to either the screen, printer, file, fax or e-mail as set or selected on the Default Output field in the Setup → System parameters → Company Info (Options tab) menu. The Data Integrity Check report consists of the following six (6) basic sections:

1.System Info - Memory in your System (e.g. 64 Mb, 128 Mb, 256, Mb, etc.).

2.Files - A two digit numeric number is automatically allocated to each of the files in the Set of Books. The Files are ".DB" files, which are Database files (See Structure of TurboCASH). The size of each file is indicated in KB (Kilobytes), etc. It also displays the number of records contained in each file. For example, the Data Integrity Check report reflects 40 records for the "Account.DB" file, it also indicates that there are 40 Accounts in the Set of Books.

3.Periods - The number of Accounting periods as specified in the Setup → System parameters → Reporting Dates menu will be listed. The description of the periods are also displayed as selected or specified in this menu.

a)Period 00 indicates Opening Balances

b)Periods 01 to 13 indicates Last Year Periods.

c)Periods 14 to 26 indicates This Year Periods.

This will list the Accounting Periods and the Debit Totals and Credit Totals and Balances for each period for two Financial Years (This Year and Last Year). If there are any balances (i.e. the Debit and Credit Totals for an Accounting period do not balance), it indicates that the data may be corrupt for the specific accounting period in which the Balance is displayed.

4.Count Account Number - This specifies the number of Account master files created for each Account Type (General Ledger, Debtors, Creditors, Bank and Tax Accounts) in the Edit → Accounts menu. The number of Accounts for Debtors indicates the number of Debtor Accounts in the Debtors ledger and the number of Accounts for Creditors indicates the number of Creditor Accounts in the Creditors ledger.

5.Control Accounts Check - This will indicate the balances for the Full Amount, Control Account and the Outstanding Amount for the Debtors and Creditors. These three amounts must be in balance and must balance with the Debtors Control Account or the Creditors Control Account in the Balance Sheet or Trial Balance.

6.Unposted Batches / Documents - This will only be displayed if there are any batches or journals which have not yet been posted to the ledger and /or documents, which have not yet been updated to the ledger.

An example of a Data Integrity Check Report is:

If the differences or corruption is not fixed, you may need to Restore the Set of Books from a previous backup. It is advisable not to continue entering transactions until the current Set of Books is repaired.


Created with the Personal Edition of HelpNDoc: Create help files for the Qt Help Framework