Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I'm trying to adjust our debtors statement report so that it will run debtors statements only for clients that don't have email addresses recorded in AE. We want to email the debtors statement where possible & we have figured out how to do that. However some of our clients don't have email addresses and still require the paper copy to be mailed.
I have tried to play around with fields and filters in the report however haven't had any success. I'm not sure what I am doing wrong.
Is it possible to adjust the debtors statement report for what I'm trying to do?
Solved! Go to Solution.
I would suggest adding a field to the debtor statement for Email and include a filter of Is Null You will need to add this field to the report at designer level as this field is there isn't there by default.
If you require assistance with this please call our support line on 1300 555 666 queue options 2 2 2 and then 4.
For some reason the filter would not work properly (still brought up clients with email addresses). I rang support and they showed me a workaround in the mail merge function to manually select the statements without email addresses and save as a word document to mail out.
April - last edited April
This is possible via the report but if you have other filters in the debtor statement can be tricky. You need to edit the report and ensure all your OR column filters have the same filter for Emailing.