Does it have to be scripted? Or can it just be a regular template somehow?

I can't find a way to join transactions from the customer record let alone filter by open invoices. Maybe a search email template...