Hey Jonathan,

The link goes to a page on CustomerSourse, to login you need two things:

First a Microsoft Account (Live Id), I use a Hotmail.com account.

Second you need that Account associated to you Companies CustomerSource Profile, your Dynamics GP Partner should be able to do that for you.

The easiest way to get all of the above is to give your Partner a call, they can walk you through the entire process and give you lots of information about the site.

Let me know if there is anything else I can do to help,

John

Hi,

I find this thread very informative but i am not able to access the kb article. It seems that a special microsoft account is required. Can someone help me out with access the article in order to proceed with the implementation.

Thanks and regards

Jonathan Falzon

Hey Sandip,

I apologize for taking so long. The problem you are having is that while you have the server setup for sp_send_dbMain, Dynamics-GP by default still uses xp_sendmail. To change Dynamics-GP to use sp_send_dbmail please read the KB article 915097 on customersource especially part four which actually has the links to download the necesary code changes. NOTE: you need to run the company scripts on each and every company database.

Please let me know if there is anything else I can help you with.

John

John,

while creating Business Alerts I am getting following error : "The following error occured in SQL Server : xp_sendmail: Either there is no defaul mail client or current mail client cannot fulfill the messaging request. Please run Microsoft Outloook and set it as the default mail client"

I am using "Database Mail" option in SQL Server Agent Alert, where as when I run execute sp

EXEC msdb.dbo.sp_send_dbmail

@profile_name ='GPAlert',@recipients = 'sandip@abc.com',

@body = 'Just testing the mail',

@subject = 'Sending Mail using Database Mail' ;

GO

It work fine. Don't know why GP Business alerts is not working.

How can I change " Dynamics GP Business Alert to "SP_Send_DbMail" ?

Your earliest reply is highly appreciable.

Thanks

Sandip Jadhav