Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen. Image of Data Integrity Check screen.

Check Data Integrity

To check data integrity:

  1. Double-click the Setup icon.

    Image of Main Menu icons, including Setup Details Invoice History, Budget, and Inquiry & Reporting.

  2. Double-click the Data Integrity Check icon.

    Image of Setup menu including Setup Options, Clear Data, Consolidate Detail, Update Descriptions, Data Integrity Check icons.

  3. Run Data Integrity on Sales Analysis data. Data integrity check for Sales Analysis will check the UXDetail file containing the sales data and the UXBudd and UXBudh files containing the budget information.

    Click on the picture for more information.

    Image of Data Integrity Check screen.

    • Select an Ignore Detail date. Transactions before this date are not checked for data integrity.
    • Select a method for fixing errors: Do Not Fix, Prompt To Fix, or Fix.
    • Select Clear Records With Errors to delete any transaction records with errors.
    • Select where to log the errors: Screen or File. If you select File, specify the name and location of the log file.
    • Click Proceed to check data integrity.
  4. Click Close to close the Check Data Integrity program.

Data integrity will detect and report errors for: Item, Location, Invoice #, Credit Note #, Category, Customer, Salesperson and Unit of Measure. These errors must be corrected manually.

Errors that can be fixed by the data integrity check are: Fiscal Year, Fiscal Period and Quarter.