Dynamics GP 2010 has been out for quite a while, but one of the very cool features that it offers is the ability to leverage the functionality and ease of use of MS Word for GP Reporting needs, and the capability to then send the report via e-mail to customers or vendors directly from Dynamics GP.
With this feature, users can quickly and easily e-mail single documents, batches of documents, and/or multiple documents from a list within Dynamics GP 2010. This works mainly with the Purchasing and Sales Series where you can send the templates to your vendors/customers seamlessly.
Here are just a few of the supported documents that can be used and modified using the new MS Word templates:
- Sales Order Processing Documents:
- Sales Quote
- Sales Order
- Sales Fulfillment Order
- Sales Invoice
- Receivables Invoice
- Receivables Return
- Receivables Debit Memo
- Receivables Credit Memo
- Receivables Finance Charges
- Receivables Warranty
- Receivables Service/Repair
- Purchase Order Processing Documents:
- Standard Purchase Order
- Blanket Purchase Order
- Drop Ship Purchase Order
- Drop Ship Blanket Purchase Order
- Vendor Remittances
Here are some overview steps to get you started in using MS Word templates and using the send e-mail functionality:
I. Email Setup:
- Company E-mail Setup Window (Microsoft Dynamics GP >> Tools >> Setup >> Company >> Email Settings) First you need to set up e-mail options for the company in the Company E-mail Setup windows: Select which document formats will be used and how the documents will be sent in e-mail. Documents can be sent as an HTML, XPS, PDF, or DOCX attachment. You also have the option of having the templates be sent as attachments or embedded in the message body.
Figure: Company E-mail Setup – you can choose the preferred formats for your reporting needs.
- Click on the hyperlink of Sales/Purchasing Series from the Company E-mail Setup window and this opens up the E-mail Setup window of the module selected where one can set which type of documents can be emailed. A Message ID can also be selected from here which will be used as the email message content that will be used by GP when e-mails are sent.
Users can setup the messages from (Microsoft Dynamics GP >> Tools >> Setup >> Company >> E-mail Message Setup window). You would also want to enter an e-mail address that a customer/vendor can use to send a reply e-mail for the document type. The address you enter in this field is the default reply-to address if you create a new message for the sales/purchasing series.
Figure: You can mark the available documents that can be printed with Word Templates in SOP.
Figure: You can mark the available documents that can be printed with Word Templates in POP.
From the Sales and Purchasing E-mail Setup windows, there are the buttons for ‘Customer Setup’ and ‘Vendor Setup’. When you click on these buttons, it opens up the Customers or Vendors list from the Navigation Pane and you can update multiple customers or vendors to enable e-mail options. You can mass select customers or vendors in the list and select E-mail Settings from the Modify group's overflow menu to open the Mass Customer or Vendor E-mail Settings window.
Figure: Multiple customers can be easily enabled for e-mail settings using Navigation List for Customers.
- Setup/Enter e-mail addresses for customers or vendors in GP via the Internet Information window (Microsoft Dynamics GP menu >> Tools >> Setup >> Company >> Internet Information). Another way of also doing this is you can enter directly the e-mail address of the recipient of the e-mail from the i.e. Sales Transaction Entry window and use the E-mail Detail Entry window. Below is a sample screenshot of where it is located.
Figure: Setup e-mail addresses for Customers and Vendors via the Internet Information window.
Figure: E-mail addresses entered from the Internet Information window defaults for the transaction. If there is a need to change an e-mail address on the fly, use the Email Detail Entry window.
- Start sending e-mails. One way of doing it is by using the Navigation List to send e-mails to a list of customers/vendors, or you can also do it per document. Below are screenshots showing this.
Figure: You can immediately e-mail this document to the customer by just looking it up from the Inquiry window and using the ‘Send Document in E-mail’ button.
Figure: You can select and send e-mail for multiple documents and customers, and also use filters to narrow down results within the Navigation List window.
II. Using MS Word Templates: The Word template forms in GP 2010 have some nice advantages to the Report Writer (GP Report Modification Tool) forms, such as increased graphics capabilities.
- The first thing to know is that when installing a GP 2010 client for a user who needs to modify Word templates, you need to also install the “Microsoft GP Add-in for Microsoft Word” found under additional products in the installation media.
Figure: The Add-in is required to be installed for the user who is printing the MS Word templates
This Add-in will add access to Great Plains fields from within Word. Once installed, you will find a “Field List” icon on the Developer tab of Word. This will enable you to add in fields from tables used by the original report into the Word template.
If you don’t see your Developer tab in MS Word, you can enable the Developer tab in Word Options >> Popular >> Show Developer tab in the Ribbon.
Figure: Screenshot may vary depending on the version of MS Office where the Developer tab is being enabled.
- Go to Template Configuration Manager (Reports >> Template Configuration) to enable which templates will be used in GP 2010. The Template Configuration Manager window has a tree view that you can use to select the companies, series, and Word templates you want to use. If you don’t want to use the Word template functionality, you can use this window to disable Word templates.
Figure: It is suggested to only enable documents that will be required to print the MS Word templates. Unmark reports that will not be required to use templates.
- Now start creating/modifying your MS Word templates from the Template Maintenance window (Reports >> Template Maintenance). You can then assign templates to, or remove them from, companies, customers, or vendors as well.
Figure: Once a template is assigned to a report, make sure to use the ‘Assign’ button and set a report as a ‘Default’ for the company.
Some helpful tips on setting up these new features in GP 2010:
- The Word templates are based on the standard reports in GP. If you want to get additional data into your templates, you will still need to modify the standard report using GP’s Report Writer so that the additional information is included on the modified version of the report. Also, make sure that security is granted to the Alternate Modified Forms and Report ID has been changed to use the modified report so that the new information can be used on the Word template.
- On a client workstation, check in Add/Remove Programs and verify that the following two items are installed:
* Microsoft Dynamics GP Add-in for Microsoft Word
* Open XML SDK 2.0 for Microsoft Office (this should be dated 4/1/10 or later) – Ideally this should be initially installed with GP.
Note: These two items are required to ensure MS Word templates can be modified and e-mailed.
- If the client PC printing the MS Word template is using an IP Address in the DSN for GP, this causes issues printing the templates. This is a current Quality Report at Microsoft. It is suggested that the client PC printing MS Word templates has the SQL Server Instance name as the DSN name as a workaround to this. This is also fixed in GP 2010 SP2.
- The user who is printing and sending e-mails using the MS Word template should be a Local Administrator on the workstation.
- If using MS Office 2010 and sending documents as attachments using the PDF format and not ALL of the format options available (DOCX, HTML, PDF and XPS) are marked in the Company E-mail Settings window, e-mails will not be created and sent as the user will get the error “You must have the Microsoft Save As PDF or XPS Add-In for 2007 Microsoft Office installed to send documents”. It is suggested to have all format options enabled to fix this issue.
Now enjoy and start building your templates, and try out the e-mail capabilities.
Edward Jeff Jose is a Senior Business Analyst at Ignify. Ignify is a leading provider of Microsoft Dynamics ERP solutions to mid-market and Enterprise businesses. Ignify has been ranked as Microsoft Partner of the Year Winner in 2011 and 2010 and in the Microsoft Dynamics Inner Circle, Microsoft Dynamics Presidents Club in 2009. Ignify has offices and team members in Southern California, Northern California, Arizona, Tennessee, Illinois, Washington, Canada, Malaysia, India, Philippines.