Hi All,
We are facing the reconciliation issue in AR. AR Reconciliation Report balance is not matching with the Aging 7-Bucket report. If somebody encountered the same problem please post your comments.
Thanks,
Anjan
AR Reconciliation Report and Aging 7-Bucket report
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
Aging reports displays only receipts that are Eligible to be received after the due date.
Which means you made a sale on 1st JAN and you have given your customer 30 days credit period.
So when i run Aging report on any day between 1st JAN to 30th JAN, system will not display this transaction.
However if i ran this on 31st onwards, aging report will pick these transaction...
In short, aging reports only outstanding balances ....
Whereas reconciliation report picks transactional data .
I feel this could be the difference.....
Please check individual AR transactions on a test basis to find out the logic of these reports and differences between these reports....
Which means you made a sale on 1st JAN and you have given your customer 30 days credit period.
So when i run Aging report on any day between 1st JAN to 30th JAN, system will not display this transaction.
However if i ran this on 31st onwards, aging report will pick these transaction...
In short, aging reports only outstanding balances ....
Whereas reconciliation report picks transactional data .
I feel this could be the difference.....
Please check individual AR transactions on a test basis to find out the logic of these reports and differences between these reports....
Hello.
Yes, what you say is correct. But these two reports can be compared. Run AR Reconciliation with parameter GL Date High = 31stMay 2009 and then run Aging Report with pameter As of Date = 31stMay 2009.
You will see that total for Ending Balance of AR Reconciliation is equal to total of the Outstanding Amount column of Aging Report.
That's why i say these two reports can be compared.
Octavio
Yes, what you say is correct. But these two reports can be compared. Run AR Reconciliation with parameter GL Date High = 31stMay 2009 and then run Aging Report with pameter As of Date = 31stMay 2009.
You will see that total for Ending Balance of AR Reconciliation is equal to total of the Outstanding Amount column of Aging Report.
That's why i say these two reports can be compared.
Octavio
Who is online
Users browsing this forum: Google [Bot], Google Adsense [Bot] and 1 guest