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…

6

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

1

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…

0

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…

1

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…


Adding more comments to SOP Documents

In keeping with my recent theme of Microsoft Dynamics GP Report Writer related articles, I thought I would post an example of how to get more comment lines showing a SOP Document.  This is a follow on from the Working with Text fields in Report Writer post. There was a Knowledge Base (KB) article on…

15

Working with Text fields in Report Writer

This post will explain what is and is not possible when working with fields of text datatype in the Microsoft Dynamics GP Report Writer. The text field datatype in Dexterity allows multi-line text to be entered up to a maximum length of 32,000 characters.  A shorter keyable length maybe defined when the field is defined…

2

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…

6

Currency values returned by VBA to a report are multiplied by 10 or 100 with Multicurrency

Last week, I discussed an issue where Currency values returned by VBA to a report are multiplied by 10 or 100. To workaround the issue we used string calculated fields rather than currency calculated fields on the report and formatted our values with the FormatCurrency() or FormatNumber() functions (depending on if we wanted the currency…

2

Using RW_Token to parse Runtime build numbers

The tip for today is how a Report Writer function added into the core dictionary can be used to parse runtime version and build numbers. You probably saw that an issue was found with the Support Debugging Tool build 12 for Microsoft Dynamics GP 2010 beta where it decided that the released version of Microsoft Dynamics GP…

2

Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse

With the release of Microsoft Dynamics GP 2010 (formerly known as GP “11”), the issue with the RW_ConvertToWordsAndNumbers() report writer function caused by the 80 character limitation on string calculated fields has been resolved with the addition of a RW_ConvertToWordsAndNumbersParse() report writer function which has the RW_ParseString functionality built in. For more information on the…

6

RW - Getting RW_ConvertToWordsAndNumbers() to show cents in words

A little while ago I wrote an article about how to get the RW_ConvertToWordsAndNumbers() report writer user defined function to work correctly for both originating and functional currency views. Today, a comment was added to that article asking about how to get the RW_ConvertToWordsAndNumbers() function to return the cents in words rather than numbers. Usually the…

5

Using the Support Debugging Tool to assist with Report issues

A new feature to the Support Debugging Tool for Microsoft Dynamics GP build 11 is the support for the rw_ReportStart, rw_ReportEnd, rw_TableHeaderString, rw_TableHeaderCurrency, rw_TableLineString, and rw_TableLineCurrency report writer user defined functions. The Knowledge Base (KB) article below explains how a third party developer can add triggers to the place holder RW functions in the core Dynamics.dic.  Then…

0

RW - Showing the Full Item Description on Invoices Example

When the inventory module of Microsoft Dynamics GP was first written the Item Description field was 60 characters long.  A few versions ago it was extended to 100 characters.  While this allows for a longer description to be entered, it has created three issues: Some reports do not have the width available for a 100…

9

RW - Getting RW_ConvertToWordsAndNumbers() to work with multi-currency

I recently had a support case where the partner consultant was trying to use the RW_ConvertToWordsAndNumbers() report writer user defined function to display the Purchase Order total in words at the bottom of the document. They were using the POP Purchase Order Other Form (but this method works for the POP Purchase Order Blank Form…

5

Hybrid - Cheque Amount in Words Example

One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words.  After the code was added, it was realised that Report Writer calculated fields of return type string are limited to 80 characters.  This means that if your amount in words…

15

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…

28

Report Writer Articles & Links

This is a page to provide links to Report Writer related articles and materials. Troubleshooting Knowledge Base (KB) Articles How to use and troubleshoot Report Writer in Microsoft Dynamics GP (KB 861803)  How to re-create the Reports.dic file in Microsoft Dynamics GP (KB 850465)    Report Writer Functions Knowledge Base (KB) Articles  How to access…