Skip to main content

Notifications

Dynamics 365 Community / Blogs / DynamicAccounting.net / Weekly Dynamic: Dynamics GP...

Weekly Dynamic: Dynamics GP and Hosted Exchange

With Dynamics GP one of the options for sending emails is to use an Exchange server. This process is a little bit of black box in that you put in your email and password and GP figures out the rest. For local Exchange servers and Office 365 this seems to work pretty well. But what if you’re on a hosted Exchanged server that is not Office 365? Well, that’s not officially supported so you’re just screwed, move on, nothing to see here.

Oh wait. You’re not the type to give up that easily? Well neither am I.

If you’re on a hosted Exchange server there are a couple of options.

1) Hit the Show Advanced button and put in alternate credentials.

When you hit one of the windows where you can set your email information (for example: Administration > Company > Email Message Setup) his the Show Advanced button and input an alternate Login ID. Often these are provided when a hosted Exchanged account is setup.  This is the simplest option. If this doesn’t work, move on to option 2.

Capture

2) Add the missing information to SQL.

What’s happening is that GP is trying to auto detect the Exchange server. If it fails or your login doesn’t seem to work, you really don’t have any other options via the interface. This is what worked for me recently:

  • Connect to the user’s Outlook Web Access and ensure that the user can log in.
  • Once you know that works, grab the URL up to and including the .com (or other extension).
  • Past that into notepad and add /EWS/Exchange.asmx to the end. Office 365 looks like this for example: https://outlook.office365.com/EWS/Exchange.asmx. Other providers will have different web addresses but the /EWS/Exchange.asmx seems to be standard.
  • Open up SQL Management Studio and use this to add the user and Exchange location to the Dynamics SY04920 table. You need the user’s GP login, their email address and the server location with the /EWS/Exchange.asmx piece.

The code would look something like this:

USE [DYNAMICS]

GO

INSERT INTO [dbo].[SY04920]

([USERID]

,[Exchange_Address]

,[Exchange_Server_URL])

VALUES

(‘jdoe’

,’jdoe@fakedhostedexchange.com’

,’https://host6.fakehostedexchange.com/EWS/exchange.asmx’)

GO

The trick is getting GP to figure out the server. This tells GP what server to use and what credentials to pass. If there are more parameters after the .com extension you want to ignore them.

Keep in mind that this process ‘could be a challenge if you are regularly adding users who send out emails and you have to add their email info via SLQ each time. Because of this option 1 is preferred if you can make that work.

The post Weekly Dynamic: Dynamics GP and Hosted Exchange appeared first on DynamicAccounting.net.


This was originally posted here.

Comments

*This post is locked for comments