Microsoft Dynamics GP modifications and custom programming scenarios should be considered when third amusement add-ons are as well expensive or besides heterogeneous to implement. Provided this is the condition в " you can relatively quickly and worth effectively enroot your own custom module. We reccomend to argument such software operation tools as Enormous Plains Dexterity, eConnect, SQL stored procedures, Modifier with VBA, GP Integration Manager. In this mini textbook we would close to cede you customization specification for custom bill mailer via email:

1. Writing PDF documents automatically for the integral batch. The most lovely way to conclude this daily grind is to deploy Dex cursor, which testament come finished everyone SOP invoice in the selected batch and will create this invoice into PDF record (where the eponym of the document should be something unique, according to invoice number). You admit to deploy absolute PDF writer from Adobe, for nothing versions of PDF printers will not achieve the job, as GP Dexterity deploys PDF writer driver. There is one supplementary secret to appreciate в " you will charge to establish programmable delay between two invoices in the row, to come across PDF writer sufficiently bout to stop PDF engendering (otherwise you will amuse blank invoices or invoices of the equivalent content)

2. Deploying SQL dispatch at the server. We recommend you to deploy SQL letter or xp_sendmail lenghty stored procedure. But other emailing options will and bring about the job. In disposition to avoid security problems (obviously you end not thirst for all the GP users to hog the licence to execute xp_sendmail), we recommend you to seperate emailing routine into SQL scheduled charge (which could be executed speak every 30 minutes)

3. Custom Invoice Status table. Here you will be logging invoice info, when Dexterity cursor will levy it for the closest emailing, then when SQL packages will action the folder you will alternate the status to completed or emailed

4. Alternative email solutions. Whether you would akin to deploy Microsoft Dynamics GP Episode Portal, then please file Electronic File Delivery module for BP, as it allows you to map SOP invoices to be emailed or delivered to the customer automatically. Obviously Ample Plains Biz Portal Implementation should share further overhead, on the contrary this meaning comes from MBS directly and its is supported by Microsoft

Andy Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Worthy Plains United states and Canada nationwide. Regional overhaul in Chicago, Houston, Dallas, San Diego. Please vacation our confidence portal Pegas Planet: http://www.pegasplanet.com . If you compulsion custom programming for GP, we are elated to maintenance you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We further bestow immediate collar to dissimilar and existing clients via lacework sessions