The Dynamics GP Blogster

Working recently on an issue, I ran into a situation where I would get the following template processing error attempting to print a SOP Invoice - if you look at the bottom status bar, next to the user ID, you will see a Template Processing accompanied by a yellow warning triangle. Upon inspecting the Template Processing status, I ran into the following Exception Detail message: The following error occurred while processing this report: One or more templates could not be processed. View the exception log for more details. Since the error was referencing a template, I figured I would go back and check to make sure I could edit the template, which was based on the original SOP Blank Invoice Form Template. Upon attempting to modify the template, I received an error: File Not Found:"C:\Users\ \AppData\Local\Temp\SOP Blank Invoice Form Template.docx". After attempting to print the template, and after all the subsequent tell-tell sign errors, I attempted to ex...

How about this 2014 year, ah? Two major releases in Microsoft Dynamics GP 2013 R2 only to top off the year with the recent release of Microsoft Dynamics GP 2015 . More than 30 new features in 2013 R2 (over 150 if you include those released in GP 2013 RTM) and now over 120 new features in Microsoft Dynamics GP 2015, including the cornerstone .NET interoperability and Service Based Architecture components, it's no wonder why the Microsoft Dynamics GP Product Management and Product Development teams deserve a massive showing of the hands on this one! Congratulations team on a job well done. Let's not forget about the events either: the wildly successful Microsoft Convergence 2014 Atlanta , the hugely concurred GPUG Summit 2014 St. Louis , and what's got to be the most anticipated partner event since the days of Stampede, reIMAGINE 2014 in Fargo. All these events drove the vision of t Travel was also off the chain for me: Johannesburg, South Africa; St. Louis,...

Just recently I was working on a Sales Invoice Word Template customization for a customer and ran into a strange issue when attempting to print a batch of invoices for customers assigned to this template. When printing the entire batch of invoices, the following error would appear: Once the OK button was clicked, Word would proceed to display the following error message: "Word found unreadable content in "Template.docx" . Do you want to recover the contents of this document? If you trust the source of this document, click Yes.". Upon clicking the Yes button, Word would go to work and "recover" the document in perfectly good condition with the invoices matching to the penny. What makes this even more puzzling is, if you print each invoice individually from the Sales Transaction Entry window, there would be no error and invoices would print fine. Solution To troubleshoot this issue, one just needs to focus on the original error - I assume ...

A few days aback I encountered a really interesting discussion on the Microsoft Dynamics GP Community forum  where the user needed to get the parent customer information on the SOP Blank Invoice Form. I asked myself, "Well, how difficult can that be?" The first thought around these requests is, you create a table relationship between the Sales Transaction Work (SOP_HDR_WORK) table and the RM Customer Master (RM_Customer_MSTR) table by Customer Number and you get the parent customer ID. In that train of thought you immediately realize that there's no way to alias the RM Customer Master table back into the table relationship to retrieve the parent customer ID information. [NOTE TO SELF: this would be a cool Report Writer feature, but I digress.] Of course, a second alternative is to use VBA, but many customers and partners are wary of implementing a VBA solution, especially when they are considering upgrading to Microsoft Dynamics GP 2013 and taking advantage of the we...

It's that time of the year again! Time to say goodbye to the outgoing year, 2012, and receive the new one, 2013, making all sort of resolutions that we never seem to be able to achieve and with good measure, since most of us are simply consumed with the daily grind that lifting our heads up to take a breather and see the forest from the trees seems difficult and sometimes downright impossible. 2012 however was a very good year and gave me tons of stuff to write about. In retrospect, 3 conferences, 2 virtual conferences, the release of Microsoft Dynamics GP 2013 and the Web Client are simply a subset of the activities that allowed me to write some really cool stuff that you expressed through your comments to enjoy. Without further due, here is a list of the "best articles of 2012" written on this site (in no particular order): 1. Microsoft Dynamics Convergence 2012 Houston . Convergence Houston in March of 2012 was a very cool experience and probably one that I will ne...

I wrote an article almost a year ago showing a simple technique to add a  Terms and Conditions page to a Microsoft Dynamics GP Word Template document. You can read more about this here: How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document Just recently, I received a comment on the article, where the poster was asking how to use the same techniques outlined to add a Cover Page to an invoice document, so I figure, after playing with the idea for a bit, that I would post the steps to accomplish this too. All steps - up to step 3 - are the same, except, you probably would want to give this template an appropriate name. I will continue with step 4 as it applies to this article. 4. Position your cursor immediately above the company address information and add 2 single line tables. Add one table first, then create additional separation with the company information by pressing enter on your keyboard a couple times. Mo...

Couple days aback, I went through an issue were Microsoft Word templates were being rendered to an html file, causing Internet Explorer to launch instead - see  Word Templates rendering report in Internet Explorer . In troubleshooting this problem, I engaged my good friend Rob Wagner over at Microsoft, who showed me a few more tricks for troubleshooting issues around Word Templates and template rendering. Also, some time ago I covered a troubleshooting tip in my article Debugging Microsoft Dynamics GP 2010 Word Templates . Back then I looked at the TPELogging Dex.ini key, which creates a log file in the temp folder (%temp%) where templates are rendered and loaded by Microsoft Word. TPELogging is used to establish where possible exceptions could have occur while rendering the actual template into a Word document. While working with Rob, I learned about another Dex.ini key that can assist with the troubleshooting process: KeepTemplateTempFiles=TRUE This...

