Email integration via Azure Graph not working

(1) Share

Report

Posted on by LD-28051634-0

TL;DR My organization is running on-prem Dynamics GP 2018 and is trying to send out automated remittance emails when processing batches. I was able to get this to work several months ago, but after updating our instance of GP to 18.6, the integration no longer works. After the user logs into the MFA app, no mail gets sent.

The integration is set up to use an app registration in Azure AD/Entra to let the user's account access Exchange using MFA. This app uses Graph to access the user's mailbox and send mail. GP connects to this app after I enter the app I.D. into the /Company E-mail Setup/ window, then log into Entra with my admin account.

When a batch is processed and GP tries to send email, the user is prompted to log into the cloud. Since the user is already logged into a virtual desktop using an Azure-linked account, they usually just click their username to progress:

After this, the email should go out. However, it never does. It's not a mail delivery issue, since it's not even leaving the user's mailbox. It's not Azure either, since there's no error after logging into the user account.

These are the guides I consulted when setting it up in June of last year:

https://community.dynamics.com/blogs/post/?postid=bce65f37-eb08-4531-b62b-32a8af728f58

https://learn.microsoft.com/en-us/dynamics-gp/whats-new/multi-factor-authentication

I have attempted the following while troubleshooting this issue:

Consulted https://learn.microsoft.com/en-us/dynamics-gp/installation/email-troubleshooting-guide#mfa---multi-factor-authentication-modern-authentication
Double-checked that the app I.D. was correct
Created new app registrations, both multi-user and single-tenant, with proper settings for both (consulted: https://community.dynamics.com/blogs/post/?postid=18194a5d-4b7f-ee11-a81c-6045bdbe566c)
Tried filling out the /Web Client Properties/ section in the /Company E-mail Setup/ window: application (client) I.D., key, and redirect URL

If anyone has any ideas, I'm all ears. I'm not sure what else to try.

I have the same question (0)

All responses (8)

Answers (0)

Elizabeth Hodge 162 on at

Like (0)

Report

I'm having the same problem...

Was this reply helpful? Yes No
Talon Meyer 91 on at

Like (1)

Report

Which build of 18.6 are you using?

Have you confirmed the Word template for Remittance notices is still being built? There was a known issue with 18.6 where the upgrade routines corrupted some Word templates stored in the database: https://community.dynamics.com/forums/thread/details/?threadid=4fd1611a-edab-ee11-be37-00224827e905

If the Word template was corrupted, it would stop your remittance email from going out too.

After attempting to send out remittance emails, check the temp folder of the machine to see if the template was generated or not.

Was this reply helpful? Yes No
LD-28051634-0 21 on at

Like (0)

Report

Hello, thank you for your suggestion! Unfortunately, we never had these fields configured in our Word template. Below are the values post-update vs pre-update:

I will check the temp folder on the machine to see if the template is being generated correctly. I will provide an update on Thursday 2/29.

Was this reply helpful? Yes No
LD-28051634-0 21 on at

Like (0)

Report

@Talon Mayer

The user processed the batch again today. Again, the emails were not sent out. I checked the temp folders on the user's machine and did not see the Word template anywhere. I looked in C:\%USERPROFILE%\AppData\Local\Temp and C:\Temp.

I assumed the template would be a Word document. Is this not correct? Could it be a DAT file?

Was this reply helpful? Yes No
Talon Meyer 91 on at

Like (0)

Report
The file type is based on the file type selected for that vendor, usually .docx but .pdf and .xps are also options in that setup screen. I have seen GP create the documents in a subfolder below the TEMP directory, usually typing %TEMP% into the Windows Explorer address bar will get you to the same folder that GP is using. Here's a variety of next steps I would consider:

Double check the %TEMP% folder for docx, pdf, or xps files after the user generates the remittance

Can you "Print Remittance" instead of emailing? If it won't print the Word document to screen, it will not be able to email either

Watch the "Templates Processing" bar at the bottom of GP to see if the files are generating successfully (or even trying to generate when emailing)

Is this specific vendor configured for EFT Remittance Emails?

Was this reply helpful? Yes No
LD-28051634-0 21 on at

Like (0)

Report

Thanks Talon. I do not think any templates are being generated. While there are Word docs and PDFs in %TEMP%, none of them are remittance templates. I truly don't think the templates are being generated. I've also verified that when processing all batches, the "Remittance Form" option is checked. I've also verified all vendors are configured to use EFT remittance.

I'm trying to research why these templates aren't being generated, but I haven't found anything yet. I'll keep trying and provide an update if I find anything.

Was this reply helpful? Yes No
LD-28051634-0 21 on at

Like (0)

Report

Apologies for the lack of updates - this ticket was taken from me and I just got it reassigned. The Word template is not being generated, however, a report is printed at the end of the process. I'm not sure if it's the same as a remittance report.

Was this reply helpful? Yes No
LD-28051634-0 21 on at

Like (0)

Report

Was fixed a couple weeks ago. According to the tech I spoke to, GP UI settings can sometimes get out of sync with the backend. We ended up wiping out email integration settings in the Company E-mail setup window (Microsoft Dynamics GP > Tools > Setup > Company > E-mail Settings), then repopulating them, and following this guide with the tech, but I think the real fix was removing our corrupted "send replies to" fields.

These fields were under Microsoft Dynamics GP > Tools > Setup > Company > E-mail Message Setup and Microsoft Dynamics GP > Tools > Setup > Company > E-mail Settings > Purchasing Series.

Once we deleted these fields, the remittance emails started being sent.

Was this reply helpful? Yes No