Fixing ‘Could not e-mail status report to Sender. Invalid Recipients’ error in GP 2013
GP 2013 has taken a very big step towards consolidating and simplifying email setup windows. What information used to be found on several different windows across several modules are increasingly becoming consolidated onto the Internet Information card.
Part of the downside of this is that certain fields were dropped from the Receivables Management setup window, even though they are still used in the system.
GP 2013 users have been reporting that when they go to Query Letters and send them out in an email, they receive the following error:
‘Could not e-mail status report to Sender. Invalid Recipients’ is caused because the Email Statements Status Recipient field has been removed from the Receivables Management Setup window.
This email is used to send a status report after collection letters have been emailed out, so that for example a collections manager can review them and make sure no letters erred out before being sent to customers.
A one time fix to this is to manually populate the field in SQL Server Management Studio, changing the email address appropriately:
update RM40101 set EmailStmtStatusRecipient = ‘email@example.com’
That will make the error go away and you will start receiving the status report again at that address. If you need to change it in the future, simply run the update statement in SQL again, changing the address as needed.
For more tips on setting up Email in Dynamics GP, check out Making sure your system is setup for Collections Management Email.
**Note: Make sure you make a backup and try steps in a test company first before applying to live**