urgent need of AR to GL reconciliation script
we have completed all the Transactions as well the payments in AR successfully and have closed the period.The AR reconciliation report matches correctly with the aging balance report of customer .we have transferred all the transactions from AR to GL and tried to match the receivable account of AR in Genenral Ledger Trial Balance,
But unfortunately there are no scripts available for us , we are currently using 11.5.0.2,( India Localisation). If anybody from the group can provide me with any oracle std SQL scripts then we can successfully check the reconciliation status.
My patchset level is 11i.AR.N,I know there are some reports such as 'AR to GL reconciliation'available in the patchset version of 11i.AR.O and higher.But I dont think we can really go for upgradation patches right now.if anyone of you have the scripts and experience of doing so for the old level,kindly help me out.