SageForum for UK versions of Sage 50- Help and support.

I am running Sage Line 50 and have got a difference between the Aged debtors listing and the trial balance code 1100. There is a difference when I run May 2009, but April 2009 is ok. I have run the customer activity report and compared it to the nominal activity (I have done this for both May to date and also the entire history of transactions on Sage). I have found no differences and cannot think of anything else to check!

Can anyone please help?

Thanks!

L

Look for a journal made to the control account

Hi,

I've tried that too... I ran the entire history of 1100 to excel and sorted it by transaction type to find anything unusual. The only journal transaction is the opening balance from about 5 years ago!

You HAVE run check data and it has NOT reported any errors has it?

If it is not a journal it is probably bad data corruption.

You can list all the journals easily using the Day books Nominal Ledger report in Company/Nominal ledger

Have you checked for mis dated transactions ie future transactions that are not being picked up?

I have finally resolved this and think it must have been data corruption.

The error checker was showing no errors... I run this weekly now due to past data corruption problems.

I ticked up the aged debtors and matched the invoices to receipts and checked what was showing as outstanding. There were invoices which were being shown as matchd to a receipt, but for which the receipt was not showing on the system. I have now corrected this problem.

Thanks for your help.