Payables aging report to be run based on "As on date" as parameter.

All,

we need a solution to automatically fetch Amount Remaining based on As of date parameter entered in AP Aging. And this is really critical for the business to avoid reconciliation issues.

Please refer attached example on how to fetch Amount Remaining balance based on as of date parameter in AP Aging report or is there anyway to derive from table.

As we built a custom report but we are facing one or other scenario the report is failing like prepayments or prepayment applications missing or discussions missing.