Update: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions – RW_CoAddrIDInfo broken

Following on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake. The Problem The update to the RW_CoAddrIDInfo() report writer function has broken the code. It works when no Address ID is supplied to return the information from the default Address information…


Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions

You might remember the story about how I created a suite of Report Writer functions and got them added to the version 7.0 Dynamics.dic core dictionary. The aim for these functions was to make it easier for partner consultants and customers to modify the reports without needing custom scripting in Visual Basic for Applications (VBA) or Dexterity….


Dynamics GP Crashes After Installing Addin

One thing we’ve noticed recently is an uptick of cases involving Visual Studio Tools assemblies causing Dynamics GP to crash after being installed. While I don’t think this has anything to do with GP 2013, it does seem to happen on that version.  Perhaps everyone is just going to the new version and thus coincidental….


More Microsoft Dynamics GP 10.0 Service Pack 5 releases

Last month, we released Microsoft Dynamics GP 10.0 Service Pack 5. Since then many other components of the Microsoft Dynamics GP suite have had Service Pack 5 releases. This includes the Dexterity Development Environment build 10.00.0331. Check out the links below:   PartnerSource Feature Pack 1 DVD with SP5: Product Release Downloads for Microsoft Dynamics GP…


Displaying Dates in any format on Reports

Over the years, I have seen a huge amount of effort and multiple calculated fields to format a date field on a report into a desired format that is something other than the default short date format, usually DD/MM/YYYY or MM/DD/YYYY depending on country (as defined in the control panel). While you have to admire the efforts that…


Microsoft Dynamics GP 2010 Software Development Kits Released

The Software Development Kits for the various parts of the Microsoft Dynamics GP 2010 application have been released to CustomerSource and PartnerSource.  The links are below:    Microsoft Dynamics GP 2010 Application Software Development Kits Software Development Kit (SDK) for Microsoft Dynamics GP 2010 (CustomerSource) Software Development Kit (SDK) for Microsoft Dynamics GP 2010 (PartnerSource)   Software Development Kit (SDK) for Business…


How can I identify the parameters of a Procedure or Function?

One of the great things about Dexterity is that you can develop complex customisations without needing access to the source code.  Even if you have access to source code via the Source Code program, a Dexterity developer never actually changes original source code. By using triggers before and/or after the original code, it is possible…


How can I get access to PartnerSource & CustomerSource

You have probably noticed the padlock icon  next to many of the links on this blog. This icon signifies links which require access to PartnerSource or CustomerSource. You will find that many Knowledge Base articles, Tools, Software Development Kits (SDK), Product Releases and Service Packs are all protected in these secure areas. To get access to…


Finding Table and Field Information in Microsoft Dynamics GP

This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website.  The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post. The idea was to provide as many tools and techniques as possible to help people…


Using the built-in Report Writer Functions

During my time in the partner channel, I worked with a number of consultants who had a number of problems customising reports with Report Writer. One of the problems was an inability to access desired data because a valid table relationship could not be established. This could be due to the source table not containing all the…


Developer & Consultant Articles & Links

This page contains links to developer and consultant related articles and sites (not specific to a particular tool):   Developer Knowledge Base (KB) Articles Finding Table and Field Information in Microsoft Dynamics GP How to obtain the table and field information for windows in Microsoft Dynamics GP (KB 894335) How to create a Dexsql.log file…


Developer Toolkit Articles & Links

This is a page to provide links to Developer Toolkit and Integration Manager related articles and materials. The Developer Toolkit contains: Visual Studio Tools for Microsoft Dynamics GP eConnect Web Services Using Visual Basic and Visual C# for its languages.   Knowledge Base (KB) Articles  How to upgrade applications to use the GPConn.dll file or…