Is your Aging - 7 Bucket by Account Report not matching with your India-Debtor Trial Balance Report?
Are you using any localizations, such as India Localization?
These two reports are not designed to tally, AR Aging Report may not match with India-Debtor Trial Balance Report due to Localization issues. India debtor Trail Balance will capture the transactions where they are having India Localization Taxes. Whereas Aging Report will capture all the AR Related transactions.
Some information on the AR Aging Reports:
Provides data on outstanding Receivables as of a specific date
Reports customer information in Detail and Summary modes
Shows current and past due transactions for invoices, debit memos and chargebacks
Choose to age or summarize credits and payments
See cash claims (if using Oracle Trade Management)
Sort by Company, each item allocated to a company
Excludes customers with zero balances
So Reconciliation between this two reports is sometimes not possible due to localization issues not captured in the Aging.
For further information, please refer to Doc ID 834176.1 AR Aging Report is not matching with India-Debtor Trial Balance Report