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: Microsoft Dynamics GP 2013, Printer Selection, Named Printers, Page Orientation and the System Print Dialog

    Microsoft Dynamics GP 2013 added a long awaited feature, the ability to change the printer selection for a report after it has printed to the screen output. However, this change has introduced some side effects. Microsoft is aware of the side effects and they should be resolved in an upcoming release...
  • 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: Copying Report Formats between Reports... and a warning about Word Templates

    There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen. The Situation The situation...
  • 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: Getting data from ISV tables onto reports without needing to create alternate reports

    As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP. It is quite common to store the additional data in a parallel table (sometimes...
  • Blog Post: How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool

    Here is another support case that was resolved simply and quickly using the Support Debugging Tool . The customer was using Extender to add an additional comment to the inventory stock transfer transaction. They created an Extender ID "ST_COMMENTS" and used the Long String field type in Extender which...
  • Blog Post: Quick Tip: Table Hierarchy Inconsistency Errors in Runtime Mode

    Following on from yesterday's post: Quick Tip: Creating Dexterity System Variables , I want to cover a related issue. This is when a Dexterity developer is creating a report (either new or alternate) which will display data from newly added tables. To get the data to show on the report the developer...
  • Blog Post: Keeping Word Templates in synch with Report Writer - Video

    Hi, I previously published an article on the blog on Keeping Word Templates in synch with Report Writer . Now I have created a video that demonstrates how to do this. You can also view the the video on YouTube published by msdyncomm . Dave 15-Feb-2013: Fixed broken Links to Video and...
  • Blog Post: Word Template Debugging - Video

    Hi, I previously published an article about Debugging Word Templates on this blog. Now I have created a video that demonstrates how to add the debugging and what you get for results. You can also view the the video on YouTube published by msdyncomm . Dave 05-Mar-2014: Fix Link to Video...
  • Blog Post: How to calculate Aging Buckets based on documents shown on a Receivables Statement

    I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by...
  • Blog Post: Troubleshooting Named Printers Issues

    I am working on a Named Printers issue at the moment and thought it would be a good opportunity to put some standard troubleshooting steps on the blog. Quick history: I originally developed Named Printers back on version 3.0 when I worked for the selling ISV partner, Sequel Technology, and later sold...
  • Blog Post: How to add Item Category Long Descriptions to reports using the Support Debugging Tool

    I am currently working on a support case where the customer is making use of the six user defined categories for items. That in itself is nothing remarkable or worth blogging about. However, they are using Long Description field on the Item Category Setup window and wished to include the data from this...
  • 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: Keeping Word Templates in synch with Report Writer

    If you are working with a specific report in report writer, and you are also using a word template to print the report, one thing that you have to keep in mind is that the report writer fields have to be in synch with the content controls on the word template. If they are not in synch what happens is...
  • Blog Post: Report Prints Incorrectly When Choosing the PDF File Format As The Report Destination

    I recently worked on a PDFWriter printing incident with a Customer and we ran into a format problem when choosing the PDF File format. The Problem Since performing an upgrade to Microsoft Dynamics GP 2010, the Customer was having an issue when printing a single page invoice, in this instance, the...
  • Blog Post: Word Templates will not print to screen

    A common scenario that has been happening more and more is that a customer is trying to print out a word template just to the screen and the template won't print. You will get a window called "Report Processing Status" and the report will be there and it will list a status of "In Progress" and it just...
  • Blog Post: Word Template Debugging

    Recently, I have been looking a lot of Word Template cases - I'm the primary Escalation Engineer on that feature. Since Word Templates are new to GP 2010, I want to get some blog articles written on some of the common issues we are running into. So this will probably be a series of Word Template posts...
  • Blog Post: Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement

    Hi everyone. I wanted to share with you a recent support incident that I worked on. The cause of the issue was one of those weird issues that took a while to track down. The Problem The problem is that the Current Trx Amount (CURTRXAM) field in the RM30702 reprint table is not populated when...
  • Blog Post: Working with Vertical Lines in Report Writer

    If you have ever used the SOP Blank Invoice Form or the POP Purchase Order Blank Form in Microsoft Dynamics GP, you will have seen the vertical lines on the report which make up the boxes around the various sections of the report. This article explains how those vertical lines work and how to easily...
  • 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: Word Templates, Office 2010 and the Maintain Compatibility option

    A while ago I posted an article on Modifying Microsoft Dynamics GP 2010 Word Templates which demonstrated the basic methods for customizing word templates for Microsoft Dynamics GP 2010. In that article, I mentioned that if you were using Word 2010 to edit the templates, you would have an option to...
  • Blog Post: Dynamics Report Writer is the Best Report Writer in the World cont.

    This is a follow up post to my earlier post , which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone. In fact, I would be fairly surprised if any report writer...
  • Blog Post: Using Barcodes from the Dynamics GP Report Writer

    A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out. We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us. I have been meaning to write a blog post on how to...
Page 1 of 3 (69 items) 123