Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

E-Mail Not Working

Posted on by Microsoft Employee

Hello:

I have read blogs and tech articles on configuring Office 365 e-mailing in GP 2018.  One company has a situation where such e-mailing works for some users but, for others, it does not.

I cannot find any discernible pattern among the users, as to why e-mailing is working for some and not others.

The users who are receiving the issue are receiving a “login failed” message after entering their passwords.

Any thoughts?

Thanks!

John

  • LeighNorman Profile Picture
    LeighNorman 5 on at
    RE: E-Mail Not Working
    [quote user="Derek Albaugh"]

    In the Exchange Log In window, instead of entering your O365 email address and password, you would instead replace the password with the app password, in order to get past MFA.

    The only place in Dynamics GP that app passwords will not work is the Workflow Setup window, as the password field only allows 15 characters and app passwords tend to be longer than that.

    [/quote]

    When prompted with the Exchange Log On window, make sure the users are clicking the ‘Advanced Option’ link in lower LH corner and mcdonald's survey enter the O365 email address for both the ‘Email Address’ and ‘Login ID’ fields. (NOTE: I’ve also seen it work with leaving the ‘Login ID’ field blank/empty as well).

  • RE: E-Mail Not Working

    Hello Bob,

    I've seen both work, where the Login ID field is populated as well as not being populated, for the Exchange Log On window.

    I would also say, depending on what build of Dynamics GP 2018 you're on, the app password can only be 15 characters if on pre-Dynamics GP 2018 R2, otherwise 21 characters maximum if Dynamics GP 2018 R2 or later.

    Thanks,

  • Bob Callanan Profile Picture
    Bob Callanan 785 on at
    RE: E-Mail Not Working

    Derek:

    I'm still unable to get past MFA here: In GP and the "Exchange Log On" window. I am entering 3 pieces of data:

    1. Email address: my email address

    2. Password: the APP password that I just created

    3. Login ID: my email address again.

    Is that correct? I have several users trying the same with no luck

  • RE: E-Mail Not Working

    In the Exchange Log In window, instead of entering your O365 email address and password, you would instead replace the password with the app password, in order to get past MFA.

    The only place in Dynamics GP that app passwords will not work is the Workflow Setup window, as the password field only allows 15 characters and app passwords tend to be longer than that.

  • Bob Callanan Profile Picture
    Bob Callanan 785 on at
    RE: E-Mail Not Working

    Derek:

    Are you suggesting the we CAN use App Passwords in Dynamics GP? If so how? In the past 3 days we've run into several clients that recently implement MFA and are no longer able to email SOP Invoices, AP Check Remittances from GP. This seems pretty critical to me.

  • RE: E-Mail Not Working

    Hello John,

    I’ll first address O365 email accounts, as those are what we see the most issues with, due to all the setup on the O365 / Exchange Online side of things…

    1. First, along with ‘modern’ authentication that O365/ Exchange Online uses by default, Dynamics GP also requires that ‘basic’ or ‘legacy’ authentication be enabled as well, otherwise email will not work.

    2. If you have multi-factor authentication (MFA) enabled on the O365 email accounts, you must use app passwords in Dynamics GP to get around this, or disable MFA on the user's Exchange email address.

    I’d recommend going through the following blog if you haven’t already done so:

    ‘Exchange Online O365 Emailing inside Dynamics GP’

                 community.dynamics.com/.../exchange-online-o365-emailing-inside-dynamics-gp

    >>When prompted with the Exchange Log On window, make sure the users are clicking the ‘Advanced Option’ link in lower LH corner and enter the O365 email address for both the ‘Email Address’ and ‘Login ID’ fields. (NOTE: I’ve also seen it work with leaving the ‘Login ID’ field blank/empty as well).

    >> In the SY04920 system table for Dynamics GP, make sure there is a record for the user’s GP USERID, an Exchange_Address showing the user’s email address they’re entering in the Exchange Log On window and the Exchange_Server_URL value will show something like the following: ‘outlook.office365.com/.../Exchange.asmx’.

          If you take the Exchange_Server_URL value and put it in a browser window, after entering credentials again, it should open up a ‘Service’ page with a WSDL link on it and more.

          I have seen a couple of cases where we’ve manually entered a record into this SY04920 table for the user’s GP login, email address and this URL, and they could then email through Dynamics GP successfully, after finding a record doesn’t already exist for the user.

                     INSERT SY04920

              Values (‘GPUser1’, ‘MyEmailAddress@msn.com’, ‘outlook.office365.com/.../Exchange.asmx’)

       After entering a record for the user into the SY04920 table, have the user log out and back into Dynamics GP and they can try emailing again.

    I'd start with the above and see if that resolves the 'login failed' message being seen for some users in Dynamics GP when attempting to email via Exchange, while other users can email successfully.

    You may also want to compare the configuration of the O365 email accounts for the users that can email successfully through Dynamics GP compared to the O365 email accounts that cannot. Most cases we see it's more of an issue of none of the O365 accounts can email through Dynamics GP.

    Thanks,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans