Skip to content
logo Knowledgebase

"Data inconsistencies have been detected" in the Integrity Summary window

Created on  | Last modified on 

Summary

You may receive errors or data inconsistencies when you roll forward your year or perform a data integrity check.

Resolution

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.


 

Understanding Data Integrity: The data integrity check will warn of possible serious errors in your data.

  1. Select Maintenance, Check Data Integrity to ensure your accounts and sub-ledgers balance.
  2. The left side (L) of the Integrity Summary window is the General Ledger balance as of the latest transaction date
  3. The right side (R) of the Integrity Summary window is the balances associated with your customers, vendors, or employee
  4. The A/P balance (L) should always match the Unpaid Invoices (R) like the example below

Image

Troubleshooting:

WARNING: If your data file uses a foreign currency, you should not follow this article. Contact Customer Support. Unlinking A/R and A/P will ruin the foreign balances of those accounts.

  • Select Setup, Settings, Company, then Currencies to check if you are using foreign currencies.
  • If there is more than the home currency, then you are using foreign currencies.
  • Contact Customer Support for data repair at 1-888-522-2722.


If you sent the file to your accountant using the Accountant Edition:

  1. The accountant made a general journal entry directly to the control account instead of the module in question.
    • EXAMPLE: You should post A/R adjustments in the Sales Invoice module.
  2. Return the backup file to the accountant to void the general journal entry(ies) that affected the control account.
  3. Restore the voided entries the accountant returned.
  4. If the accountant will be making the entries:
    • You could make those entries in the module in question or,
    • disregard the data integrity issue if they prefer to keep using the General Journal for adjustments.
      • For example, if it is for Accounts Payable, you should be making entries and adjustments in the purchase invoices module.
    • Your company file cannot have a data inconsistency while in History mode.
  5. Select Maintenance, then Check Data Integrity.
  6. It should now be equal to the line that you just fixed.
  7. Repeat if you have other lines for the affected account in question.


If you did not send the file to an accountant using Accountant Edition:

  1. Pro, Premium and Quantum users are not able to post to linked accounts like Accountant Edition users.
  2. Make a backup of your data.
  3. Select Setup, Settings.
  4. Select the appropriate section for the affected module.
    • Payables (Vendors & Purchases)
    • Receivables (Customers & Sales)
    • Payroll Income
  5. Select Linked Accounts
  6. Highlight the account. For example:
    • Accounts Payable
    • Accounts Receivable
    • Prepaid Sales/Deposits
    • Vacation Payable
    • Payroll Advances)
  7. Select Delete button on your keyboard
  8. The field should now be blank.
  9. Select OK to close the window.
  10. Follow the Troubleshooting steps below.
  11. After you have resolved the issue, you will need to re-link the Linked Accounts you unlinked in the above steps.

Solutions:

Option 1: Total Debit and Total Credit not matching / Retained Earnings opening balance is not correct

Option 2: My Accounts Payable or Accounts Receivable balances do not match my Unpaid Invoices

Option 3: My Deposit (or Prepayment) Account Balance is not equal to my Pre. Order. / Deposit / Prepayment while in history mode

Option 4: Advances & Loans Receivable Balance does not match my Advances and Loans Paid

Option 5: My Vacation Payable Balance does not match my Vacation Pay Owed

Option 6: Goods Received Balance does not match Uninvoiced Goods Received

Option 7: Delivery Orders Balance does not match Uninvoiced Delivery Orders

DocLink: How to import .CSV data
DocLink: How do I post to a linked account?