Checking Data Integrity

Use the Data Integrity screen to check for errors in your Sage 300 data.

To check data integrity:

  1. Open Administrative Services > Data Integrity.
  2. Select applications to check, in one of the following ways:

    • In the Available Applications pane, select an application, and then click Include.
    • Click All to select all applications.

    The applications you select appear in the Check Applications pane.

    Tip: Applications are checked in the order in which they appear in the Check Applications pane. You can change this order by selecting an application and then clicking + or .

  3. If you want Sage 300 to correct minor errors automatically during the integrity check, select the Fix Minor Errors option.
  4. If you want to limit the scope of the integrity check for Accounts Receivable, Accounts Payable, Bank Services, Payroll, or Project and Job Costing:

    1. In the Check Applications pane, select one of the applications listed above.
    2. Click Application Options.

      The Integrity Checker screen appears for the selected application. (For example, if you select Accounts Payable and then click Application Options, the A/P Integrity Checker screen appears.)

      Note: The Application Options button is not available for Administrative Services, Common Services, Tax Services, G/L Subledger Services, or Notes.

    3. Select options for the data and records that you want to check or fix.
    4. Click Close.
  5. Click Check to start the integrity check.
  6. Print a copy of the error report.