Issue with Write-off Transactions in Customized AP Aging Report
We developed a customized AP Aging report (with an As of Date parameter) using the AP_LIABILITY_BALANCE table and the logic ACCOUNTED_DR – ACCOUNTED_CR.
However, we found that when there are Write-off transactions, the report is not accurate because we do not want to include the Write-off accounting entries and their corresponding Liability accounts.