Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did not actually exist in the Data folder.

So, I thought it would be a good excuse to answer the questions raised as a blog post.

Continue reading

Displaying Dates in any format on Reports

David Meego - Click for blog homepageThis 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).

Continue reading

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

David Meego - Click for blog homepageThis 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).

Continue reading

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

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I wanted to highlight an issue that you might see when working with Visual Basic for Applications (VBA) and Report Writer.

The issue occurs when using VBA code to return a currency value to be displayed on the report and it appears to be randomly multiplied by 10 or 100.  This is a known issue (Problem Report 59380) and this post should help explain what the problem is and provide an alternative solution.

Continue reading

Errors when importing Customization Maintenance Packages

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).  The partner was unable to find an explanation of the errors on the Internet and so I thought I would explain what the errors mean and provide some best practices to avoid these issues in the future.
Continue reading

Modifying Microsoft Dynamics GP 2010 Word Templates

David Meego - Click for blog homepageThis 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.

Continue reading

Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse

David Meego - Click for blog homepageThis 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.

Continue reading

VBA – Calling a Report using Visual Basic for Applications

David Meego - Click for blog homepageThis 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…

Continue reading

Automating or Customizing the Report Destination Window

David Meego - Click for blog homepageThis 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.

Continue reading

Totalling a field in a Conditionally Suppressed Section on a Report

David Meego - Click for blog homepageThis 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.

Continue reading

What does the Preprinted Form option on the Report Definition window do?

David Meego - Click for blog homepageThis 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.

Continue reading

RW – Getting RW_ConvertToWordsAndNumbers() to show cents in words

David Meego - Click for blog homepageThis 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.

Continue reading

Microsoft Dynamics GP and Illegal Characters Part 2

David Meego - Click for blog homepageThis 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.

Continue reading

Using the Support Debugging Tool to assist with Report issues

David Meego - Click for blog homepageThis 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.

Continue reading

Controlling the size of the Body section on Reports

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The question of how to control the size of the body section of a document such as Sales Order Processing (SOP) Orders and Invoices or Purchase Order Processing (POP) Purchase Orders has come up a number of times before.  It was asked again on a Community Forum post a while back. So I thought I would post the answer here.

Continue reading

RW – Making a One-to-Many Table Relationship behave as One-to-One

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of biggest issues people have with the Microsoft Dynamics GP Report Writer is not being able to create the desired table relationships from tables on the report to other tables so that the other tables can be added to the report and behave correctly.

Continue reading

RW – Can I print Page Numbers including the Total Number of Pages?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

The question in more detail is whether it is possible to print “Page: Y/X” or “Page: Y of X” on a Report Writer report, where Y is the current page number and X is the total number of pages for the report.

Continue reading