I have been working on a Word Templates case for the past 2 weeks and just got to the bottom of the problem, hence I felt the need to pause and blog about it. Background A client of mine reported a couple weeks aback that they had created a template version of their purchase order and each time the purchasing staff attempted to print a purchase order, the output would automatically generate in Internet Explorer instead of Microsoft Word. As the title of this article suggests, the client is using Word Templates to generate a nice looking PO for their vendors. HTML POP Purchase Order Blank Form However, and to make matters more interesting, when they printed a standard sales invoice, SOP Blank Invoice Form, these would generate just fine in Microsoft Word. Troubleshooting In troubleshooting this process, we went through all the formal setup and steps to create a template in Microsoft Dynamics GP, with the added benefit that the client's purchas...

Just recently, I ran into a situation with the Microsoft Dynamics GP Add-In for Microsoft Word where, after following all the installation steps and on-screen prompts, I could not get the Microsoft Dynamics GP Templates section to show up under the Developer's ribbon in Microsoft Word 2010. Microsoft Dynamics GP Add-In for Microsoft Word properly registered in Microsoft Word Microsoft Dynamics GP Add-In for Microsoft Word not registered in Microsoft Word The customer was also running a 32-bit version of Microsoft Office, clearly indicating that the issue was not related to the version of the Office product being ran - Word Templates are still not fully compatible with 64-bit Office platforms. A first troubleshooting step under these circumstances is to make sure that the Microsoft Dynamics GP Add-In for Microsoft Word is enabled under the COM Add-Ins window in Microsoft Word. You can access the COM Add-Ins window by clicking on the button of the same n...

Codename GP "12" Preliminary Features - Part 1  This is article is part 1 of 4 from the series Codename GP "12" Preliminary Features . Some images and content reproduced with express permission from Microsoft Business Solutions, a division of Microsoft Corporation. DISCLAIMER: These features are subject to change. I am only repeating what I have heard so please don't shoot the messenger. With GP "12" to be released "sometimes next year" - and yes, December 31, 2012 is still within that time frame - there may still be features on the following list that may not make the cut. However, it was fairly clear that the boys and girls on the Microsoft Dynamics GP development team in Fargo are working their rears off to get the feature list to a state where they feel pretty comfortable, meeting the demands on the shopping list. Straight out of GPUG Summit's closing session, comes some of the top features being worked on, based on the tra...

If you have been keeping up with this blog, you will remember that sometimes around October of 2010 I posted a series of articles related to Microsoft Dynamics GP Word Templates - see Microsoft Dynamics GP 2010 Word Templates summary for more information. These articles focused on "how to's" and troubleshooting aspects of Word Templates. Now the Dynamics Support and Services Team Blog has decided to launch a new set of video-articles detailing more common aspects of working with Word Templates. You can now visit the Community Team blog for the release article  and the schedule of when these videos will be out. The good news is the first two are out! Take a look at: Adding the Developer tab in Microsoft Word after installing the Microsoft Dynamics GP Add-in for Microsoft Word - Video Helpful tips when modifying Word Templates in Microsoft Dynamics GP 2010 - Video Please visit the Dynamics GP Support and Services Blog  for these videos and to find a collec...

If you are now a user of Microsoft Dynamics GP 2010, you will concur that the new Word Templates feature is probably one of the most visible improvements over version 10.0 as it has made the delivery of 'facing' documents a pleasant one. However, the new feature has not come without misunderstandings on how it works. One such misunderstandings has to do with the way template documents are opened, changed, and saved. Many users have found out the hard way that there's a bit more to just hitting the save button in Microsoft Word. So, let's review the few critical steps of opening a Word Template and ensuring that all changes are properly saved in Microsoft Dynamics GP, in the process, I will explain what happens "under the hood". 1. In the following example, I have taken a new template created for Aaron Fitz Electrical (AARONFIT0001) based on the original SOP Blank Invoice Form and have opened it and added a logo to it. SOP Blank Invoice Form Template -...

Ok, this is directly or indirectly a Report Writer subject, but nonetheless a topic related to Report Writer. In this example, I take the General Posting Journal transaction document and enable it under Word Templates. However, this example will not develop the Word Template itself, but rather show how easy it is to make the journal document template enabled. The steps are very simple and in fact, with a little bit of creativity, a developer could potentially write code that quickly enables critical reports. To enable an existing Microsoft Dynamics GP report: 1. Register a trigger against the IsTemplateEnabledReport() function of the syReportLookup form. Template enabled reports can be selected in the Reports lookup window. Startup { Created by Mariano Gomez, MVP This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.5 Generic license. } local integer l_result; pragma (disable warning LiteralStringUsed); l_result = Trigger_RegisterFun...