Hello Everyone,

Unlike Sage 200, Sage 50 does not have an option to send reminders automatically or to send reminders for invoices that are approaching due. I'm hoping to be able to customise the built in letter template "Itemised Chase Letter 1 (Reminder) - Balances based on customer payment terms".

This template uses a filter to only show invoices which are over due - the filter is

"AUDIT_SPLIT.TYPE LIKE "SI" AND SALES_LEDGER.RESTRICT_MAIL = 0  and COMMUNICATION_ADDRESS.LETTER_TYPE_ID = 1 AND (AUDIT_HEADER.DATE_TO - AUDIT_HEADER.DUE_DATE > 0) AND AUDIT_HEADER.AGED_BALANCE > 0.0"

Any ideas how to change this filter so that the letter will show invoices which will be due within the next week (7 days)? So for example, clients with 30 day terms would only include invoices which were raised 23-30 days old.

Thanks