Posts

Showing posts from January, 2012

Word Templates rendering report in Internet Explorer

Image
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 purchase order form was not a m

Management Reporter 2012

Image
Management Reporter 2012 Release Themes Most of you know me to be a fairly technical guy, so it must be quite an event when I get excited about a financial reporting product. My excitement stems from a couple of things I saw in an MVP Product Group Interaction session yesterday with the Dynamics Corporate Performance Management team: Management Reporter 2012 is simply THE BEST darn financial reporting product produced to date by Microsoft. This release revolves around 4 core themes: Interactive Report Viewing, Deeper Dynamics ERP Integration, Report Collaboration, and Design Flexibility. I highlighted a few of the capabilities in my March 8, 2011 Corporate Performance Management Roadmap  article. Among the things I can say for now, and from a technical perspective, this release removes its dependency on Internet Information Services (IIS), allowing it to run in native mode. If you are familiar with SQL Server 2008 Reporting Services, you can now begin to imagine how this will

New Article on MSDynamicsWorld: Where Do the Microsoft Dynamics GP Experts Turn for Answers?

Image
My new article is out over at MSDynamicsWorld ! It's been a long time coming, but finally, and per the insistence of Jason Gumpert , I was able to get to it - Jason has his ways for sure :-) This time around my article, Where Do the Microsoft Dynamics GP Experts Turn for Answers? A Preamble to GPUG DayONE , looks the Microsoft Dynamics GP application's dependency on the overall Microsoft technology stack and guides you on how you can find answers to the growing number of questions arising from this interdependence. In truth, the article serves as an invitation to come see David Musgrave and I talking about this subject at the next GPUG DayONE opening event for Microsoft Dynamics Convergence 2012 in Houston, TX - see Microsoft Dynamics Convergence 2012 sessions now published . As the saying goes: be there or be square! Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Microsoft Dynamics Convergence 2012 sessions now published

Image
Ok, they have been published for a few days now. However, I wanted to bring your attention to the sessions that David Musgrave and I will be presenting. This time we will present a GPUG DayONE breakout session, UBGP18 - Where do the Experts Turn for Answers , running Sunday, March 18, 2012 from 1:30 PM - 3:00 PM. We will also have the distinct opportunity to present 2 Support Debugging Tool sessions - twice! That's it, you will have the opportunity to see each of our sessions in a repeat in case you get to miss any the first time around. I still don't have the details on the exact dates and times our sessions will be running yet, but will publish as soon as they become available. For now, here's what we have: CSGP19 CSGP23 I am really excited about our new sessions showing some really cool advanced Support Debugging Tool sessions. This is an advanced level session, with lots of cool stuff from the new Build 16 . You won't be disappointed! Until next post!

1099 reports: the devil is in the details

Image
It's certainly that time of the year and if you haven't sent out those 1099's you are running out of time. I was working on a case recently at one of my clients who was having all sort of issues printing 1099 reports. Apparently, reconciling their calendar year wasn't helping the issue either. It did not really matter what they tried - short of manually adjusting the 1099 amounts for each vendor - nothing seemed to make the correct numbers print on the report. We reviewed all 10,000 vendor cards to make sure they had the proper 1099 type and box number selected - we caught a few mishaps here too. After inspecting a few of the problem reports (and vendors), we narrowed down the issue to a number of payable invoices not having the proper 1099 amount and box type associated to the transactions. So to fix this issue, I wrote a few scripts which I hope you find useful. Fix1099.sql -- Created by Mariano Gomez, MVP -- This code is licensed under the Creative Commons --

The Support Debugging Tool on Twitter!

