Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (17 items)