Run the Integrity Check

The Integrity Check is a tool that allows you to verify if any of your data files have been corrupted and to possibly repair them.

Before you run any integrity check test, complete Data Verification procedures. Data Verification is a Sage 50 utility that determines if any of your data files are missing or possibly damaged; it can typically repair minor errors for you instantly. Learn how to verify your data .

To Run the Integrity Check

If a Sage 50 Customer Support Analyst determines that your data must be repaired, you can run Sage 50 Data Integrity/Repair utility.

1. Go to Help>Customer Support and Service>Integrity Check.
2. Click Backup to make a backup of your company data and then proceed to the Integrity Check utility.

Warning! It is vital that you back up your company before you use Integrity Check; if the Integrity Check procedure is not successful,you may lose valuable data.

3. After you create a backup of your company, the Data Integrity Check/Repair window will appear.

4. Select the type of test to perform. Perform only one test at a time. Do not select multiple tests. Selecting multiple tests may make the problem more difficult to correct.

   You can perform the following types of tests:

   File Tests

   Data Synchronization Tests

   Invoice/Payment Synchronization

5. Click OK to continue.

File Tests

• Change Accounting Periods
• Setup Test
• Data Consistency
• Reindex Files
• Journal Balances
• G/L Balances

Data Synchronization Tests

These tests compare the contents of permanent data files with journal transactions that have been posted to them. When a difference is found, the permanent data file is corrected to match its journal entries.

The Data Synchronization tests include

• Customer/Journal
• Employee/Journal
• Chart of Accounts/Journal
• Vendor/Journal
• Inventory/Journal

Invoice/Payment Synchronization Tests

The Invoice/Payment Synchronization tests used in Integrity Check include the following:

• Accounts Receivable
• Accounts Payable

Accounts Receivable and Accounts Payable invoice/payment synchronization tests examine payment transactions applied to invoices to see if they match the amount that the invoice records to have been paid.

You are given three options for running this test:

• Invoice is presumed correct: This assumes that the amounts paid on all invoices are correct and that additional payments made are not to be associated with the invoice.
• Payments are assumed correct: This assumes that the payment transactions applied to the invoice are correct where a synchronization error is found and that the invoice amount paid total needs to change to reflect this amount.
• Ask each time: This allows you to determine if the invoice or payments are correct one error at a time. This is the recommended option for running Accounts Receivable and Accounts Payable tests. It's not available for electronic payments.