Microsoft Dynamics GP modifications and custom programming scenarios should be considered when third bender add-ons are further expensive or as well labyrinthine to implement. Provided this is the situation в " you can relatively quickly and valuation effectively fashion your own custom module. We reccomend to check-up such software advance tools as Decided Plains Dexterity, eConnect, SQL stored procedures, Modifier with VBA, GP Integration Manager. In this petite notebook we would liking to commit you customization specification for custom bill mailer via email:

1. Writing PDF documents automatically for the entire batch. The most attractive passage to carry off this engagement is to deploy Dex cursor, which testament come nailed down everyone SOP invoice in the selected batch and will copy this invoice into PDF folder (where the designation of the case should be something unique, coextensive invoice number). You posses to deploy certain PDF writer from Adobe, for nothing versions of PDF printers will not act the job, as GP Dexterity deploys PDF writer driver. There is one more secret to be cognizant в " you will must to establish programmable delay between two invoices in the row, to bestow PDF writer sufficiently day to stop PDF engendering (otherwise you will bend blank invoices or invoices of the duplicate content)

2. Deploying SQL packages at the server. We recommend you to deploy SQL letter or xp_sendmail lenghty stored procedure. Nevertheless other emailing options will too cook the job. In adjustment to avoid security problems (obviously you complete not wish all the GP users to corner the fair to execute xp_sendmail), we recommend you to seperate emailing routine into SQL scheduled duty (which could be executed claim every 30 minutes)

3. Custom Invoice Status table. Here you will be logging invoice info, when Dexterity cursor will put it for the consequent emailing, then when SQL dispatch will system the record you will spending money the status to completed or emailed

4. Alternative email solutions. Whether you would allied to deploy Microsoft Dynamics GP Trouble Portal, then please analysis Electronic Data Delivery module for BP, as it allows you to map SOP invoices to be emailed or delivered to the customer automatically. Obviously Positive Plains Affair Portal Implementation should cut further overhead, on the other hand this doctrine 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 Big league Plains United states and Canada nationwide. Community supply in Chicago, Houston, Dallas, San Diego. Please call our cue portal Pegas Planet: http://www.pegasplanet.com . If you necessitate custom programming for GP, we are elated to maintenance you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We further feather immediate cornerstone to fresh and existing clients via net sessions