The Dynamics GP Blogster

My new opinion column, IMHO with The Dynamics GP Blogster , has a new article: Why you should care about Microsoft Dexterity . In this article I take a historical perspective on software vendors and their tools environment and provide some arguments to customers and developers alike for keeping up the love for Dex. Hope you find this article interesting. Don't forget to leave your comments either way. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

If you use the map buttons in Microsoft Dynamics GP 2010, you may have noted that clicking on a map button next to an address Id opens up Bing Maps at the country view level.  Microsoft Dynamics GP 2010 and Bing Maps country view  This has been identified as a bug with Microsoft Dynamics GP 2010 -- RTM and Service Pack 1 are affected. The bug is currently written up and hopefully in the queue for a fix. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

This article is part 2 of 2. In my previous article  on the same subject, I told you about the adventures of my friend, MVP Mark Polino and his attempt to get a better description to the error " General Error " when running a Drill-Down Builder in Excel and Outlook. Once followed the instructions outlined in the previous post, Mark was able to obtain what seems to be a less cryptic error message, as follows: A general error has occured.A call to SSPI failed, see inner exception. Server stack trace: at System.ServiceModel.Channels.WindowsStreamSecurityUpgradeProvider.WindowsStreamSecurityUpgradeInitiator.OnInitiateUpgrade(Stream stream, SecurityMessageProperty& remoteSecurity) at System.ServiceModel.Channels.StreamSecurityUpgradeInitiatorBase.InitiateUpgrade(Stream stream) at System.ServiceModel.Channels.ConnectionUpgradeHelper.InitiateUpgrade(StreamUpgradeInitiator upgradeInitiator, IConnection& connection, ClientFramingDecoder decoder, IDefaultCommun...

This article is part 1 of 2. My good friend, MVP Mark Polino  was recently working on a set of drill-downs to customer information in Microsoft Dynamics GP. The links worked perfectly from Microsoft Office Outlook and Microsoft Office Excel...until they stopped working suddenly, with the cryptic error " General Error ". That's it! No other reference of any kind, no where to go from here. Fortunately for him, there are some tricks of the trade -- tricks of the trade because these can only be found in the notes of some developer -- to produce a "better" error, and here are the steps: 1. Go to Program Files\Common Files\Microsoft Shared\Dexterity - If it is a 64-bit environment, you will need to go to Program Files (x86). 2. Rename the Microsoft.Dynamics.GP.ProtocolHandler.exe.config file that is there. 3. Launch Microsoft Dynamics GP and your Excel report. 4. Try the Drill-Down again. It will most likely still error, just more descriptive. As it tur...

Tim Gordon at Alpine Limited , continues to work very hard on DexSense, the first IntelliSense solution for Dexterity. Tim has just recently released DexSense 1.8 which now includes some astounishing performance enhancements. You can find more information on the most recent version of DexSense by reading the release post: DexSense 1.8 released To get a full copy of DexSense, proceed to the product download page over at Alpine Limited : DexSense Product Page You can follow the evolution of IntelliSense for Dexterity by reading the following articles on both the Developing for Dynamics GP page and here at The Dynamics GP Blogster : Dexterity and IntelliSense Dexterity and IntelliSense - It's time to vote! IntelliSense for Dexterity - Ask and You Shall Receive @ Developing for Dynamics GP Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

I have been fortunate enough to be invited as a guest columnist on the new Microsoft Dynamics Community 2.0 site, also taking center spot on the Microsoft Dynamics GP home page. You will now be able to enjoy the new "In My Humble Opinion with The Dynamics GP Blogster Column", simply IMHO. My new column will be focused on telling it as it is -- or as I see it. Uncensored!  Microsoft Dynamics GP Home Page - IMHO  Hopefully, you will enjoy the very nature of this new column and if you have any complaints or you feel there's anything I should be covering, I welcome the comments. After all, I want to be your voice for the things that are and are not right with either the product, or the channel. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

A few months aback I blogged about some of the changes that the Microsoft Dynamics Community was undergoing -- see Why the Phaseout of the Microsoft Dynamics Public Newsgroups Is a Good Thing . Now, the new Community site is live and the overhaul could not be any more apparent. Take some time to review the release notes in the article Welcome to Microsoft Dynamics Community 2.0 . Some of the new capabilities of Community 2.0 are: increased social networking capabilities with the ability to create and share profiles, Ask the Community , which is formerly known as the Community forum, but this version is on steroids as it allows for role-base searches and role-base content. I really would like to take this opportunity to congratulate the Community team. It's been over a year of long hours and incredible effort to make this happen, but more importantly, thanks for listening. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusin...

The Dynamics GP Blogster will be visiting Oviedo and Madrid, Spain from the 8th to the 16th (in Madrid only on the 16th) of October on a business assignment, but for those of you who would like to exchange business cards and ideas please don't hesitate to reach me at the AC Forum Hotel in Oviedo. I will be available in the afternoons after 5:30 PM and as time permits. For those of you who decide to tag along for dinner or otherwise, table topics are fairly open or if you are a prospective customers considering Dynamics GP and would like some insight, please feel free to drop by. Please email me in advance using the link on the right so I can keep a headcount. Until next post! MG.- Mariano Gomez, MVP Maximum Global Business, LLC http://www.maximumglobalbusiness.com/

I have been asked to share with you an upcoming public chat involving some of our Microsoft Office and Windows MVPs. MVPs have volunteered to answer Windows and Office questions directly from the public in a live chat! Can you help spread the word about this public chat? Thanks in advance for your assistance and feel free to join us for the chat next week. Chat About Microsoft Office and Windows with Microsoft MVP Experts October 14, 2010 10:00 A.M. - 11:00 A.M. Pacific Time Additional Time Zones Would you like to learn more about the cool new features in Microsoft Office 2010 and Microsoft Windows 7 and what has changed since previous versions? Do you use Microsoft Office but would like to learn tips and tricks to be more productive at home, school or at work? Perhaps you are a new user who has questions on how to get started with Windows 7 or using the Office ribbon? Or would like to learn how to protect your computer from malware and viruses. Or perhaps you are just stuck...

While attempting to generate a VAT Return report for his customer, a partner ran into the following issue. Hi folks , weird one here. Have ran fine in the past,however we are now getting this error: 'The input tax for ths range hasn't been entered. Do you want to continue calculating? The only change is that we have now set up all the reverse charge functionality for EU VAT. So the question is, where is the VAT return looking for the input tax? Fortunately, the partner dog enough into this issue and found a solution which he did not mind sharing with the rest of the partner community. Ok fixed it! Extracted all the transactions in SmartLists for the tax reporting period, and pivot tabled them on the tax detail id, compared the id's to those setup in GP only to discover that a tax detail id used 6 times does not physicly exist, [I then] changed the tax detail id in SQL to rectify to the correct id. ID must have been deleted some how. So if you experience the same pro...

Microsoft Dynamics GP 2010 Word Templates offer new presentation capabilities to the traditional customer/vendor facing Report Writer reports. This week was just a superficial scratch of the myriads of things that are possible to achieve. Like with everything else, I am sure there are limitations, but it will take some time to discover what those are. Nonetheless, I will continue exploring this topic and bring to you my findings Articles Covered How to add a "Terms and Conditions" page to a Microsoft Dynamics GP Word Template document Debugging Microsoft Dynamics GP 2010 Word Templates How to resize logo in Microsoft Dynamics GP Word Templates The Open XML SDK 2.0 for Microsoft Office Acknowledgements I have to thank Microsoft's Rob Wagner for his invaluable support and guidance throughout the week. Rob also provided the cool code and pointed to the online resources available on the Open XML subject. Until next post! MG.- Mariano Gomez, MVP Maximum Globa...

Along with the introduction of Microsoft Dynamics GP 2010 Word Templates came a little known software development kit: Open XML SDK 2.0. Open XML is an open ECMA 376 standard and is also approved as the ISO/IEC 29500 standard that defines a set of XML schemas for representing spreadsheets, charts, presentations, and word processing documents. Microsoft Office 2007 and Microsoft Office 2010 all use Open XML as the default file format for rendering spreadsheets, documents, and presentations. The Open XML file formats are useful for developers because they use an open standard and are based on well-known technologies: ZIP and XML. The Open XML SDK 2.0 for Microsoft Office is built on top of the System.IO.Packaging API and provides strongly typed part classes to manipulate Open XML documents. The SDK also uses the .NET Framework Language-Integrated Query (LINQ) technology to provide strongly typed object access to the XML content inside the parts of Open XML documents. In ...

It's with great pleasure that I introduce you to  MVP Sivakumar Venkataraman , known by many of you simply as Siva. Siva joins the Microsoft Dynamics GP MVPs roaster as part of the MVP Award Program's October cycle. Siva is the author of the Interting Findings & Knowledge Sharing  blog and also a tireless moderator of the Dynamics GP Google Group , one of the longest running, independent groups dedicated to all things Microsoft Dynamics GP. Siva is currently a Practice Lead - Microsoft Dynamics at Interdyn AKA . The Microsoft Most Valuable Professional (MVP) Award is an annual award given to outstanding members of Microsoft's technical communities based on contributions made during the previous 12 months to offline and online Microsoft-related technical communities. The Microsoft MVP Award recognizes exceptional technical community leaders worldwide who actively share their knowledge with other technical community members. Of 100 million technical community partic...