• Data inconsistencies because Retained Earnings is out

    Hi all, We work using terminal servers, and Sage was not being updated on all of the servers at the same time. This caused an issue in a Sage where retained earnings is out of balance. It is a partnership, so at the beginning of each year, we allocate…
  • Data Inconsistencies

    I have run into this issue before and was able to fix it, but can't for the life of me remember how... I'm hoping someone can assist. My Sage 50 Canada (2023.2) file has data inconsistencies. Debits and Credits don't balance. It's not in the A/R or A…
  • data integrity amounts do not match,

    my AR outstanding today is $396,2029.27 on the data integrity screen the AR balance says it is $41,975.09 , the unpaid invoices says $396,029.27 that is exactly what is outstanding, how do I fix this, no journal entries have been made to change anyth…
  • Data Inconsistencies

    Hi there. I keep getting data inconsistencies in a shared file. Last week I ran the Sage_SA_dbutil.exe utility and it fixed the issue. Today again we have inconsistencies. I ran the utility file again and it fixed it again. But any idea why this keeps…
  • AR and Unpaid Customer Invoice amounts don't balance, and I can't start my new year!

    I can't start my new year because they don't balance! I don't know where to look, or how to add in a temp fix so I can move forward. I have an accounting firm go through my books at the end of every year, and I generally just make the changes and additions…
  • Sage 50 CA Premium -- error in how Sage 50 calculates balances re home currency vs foreign (USD) currency?

    We have a USD account for Paypal. We enter the relevant date and exchange rate in the list used for that purpose (under Settings / Company / Currency). For example, at 30 Dec 2016, the Bank of Canada rate is C$1.3427 = USD$1.00, and in the FX list, we…
  • AP error message when trying to start new fiscal year

    Hi All; I have a client that recently started using Sage 50 Pro. When he created the company file, he input the Trial Balance values from the year end that he got from the accountant. This included an amount in A/P. Now he is trying to start his new…
  • First time reversing out a bank reconcilition

    I encountered a discrepancy error when trying to reconcile my current month..after some investigation it appears some previously reconciled date was changed. I found out how to back out of my last reconciliation from the Sage website which I followed…
  • Data Integrity Error

    Hello, I'm attempting to do my first year - end and I'm coming across an issue with the data integrity check. I am showing that my advances / loans recieved and vacation pay balance do not match with the advances / loans paid and vacation pay owed…
  • RE: YEAR END

    Hi Sc@bell, You can follow the link written below to access the knowledge base article for your issue. How to solve "Data inconsistencies have been detected"? In your case, the incsonsistency is between your vacation payable balanace and vacation…