Is there any stored Procedure wich conect with GP2010 to send mails for Outlook?

(0) Share

Report

Posted on by Do you know how to ...

hello,

i have a problem with business portal while users are trying to make purchase orders and the company has decided not to use any more business portal to make purchase orders, so what they want to do is to replace business portal to GP2010 to make purchase orders, but they have two profiles, one of them is the approver and the other one is the pocreator, they want that when the pocreator create a purchase order sends automatically an email to the approver using an stored procedure like sp_send_dbmail.

Is there any way to make that using sqlserver2008r2?

please help me!!!! thanks.

*This post is locked for comments

All responses (2)

Answers (0)

Alaa Ramadan 4,096 on at

Like (0)

Report

RE: Is there any stored Procedure wich conect with GP2010 to send mails for Outlook?

In case if you do not have SharePoint, Have you tried creating a trigger on table POP10100 to auto-send email using SQL upon INSERT?
Suggested answer

Olaf Laos 1,890 on at

Like (0)

Report

RE: Is there any stored Procedure wich conect with GP2010 to send mails for Outlook?

Have you considered using the SharePoint Workflow for Dynamics GP? - there is an out of the box "Purchase Order Approval" workflow. which has the ability to process e-mail notifications in the manner you describe above (and can be very much more sophisticated if required).