Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
While working with Microsoft Dynamics GP v9.00, I have seen a situation where adding fields to VBA does not work anymore. You can add windows and reports, but when adding a field they don’t show up on the project.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Microsoft Dynamics GP remembers the last user to use the application and defaults the User ID into the login window next time the application is loaded. This is useful when only a single user uses the specific workstation install. In a Terminal Server or Citrix environment, multiple users use a single workstation install and so it would preferable if the User ID was left blank when the application launches.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Sometimes you need to run VBA (Visual Basic for Applications) scripts after a successful login attempt. Using the OK Button on the Company Selection window does not always work as the login could still fail. For example, the user is already logged into the selected company. Also this does not help capture the logging out.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example extends the Reference field on the GL Transaction Entry window from string field of 30 characters to a text field of 200 characters. The first 30 characters of the text field are populated into the original string field so it will contain data when viewed on a non-modified window or report.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
When using the Modifier to add a list field (drop down list, button drop down list, listbox, multi-select list box) to a window as a local field, the only option available to populate the list was to add static values. This is because there is no functionality available in VBA to add items to a Dexterity list field.
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.
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.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example adds two additional fields to the Sales Prospect Maintenance window and Sales Prospect Report.