Hi All. Has anyone ever done a prepayments saved search? If so can you please let me know what to add to the criteria and results rows. I am looking to get a Full prepayments reconciliation from Netsuite. So for every prepayment amortization transaction that has a prepayment associated with it, I want to see the amount released(cumulative) to the P&L, Monthly P&L release and outstanding amount to release.

If your amortization feature was setup correctly, you can try the standard amortization reports, specifically the Deferred/Capitalized Expense report

i run an ammortization forcast summary with the column set to period to give me a waterfall looking report. This is what i use for my balance sheet support

@Luis @Jono Thanks!