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
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
TB V's Trade debtors difference
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: TB V's Trade debtors difference
Look for a journal made to the control account
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: TB V's Trade debtors difference
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!
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!
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: TB V's Trade debtors difference
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?
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?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: TB V's Trade debtors difference
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.
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.
Who is online
Users browsing this forum: Semrush [Bot] and 12 guests