Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This posting discusses how to use Customization Maintenance packages to enable Microsoft Dynamics GP core formats for use in the Report Writer with a 3rd party report dictionary.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When printing Text Reports for Microsoft Dynamics GP to a laser printer they are usually printed using the built in Courier printer font. The following article describes how the font typeface and size can be controlled by settings in the DEX.INI defaults file.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have not read part 1 of this posting it can be found using the link below:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A long time discussion in the Microsoft Dynamics GP world is how to handle the distribution of customizations and updates. There are a number of approaches available and this article discusses the benefits and issues of the different configurations.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following example shows how easy it is to use VBA to add a line number to a SOP Document.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I often get told that it is impossible to customize a report which uses a temporary table, and in particular a temporary table which uses single fields for multiple purposes. While I admit that these reports are more challenging to customize they are far from impossible.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following Report Writer and VBA example demonstrates how data from any SQL table can pulled into a report regardless of the product the table is related to. This technique can also be used when it is not possible to create the table relationship needed to add the report in the Report Writer. It works as long as you can create a query that will uniquely select the data you need based on the data on the report or from the already linked tables.