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….


Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog

Microsoft Dynamics GP 2013 added a long awaited feature, the ability to change the printer selection for a report after it has printed to the screen output. However, this change has introduced some side effects. Microsoft is aware of the side effects and they should be resolved in an upcoming release. To explain the side…

Dynamics Confessor Report Writer Function Series

My great friend, Leslie Vail – The Dynamics Confessor, has released a great series of posts about the Report Writer functions available in Microsoft Dynamics GP. These Report Writer functions are Dexterity global functions which are exposed to the Report Writer so they can be included in calculated fields as user defined functions.  There are…


Copying Report Formats between Reports… and a warning about Word Templates

There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen.   The Situation The situation is very common…


The Dynamics GP Blogster works with Report Writer and the Support Debugging Tool

My great friend Mariano Gomez, The Dynamics GP Blogster, has been busy recently creating some fantastic step by step posts on customising reports using Report Writer. His first post shows a method to get the Customer Item User Defined fields showing on the SOP Invoice. Mariano discusses the more traditional methods of using Table Relationships…


Getting data from ISV tables onto reports without needing to create alternate reports

As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP. It is quite common to store the additional data in a parallel table (sometimes called companion or shadow table)….


How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool

Here is another support case that was resolved simply and quickly using the Support Debugging Tool. The customer was using Extender to add an additional comment to the inventory stock transfer transaction. They created an Extender ID “ST_COMMENTS” and used the Long String field type in Extender which is a 255 character string. This worked…


Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode

Following on from yesterday’s post: Quick Tip: Creating Dexterity System Variables, I want to cover a related issue. This is when a Dexterity developer is creating a report (either new or alternate) which will display data from newly added tables. To get the data to show on the report the developer creates a table relationship…


Keeping Word Templates in synch with Report Writer – Video

Hi,  I previously published an article on the blog on Keeping Word Templates in synch with Report Writer.  Now I have created a video that demonstrates how to do this. [View:https://www.youtube.com/watch?v=1N69GmhHIWc] You can also view the the video on YouTube published by msdyncomm. Dave  15-Feb-2013: Fixed broken Links to Video and YouTube Channel.


Word Template Debugging – Video

Hi, I previously published an article about Debugging Word Templates on this blog. Now I have created a video that demonstrates how to add the debugging and what you get for results. [View:https://www.youtube.com/watch?v=1N69GmhHIWc] You can also view the the video on YouTube published by msdyncomm. Dave 05-Mar-2014: Fix Link to Video because it was moved.


How to calculate Aging Buckets based on documents shown on a Receivables Statement

I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by a particular value on the Description…


Troubleshooting Named Printers Issues

I am working on a Named Printers issue at the moment and thought it would be a good opportunity to put some standard troubleshooting steps on the blog.  Quick history: I originally developed Named Printers back on version 3.0 when I worked for the selling ISV partner, Sequel Technology, and later sold the module to…


Accessing Internet Information from Report Writer

Last week, I had a call from a partner asking how could they access data stored on the Internet Information window. This is the window opened with the little italic i symbol next to the Address ID field for Company, Customer, Employee and Vendor Addresses as well as next to Employee ID and Salesperson ID fields. The…

Keeping Word Templates in synch with Report Writer

If you are working with a specific report in report writer, and you are also using a word template to print the report, one thing that you have to keep in mind is that the report writer fields have to be in synch with the content controls on the word template.  If they are not…


Word Templates will not print to screen

A common scenario that has been happening more and more is that a customer is trying to print out a word template just to the screen and the template won’t print.  You will get a window called “Report Processing Status” and the report will be there and it will list a status of “In Progress” and…


Word Template Debugging

Recently, I have been looking a lot of Word Template cases – I’m the primary Escalation Engineer on that feature.  Since Word Templates are new to GP 2010, I want to get some blog articles written on some of the common issues we are running into.  So this will probably be a series of Word Template…