Image
As you know by now - hopefully you do - Build 16 of the Support Debugging Tool (SDT) has been officially released - see Support Debugging Tool Build 16 released  over at Developing for Dynamics GP for release notes and new features. However, you may have noticed I have not posted anything about it (don't worry, I am still friends with Musgrave). The reason for the absence of posts on the new SDT build obays to a few reasons: 1. I am going to release a series of video blogs showing the new features on The Dynamics GP Blogster YouTube channel , and as you can imagine, these things take time. 2. I have been thinking of some creative ways to continue to push the SDT to the Microsoft Dynamics GP community as a whole, not just Build 16. As it relates to the second reason/excuse/goal, and given the adoption of social media throughout the Microsoft Dynamics GP community - check out  Social Media for Microsoft Dynamics Partners eBook by MVP Mark Polino and Jon Rivers (twitter: @

Management Reporter: Server Error in Application "MANAGEMENT REPORTER"

Image
Just recently, I fielded a question on an issue that was happening with a Management Reporter installation. The partner reported getting the following error (shown in the picture) when attempting to open the Management Reporter URL address: Server Error in Application "MANAGEMENT REPORTER" . The error also indicated an HTTP Error 403.14 - Forbidden. The Web server is configured to not list the contents of this directory . Typically, when you attempt to navigate to the server URL hosting Management Reporter, at the default port 4712, you can expect to receive a blank page. A blank page simply means that all Management Reporter application services are running just fine. Scrolling through the error page, the following additional information reveals that a default document is not configured for the requested URL, and directory browsing is not enabled on the server. In doing some research, I came across Microsoft Support KB article 942062  which explains the issue being r

Another reason to attend Microsoft Dynamics Convergence 2012... Daughtry!

Image
If you are a fan of good rock music, then here's another reason for you to attend Microsoft Dynamics Convergence 2012 in Houston, Texas... Daughtry will be live at the Convergence Reception . Daughtry - from left to right: Joey Barnes (Drums), Josh Steely (Guitar), Chris Daughtry, Josh Paul (Bass), and Brian Craddock (Guitar) Daughtry is an American rock band formed and fronted by American Idol Season 5 finalist Chris Daughtry in 2006. Their self-titled debut album was released in 2006. The disc reached number one for two non-consecutive weeks on the Billboard Top 200, sold more than four million copies and was named the number one selling album of 2007 by Billboard. Their album is also the fastest-selling debut rock album in Soundscan history. The first single from the album, " It's Not Over ", was the eighth most played song across all formats on U.S. radio in 2007, and their second single from the album, " Home ", was the tenth most played

Microsoft Dynamics GP Technical Conference 2012 dates announced!

Image
It's official! The Microsoft Dynamics GP Technical Conference 2012 will be held in Fargo, ND from September 12 -14 . As you know,  I have been a speaker and presenter at the previous Tech 2011 and Tech 2009  and, while not official yet, I will be looking to present at the this year's Technical Conference as well. The announcement came earlier today via Pam Misialek over at the Inside Microsoft Dynamics GP blog . Disclaimer : The banner above is not an official Microsoft Tech Conference 2012 banner and was rendered based on the current Fargo Developer Conference site banner Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Microsoft Dynamics GP Add-In for Microsoft Word not enabling despite several attempts to install

Image
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 name on the Deve

Management Reporter - The operation could not be completed due to failure on the server

Image
What would be the New Year without a little drama? I don't often write about Management Reporter, however, we just went live at a client site this past Tuesday, with everything working just as expected - by us and the client. However, just a few days working with their new environment, the client decided to run some of the financial reports we'd created with Management Reporter. Upon attempting to generate the report, the client received the following error: Attempting to outrule any permissions issue, I ran the report with the SQL Server system admin (sa) account and got the same error. Since the error was not descriptive enough, I turned to the Windows Applications Event Viewer and immediately spotted 3 entries. The first entry clearly stated the problem: "Length of LOB data (678233) to be replicated exceeds configured maximum 65536. The statement has been terminated" Because the exception was generated by a SQL client component, I could definitely rule

Why you need to attend Microsoft Dynamics Convergence

Image
Microsoft Dynamics Convergence blog team member, Alexa Hoekstra invited me in past weeks to write an article on why you need to attend the event. The article is finally up on the Community website. I must say, I was very excited to write this piece as it includes pictures reflecting my experiences from past Convergence events, in hopes of providing some context to my article. Read the article here . Personally, I believe it turned out to be a good piece! NOTE: you know you have written a good article when fellow MVP Mark Polino decides to add his own spin to it - read Mark's stub here . Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Congratulations to Victoria Yudin!

Image
I didn't want to let the opportunity pass by to send shout outs to Victoria Yudin for achieving a record 8 consecutive years as a Microsoft Dynamics GP MVP. Please continue to support Victoria's work in the community by acquiring a copy of her Microsoft Dynamics GP 2010 Implementation book. A personal dream of mine is to see Victoria presenting at Convergence... maybe I should start a poll asking you, the reader, if you would like to see her present at this event. Until next post! MG.- Mariano Gomez, MVP IntellPartners, LLC http://www.IntellPartners.com/

Happy New Year!

Image
Happy New Year everyone! Back from much needed vacations, I had some time to reflect back on the body of work done in 2011 in the Microsoft Dynamics GP community. The truth is, it was very hectic, with the Tech Conference 2011 in Fargo , Convergence 2011 Atlanta , Decisions Spring and Fall editions, and the GPUG Summit in Las Vegas , not to mention 158 articles on this blog along with the comments I received (plus 365000 hits!), thousands of Partner Technical Forum posts, my new YouTube channel , and much, much more. As you can imagine, that kind of effort is represented and supported by hundreds and hundreds of hours, which are very hard to carve out with a full-time job and family activities. However, it makes it all the more rewarding. Starting anew in 2012 makes me think about how difficult it will be to surpass what I did last year, but as I always say, I love a challenge when I see one! I'm already booked for Convergence 2012 Houston, Decisions Spring 2012, GPUG Summi