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

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Following on from my post: Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions, I have to admit that I made a mistake.

Microsoft Dynamics GP 2013 R2 updates to Report Writer Functions

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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. They are documented in the Report Writer Functions document in the Software Developers Kit (SDK).

Dynamics Confessor Report Writer Function Series

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

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

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Accessing Internet Information from Report Writer

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Adding more comments to SOP Documents

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Working with Text fields in Report Writer

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 in Dexterity.

Displaying Dates in any format on Reports

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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

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

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 symbol or not).

Using RW_Token to parse Runtime build numbers

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

RW – Getting RW_ConvertToWordsAndNumbers() to show cents in words

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 function will convert the dollar amount into words but the cent amount is shown as numbers.

Using the Support Debugging Tool to assist with Report issues

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

RW – Showing the Full Item Description on Invoices Example

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

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

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Hybrid – Cheque Amount in Words Example

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 is longer than 80 characters, only the first 80 characters will be returned and the rest will be truncated and lost.

Using the built-in Report Writer Functions

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.