Great,Plains,Customization,Aut computer Great Plains Customization: Automatic Sales Invoices emailin
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
We recommend to review such software development tools as Great Plains Dexterity, eConnect, SQL stored procedures, Modifier with VBA, GP Integration Manager. In this small publication we would like to give you customization specification for custom invoice mailer via email:1. Writing PDF documents automatically for the whole batch. The most elegant approach to achieve this task is to deploy Dex cursor, which will come through each SOP invoice in the selected batch and will write this invoice into PDF file (where the name of the file should be something unique, like invoice number). You have to deploy real PDF writer from Adobe, free versions of PDF printers will not do the job, as GP Dexterity deploys PDF writer driver. There is one additional secret to know you will need to set programmable delay between two invoices in the row, to give PDF writer enough time to finish PDF generation (otherwise you will get blank invoices or invoices of the same content)2. Deploying SQL mail at the server. We recommend you to deploy SQL mail or xp_sendmail extended stored procedure. However other emailing options will also do the job. In order to avoid security problems (obviously you do not want all the GP users to have the right to execute xp_sendmail), we recommend you to separate emailing routine into SQL scheduled task (which could be executed say every 30 minutes)3. Custom Invoice Status table. Here you will be logging invoice info, when Dexterity cursor will place it for the following emailing, then when SQL mail will process the document you will change the status to completed or emailed4. Alternative email solutions. If you would like to deploy Microsoft Dynamics GP Business Portal, then please review Electronic Document Delivery module for BP, as it allows you to map SOP invoices to be emailed or delivered to the customer automatically. Obviously Great Plains Business Portal Implementation should take additional overhead, but this solution comes from MBS directly and its is supported by Microsoft
Great,Plains,Customization,Aut