Hi-
I use an email template for past due reminders (below), but sometimes the <NLDAYSOVERDUE> will produce a much higher number than the actual days past due... It appears that it is using the customer's "overall days past due", when we are really looking for the days past due of the attached transaction.
Can I use formulas in the email templates (ie: "Your invoice has been open for ({today}-{trandate}) days??
Is there another field (besides the <NLDAYSOVERDUE>) which will be specific to the attached invoice?
Any help is appreciated, thanks in advance...
<NLBILLADDRESS>
Please note that our records show that attached invoice <NLTRANID> in the amount of <NLTOTAL> <NLCURRENCYNAME>s was due as of <NLDAYSOVERDUE> days ago.
If you have already sent us a payment for <NLTRANID> please disregard this notice, and thank you for your payment. Otherwise, can you please check with your accounting department and provide us with a status update. Don't hesitate to give us a call if you have any questions; we are always happy to provide assistance.Thank you for choosing XXXXXX XXXXXX for your XXXX XXXXXX needs, we appreciate your business.