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.

Description

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

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.

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. It’s possible the accountant made a general journal entry directly to the control account instead of using the transaction module in question. Return the backup file to the accountant to void the general journal entries that affected the control account.
  2. If the accountant will be making the entries:
    1. 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. (Not recommended)
    2. The company file cannot have a data inconsistency while in History mode and Sage 50 will not allow you to advance into the new year
  3. To post Accounts Receivable adjustments, use the Sales Invoice module and not in the General Journal. Use a negative value to decrease the Accounts Receivable balance. Use positive value to increase the balance.
  4. To post Accounts Payable adjustments, use the Purchase Invoice module and not in the General Journal. Use a negative value to decrease the Accounts Receivable balance. Use positive value to increase the balance.


If you did not send the file to an accountant using Accountant Edition, select the inconsistency below:


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 Account Balance is not equal to my Pre. Order. / Deposit 

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

Option 8: My Prepayment Account Balance is not equal to my Prepaid Orders subledger


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