Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Microsoft Dynamics GP 2010 added some very cool functionality to the product which allows reports to be generated in Microsoft Word. It is perfect for creating custom layouts with logos and graphics for Sale Order Processing (SOP) and Purchase Order Processing (POP) documents.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was recently asked about a forum post of mine from a few years ago. It was about how to call a Dexterity report from Visual Basic for Applications (VBA). I checked the blog and could not find a post that showed the code in its simplest form. So here one is…
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Recently on the newsgroups, I responded to two separate questions on the same day asking about handling A4 size paper with Microsoft Dynamics GP. So I thought a post about the A4 chunk would be helpful.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I have seen this issue come up a number of times. Trying to automate processes which involve reports and wanting to automate the Report Destination window. Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA. This post will explain the reason for this “weird” behavior.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I was recently asked how can you total a field in a report when that field is in a conditionally suppressed section. You might ask why should this be difficult. The reason for the complexity is this….
Suppressing a section just stops it being displayed at the last moment and does not exclude the section from other processing by the report writer.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When working with the Report Writer to print a report onto a preprinted form it is important to ensure that the report prints to the same position regardless of the printer or printer driver used. This article explains the option that allows a report to always print in the same physical position. This can also be handy for plain paper reports; for example: An invoice that had an address which needs to show through a “windowed” envelope.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
In the previous article in this series, Microsoft Dynamics GP and Illegal Characters Part 1, we discussed how string delimiter or terminator characters can cause issues and need to be handled correctly. The article discussed the single quote (‘) and double quote (“) characters. Sometimes we have seen a single quote (‘) character cause problems at the SQL level when it is included in a data field and not handled correctly by the code.
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.