Custom BIP Report - Lease Accounting Forecasting
Need to create a custom BIP report that sends Opening Liability, Payment Amount, and Closing Liability to our EPM team as they need this information for forecasting.
I found Payment Amount and Number of payments, however when I did a query on Period Name on the FLA tables FLA_LEASE_BALANCES_ALL, it only returns the past periods up until the current period. In the UI of Lease Accounting, it shows periods up until final payment amount. Can you access those periods in BIP back end table? Or is there a SQL formula can use to calculate those?