Sage 50 Canada

Welcome to the Sage 50 Canada Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Data Integrity Issue - HELP!!!!

Posted By FWard over 8 years ago

So here is the scenario:

When checking the data integrity, it is noticed it is out. Being new to the company, I've discovered this has been out for several years and no one has corrected it. How do I go about correcting the issue?

Debits and credits are out by $3499.86. Debits is lower than the credits

A/R is out by $3499.86. Debits is lower than the credits.

Everything else is matched.

I've tried the suggestion I found on un-linking the A/R account, making the GJE, then re-linking the A/R account. This fixes the a/r, but not the debits and credits.

Any assistance would be greatly appreciated!

Cheers,

FWard

0 Richard S. Ridings over 8 years ago

There is no Debits or Credits in the A/R line, only the first line. The A/R Balance amount is the balance of your Accounts Receivable account on the Balance Sheet. The Unpaid Invoices amount is literally the total of all unpaid customer invoices.

I would suspect you need to have some data repair done on your file to fix the debit/credit issue. You can talk with Tony Martin of Code-Six Programming. He should be able to tell you if repair is required. He has been doing repair on the Simply/Sage 50 files since the 90's.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

Data Integrity Issue - HELP!!!!

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING