Lease Accounting - Generate Full Amortization Schedule on Demand

Hi ERP Reporting Gurus!

I'm trying to build a report that effectively recreates the full lease detail report that is generated when you create the lease or make an amendment to the lease that has the full amortization schedule, including payments and periodic short/long term liability for the life of the lease (not just the closed periods).

Business case: we have a lot of leases, and we need to efficiently pull short/long term liability for our balance sheet forecast. Currently we have to merge the reports together one at a time and it is very tedious to get a periodic ST/LT liability amount.