We are unable to generate a receivable /payable report where we can get unpaid invoices/bills with unused credits. It happens many times that we have to keep unused credit without matching it against invoice/bill until full and final settlement.

Tally provides such info as below attached screenshot, where On Account entries are Unused credits.

Pl do let us know how to generate receivable/payable statement in such a way. And how to send such statement as email reminder.