Browse by Tags
All Tags »
ADO (RSS)
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
Read More...
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
Read More...
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
Read More...
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.
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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)
Read More...
