Custom Emailing for Microsoft Great Plains Dynamics GP - SQL Mail - Alba Spectrum

For Microsoft Dynamics GP ERP you can deploy Business Portal andBP module Electronic Document Delivery, however it is not available for GPBusiness Ready product line, where you have to go for custom solution. In thissmall article we recommend you to use MS SQL 2005 mail: xp_sendmail extended storedprocedure. Another requirement is to use Adobe PDF Writer (version is notimportant, whatever is compatible with Windows XP an Vista will do the job):1. SQL Mail setup. The easiest way to setup SQL mail is to launch SQL Serverservice under windows domain account. Then you install MS Office Outlook client onthe server (MAPI application), make it work for Windows domain login virtuallysending and receiving email. In order to be sure that you are done with SQL emailsetup, open MS SQL Server query and try to send probe email: xp_sendmail john@gmail.com , Test ;2. Email attachment problem and work around. Well if you will try to use non-sauser to call xp_sendmail with attachment, something like the following: xp_sendmail john@gmail.com , Test , @attachments= C:\invoice.pdf you will get errormessage, where it will recommend you to use impersonated windows account to workwith attachments. Seems like SQL 2005 has some internal issues with SQL loginimpersonation, and at this time (December 2007) it simply putting doesn t work. Work around is the following: create SQL job which will be running under sa accountand will be calling xp_sendmail, schedule this job to run, say every 10 minutes, andit will check all the documents to be ready to be emailed to your customers withattachments3. Adobe PDF Writer. Microsoft Dynamics GP requires you to use Adobe PDF Writer tosave documents, such as SOP Invoices and Sales Orders to the file. You may think totry using free third party PDF printing solutions, such as Cute PDF, however thisapproach doesn t work with current and historical versions of Microsoft Great PlainsDynamics GP: 6.0, 7.0, 7.5, 8.0, 9.0 and 10.04. Great Plains ReportWriter forms: SOP Blank, Long and Short forms. Here you wantto place your company logo, please review Microsoft Dynamics GP guidelines for yourgraphical logo format to have it printed smoothly and professionally. If you wouldneed several different logos on your invoice form, you should consider deployingblank, short and long SQP invoice forms to do the job actually you could make themall these three forms the same, just with different logos5. Alternatives to SQL Mail. You can consider Sendmail Windows utility or Telnet. Both of them tend to rely on Linux and Unix features and skills, so technicaldiscussion fells out of scope for this tiny article

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com -help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canadanationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah,Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond,Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, MissionBend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville,Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove,Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris,Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale.

Source: Express-Press-Release.com

Get RSS updates on latest computer technology and software related press releases   

You are welcome to include these headlines in your own pages. If you want to find out how to parse this RSS file please read our tutorial How to parse RSS feeds with PHP.