Developing customer ledger
I am developing a customer ledger report in Oracle receivables and I am trying to match the results of this ledger's closing balance with aging report outstanding amount.
I am having issues with receipts especially when the receipts gl_date on receipt header and gl_date on application differ.
Tables used for this purpose are
ar_cash_receipts_all
ar_cash_receipt_history_all
ar_receivable_applications_all
However, the gl_dates on ar_cash_receipt_history_all and ar_receivable_applications_all are causing issues. I wanted to pick gl_date from ar_cash_receipts_all but could not find any column for this.
I am having issues with receipts especially when the receipts gl_date on receipt header and gl_date on application differ.
Tables used for this purpose are
ar_cash_receipts_all
ar_cash_receipt_history_all
ar_receivable_applications_all
However, the gl_dates on ar_cash_receipt_history_all and ar_receivable_applications_all are causing issues. I wanted to pick gl_date from ar_cash_receipts_all but could not find any column for this.
0