Hi Glenn,

Looking at the letter from within Report Designer, which variable is showing the Grand Total?  

What you'd need to do is create a filter to ensure this variable is always above zero.

For help with filters, please click here.

Any issues with this, please let me know.

Hi Adam

Thanks for the response unfortunately as I inherited the report I'm not 100% sure which variable has been chosen. I have discovered that when I tried to alter the following variable (AUDIT_HEADER.DATE_TO - AUDIT_HEADER.DUE_DATE > 0) to just show all invoices due >1 but <7 by this change - (AUDIT_HEADER.DATE_TO - AUDIT_HEADER.DUE_DATE < 7), it started to generate the £0.00 due letters. I have then tried doing the following (AUDIT_HEADER.DATE_TO - AUDIT_HEADER.DUE_DATE > 0 AND < 7) but get the error message "unexpected token".

Do you know how to restrict the 3 Dunning letters to just show:
DL1 - Invoices > 1 but < 7
DL2 - Invoices > 7 but < 14
DL3 - Invoices > 14 but < 21

Thanks

Glenn

Hi Glenn,

It would be better if we can discuss this with you.  Please call us on 0845 111 55 55, or come through via Web Chat and we can look further into this with you.