Questions Renaming (Changing) Email Account ID

I really like the built-in email integration in Acumatica. There are lots of ways to use it throughout Acumatica.

You've probably noticed in Outlook when you receive an email that it doesn't just show you the email address, but also the person's name. If I send you an email, instead of just seeing "tim@gmail.com" you'll see something like "Tim Rodman <tim@gmail.com>".

With Acumatica, the Email Account ID field on the System Email Accounts (SM204002) screen gets used in the From field when the email is sent. The equivalent of "Tim Rodman" in the previous paragraph.

But you might not realize this when you first create the email address. So you might do something like this:

Then you have Acumatica start sending email and you see emails coming into your Outlook as "Default <admin@revisiontwo.com>" which doesn't look very nice.

You might want it to say "Acumatica Support <admin@revisiontwo.com>" instead.

How can you change it?

Well, currently there isn't a way on the screen. It would be nice in the future if the System Email Accounts (SM204002) screen had ACTIONS -> Change ID like the Companies (CS101500) screen does. This is what the Companies (CS101500) screen has:

If you think that would be nice, you can vote on this:
https://feedback.acumatica.com/ideas/ACU-I-2031

Until that happens though, there is a way to change it, but you have to go into the database.

Please don't do this unless you know what you're doing in SQL because I'm not guaranteeing anything here. You do this at your own risk.

In my local demo environment, I can run the following SQL statement and get the following result:

SELECT CompanyID,EMailAccountID,Description
FROM EMailAccount
WHERE CompanyID=2

So all you have to do is run an UPDATE statement to update the EMailAccount.Description field so it will look like this:

That's it. If you do that, then it should be relabeled in the System Email Accounts (SM204002) screen and your emails will be sent from "Acumatica Support <admin@revisiontwo.com>"