Microsoft Dynamics GP 2010 added some very cool functionality to the product which allows reports to be generated in Microsoft Word. It is perfect for creating custom layouts with logos and graphics for Sale Order Processing (SOP) and Purchase Order Processing (POP) documents.
This functionality leverages the Dexterity Report Writer as an engine to gather information and export it as XML data. This data is then read by the Microsoft Word template to produce the document.
If you want to get additional data, you need to modify the standard report using Report Writer so that the additional information is included on the modified version of the report. Make sure the Alternate Modified Forms and Report ID has been changed to use the new report and the data will now be available for the template to use.
So you might ask ... Where in the file system can I find the template documents to edit?
The answer is nowhere.
The templates are not stored in the file system at all. To provide a central repository for the templates so they can be accessed by any user from any workstation, they are actually stored in the DYNAMICS.dbo.syReportTemplates table on SQL Server. Note that this table is not defined in any Dexterity dictionary.
Below is a quick step by step guide to creating a modified template:
Part 1 - Creating a new template from the original
Part 2 - Modifying the template
Part 3 - Assigning the template
Note: You can also right click in the Available Templates window to perform most of the actions for the window.
For more information on Word Templates and how to use them, please look at the printable manuals installed with Microsoft Dynamics GP. You will find an entire section In the System Setup Guide (SystemSetup.pdf), look at Part 7: Chapter 34: Word templates. [Edit] There is also a huge amount of information in the Report Writer User's Guide (ReportWriter.pdf), look at the Part 9: Word Templates (Chapters 34-39).
Thanks to Rob Wagner on the Dynamics GP development team for the great work in developing this functionality.
02-Jun-2010: Added details of Word Templates section in the Report Writer manual. Thanks to Steve Kubis for pointing that out.
01-Dec-2010: Added link to Mariano's post: Microsoft Dynamics GP 2010 Word Templates summary.
06-Dec-2010: Updated section on Maintain Compatibility option for Microsoft Word 2010.
Posting from Vaidy Mohan
Great article David, I've been getting a lot of questions about this - now I can just send them to you!
If you want more details about how Word Templates work, look in Part 9 of the ReportWriter.pdf printable manual. For details about using report templates and modified reports, see Chapter 38 in that same PDF. (This information is also available in the Report Writer online help, RW.chm)
Good point about modifying the RW report to add additional fields.
I created this short video that shows the Word Template functionality in action: www.youtube.com/watch
Posting from Mark Polino at DynamicAccounting.net
It's not clear if and how you could make a modified SOP Long Invoice Form available to Word. Is it possible?
I believe the documentation in the Report Writer manual covers this.
I am using Microsoft Dynamics GP Word add on.
We upgrade from GP 10 to GP 2010. During upgrade process i Upgrade our reports to GP 2010.
But according to Documentation some of the report cannot be upgrade eg SOP reports.
So When I use my upgraded reports (SOP Blank order form not created from scratch upgraded from v10 to 2010) in word template i am NOT able to see all fields eg HST/GST/QST Calculated fieds. (But i can successfully print Customer ID, Shipping methods etc) on to word templated
But when i create Report from scratch I am able to see my HST/GST/QST calculated fields even they are prininting correctly on my reports BUT (Customer ID, Shipping methods etc) are not printing on to templates.
This is really strange to me why its like that.
The reports in the GP Report writer are used to create the XML document that integrates with the Word form. That report must contain all the fields you wish to be used on the Word form.
The formatting is no longer relevent, but the fields need to be available. If you are now going to use Word forms, I suggest starting with the original RW report and adding the extra fields you need.
This will fix the not upgradable issues.
If you need more help, please use the forums or a support incident as comments are not the best way to deliver support.
Thanks for your fair explanation, i could use Microsoft Dynamics with ease for now. Keep sharing,
This is a great post, as always!!!
Thanks for caring and sharing :)
Thank you much!
8.Click the green plus sign to Add a template.
9.Locate the previously saved document and click Open.
When i click on the below steps,(8) the green button does not respond,it does not take me to step 9.
NB: Can you do the same for RM Blank Document?
Your input will be highly appreciated
If the Green Plus symbol is enabled, it should open the dialog when clicked. If it does not work, you might need to log a support case.
It works for RM Blank Document for me.
I've been recking my brain with this one. Here is the scenario.. Created SOP Blank Invoice (Modified) work template with compnay logos and format. The Word SOP document generated perfectly on my local machine and client environment VM i.e. Same O/S , SQL and GP2010 version.
However when I copy and import the modified report into the LIVE environment the word engine generates a blank report i.e the design is there but no data is pulling through.
Any idea's or suggestions as to how to resolve this issue?
No quick answer comes to mind. Please note that blog comments are not a good support method.
Can I suggest asking on the newsgroups so others can help and also others can benefit from the answer. There are links for newsgroups and forums on the right hand side of the blog page blogs.msdn.com/DevelopingForDynamicsGP. The other option is to open a support incident.
PLEASE READ BEFORE POSTING
Please only post comments relating to the topic of this page.
If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.