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: More on SQL Server Connection issues with Microsoft Dynamics GP

    I have been working on a recent support case that had a situation that makes me want to raise this topic again. In the past, I have posted a number of articles discussing reasons for connections to SQL Server to be lost. When Microsoft Dynamics GP loses its connection to SQL Server, the Dexterity...
  • Blog Post: Failed eConnect document leaves orphaned records

    I assisted on an eConnect incident today that was quite interesting and I thought I'd share the case and the solution. The issue: The ISV was integrating a Payables Invoice using eConnect 10.0. The XML document had 2 distributions and the invoice data. What the ISV found was that there was...
  • 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: Dynamics Report Writer is the Best Report Writer in the World

    Alright, maybe I am stretching the truth a little, but I do get frustrated when people discount the Dynamics Report Writer as a useful tool. [Edit] I am not biased at all.... honest. I recently worked on a support case where the partner had spent a significant amount of time trying to get Report Writer...
  • Blog Post: Removing Extender Data when deleting Transactions or Lines

    I was recently asked to assist a colleague with an Extender case. The problem was that Extender data was not being removed from the Extender SQL tables when its parent record was deleted. The issue of Extender data being orphaned when the parent data is deleted is a known issue (KB 906242 see link...
  • Blog Post: VBA - Determining the company name selected in the Company Login window

    A question came up a while back where the user wanted to know what company the user was logging into in order to give them a message depending on the company selected. The specific issue was that VBA cannot get the name of the company from the DDL (drop down list), it can only give you the position...
  • 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 - Can I print Page Numbers including the Total Number of Pages?

    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. This question was asked again on the Partner Forum recently. It is one that has been asked on...
  • Blog Post: Tools Sessions at Convergence 2009

    If you are going to Convergence 2009 in New Orleans between the 10 th and 13 th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions: GP04 Building Personalized Solutions using Modifier...
  • Blog Post: Modifier - Reading and Writing Data with ADO Example

    It has been a while since I posted some example code, so here is one which demonstrates how to write back data using ADO. The following VBA example adds the Item Short Description and Standard Cost fields to the Item Transaction Inquiry window and reports. It also allows the Standard Cost to be edited...
  • Blog Post: Using ADO with VBA with Report Writer

    As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer. Sometimes it is not possible to use Report Writer to create a table relationship to access the data that you want to add to a report...
  • Blog Post: Using VBA with Report Writer

    Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well. In fact using VBA with the Report Writer can allow us to bypass many of the limitations of the...
  • Blog Post: Why does Microsoft Dynamics GP encrypt passwords?

    Why doesn't the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>? Why does my password sometimes fail to work from one workstation when it works from another? Why does the password policy feature only allow one failed attempt...
  • Blog Post: Modifier - Adding a field to a scrolling window using ADO Example

    The following VBA example adds the Sales Order Processing User Defined 3 field onto the Receivables Transaction Inquiry window. When the window is opened the code will obtain the current user's credentials and open an ADO (ActiveX Data Objects) connection to SQL Server. This connection is closed when...
  • Blog Post: VBA - Preventing Users from logging into multiple companies Example

    Microsoft Dynamics GP uses concurrent licensing which provides for a maximum number of users logged into the system at any one time. Each time a user logs into a company, one license is used. On systems with more than one company, users may use multiple instances of the application running on their...
  • Blog Post: Modifying Reports which use Temporary Tables

    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. Usually, the temporary tables...
  • Blog Post: RW - Accessing any SQL data from a Report Example

    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...
  • Blog Post: Modifier & VBA Samples

    This page contains a summary list of the Modifier & VBA samples that have been posted. Official Samples from CustomerSource/PartnerSource Modifier/VBA Samples for Great Plains 8.0 (CustomerSource) Modifier/VBA Samples for Great Plains 8.0 (PartnerSource) Modifier/VBA Samples for Microsoft...
Page 1 of 1 (18 items)