How to calculate the invoice overdue days quantity in the email template?

AI generated answer (using internal Slack threads):

To calculate the invoice overdue days quantity in the email template, you can use a formula field in your saved search that calculates the difference between the current date and the invoice due date. Here's a pseudo-code example of how you might do this:

pseudo
{today} - {duedate}

This will give you the number of days that the invoice is overdue. You can then include this field in your email template. Please note that

{today}

and

{duedate}

are placeholders for the actual fields in your NetSuite environment. Replace them with the actual field IDs. Also, remember that this calculation will give you the number of days overdue for each invoice. If you want to get a total number of overdue days for a customer, you might need to sum up these values. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******