File not found: VBA6.dll error occurs or GP crashes and creates a Watson fault bucket 1474386816

Beth Gardner - Click for blog homepageThis is a reposting of an article Beth Gardner originally wrote on my Developing for Dynamics GP blog.

We have been running into a few different issues with Microsoft Dynamics GP 10.0 and GP 2010 when you have Office 2010 installed.

[Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL and VBE7.DLL errors.  Please download the necessary files from this link:

 

Continue reading

Currency values returned by VBA to a report are multiplied by 10 or 100 with Multicurrency

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 (depending on if we wanted the currency symbol or not).

Continue reading

Currency values returned by VBA to a report are multiplied by 10 or 100

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I wanted to highlight an issue that you might see when working with Visual Basic for Applications (VBA) and Report Writer.

The issue occurs when using VBA code to return a currency value to be displayed on the report and it appears to be randomly multiplied by 10 or 100.  This is a known issue (Problem Report 59380) and this post should help explain what the problem is and provide an alternative solution.

Continue reading

VBA – Displaying Extender Data for GL Transaction Lines on the GL Inquiry window

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

You might remember last month when we had a support case where the customer wanted to use Extender additional information against the General Ledger Journal Entry (GL_Transaction_Entry) distribution lines.

Continue reading

Changing Dictionary Context when using Passthrough Dexterity sanScript Part 2

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This is the second in a series of posts which are are designed to help Dexterity developers as well as VBA and Visual Studio Developers to understand how to work with passthrough Dexterity sanScript.  The main focus of this series is to understand how to change the Dictionary Context that the code executes in.

Continue reading

Avoiding VBA Circular References when using a Dynamics GP Lookup

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Honestly, I struggled a bit on the title of this article.

Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization?  Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects in Dynamics GP?

Continue reading

Why making the Dex.ini file read only is evil

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only.  There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting from the Dex.ini file and then marking the file as read-only.  Well, in my opinion this method has always been evil and from Microsoft Dynamics GP 10.0 onwards will not work anyhow.

Continue reading

Errors when importing Customization Maintenance Packages

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I had a support case that was asking about errors when importing a package via Customization Maintenance (Microsoft Dynamics GP >> Tools >> Customize >> Customization Maintenance).  The partner was unable to find an explanation of the errors on the Internet and so I thought I would explain what the errors mean and provide some best practices to avoid these issues in the future.
Continue reading

VBA – Adding Extender Windows to GL Transaction Entry Lines

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Last week I had an interesting support case that I thought I would share with you.

The customer had created an Extender window to capture additional information for distribution lines on the General Ledger Journal Entry (GL_Transaction_Entry) window. The unique identifier for a distribution line is the Journal Entry field from the main window and the Sequence Line field from the scrolling window. These are the fields used when creating the Extender settings for the additional information to be stored.

Continue reading

Why can’t I maximize my window?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

A recent support case asked “Why can’t I maximise my Payable Transaction Entry Distribution window?”.  This worked for versions 8.0 and 9.0 but does not work for version 10.0 and GP 2010 (v11.0).  What has changed?

Everything. Well … lots in the way windows in the Microsoft Dynamics GP application are handled.

Continue reading

VBA – Calling a Report using Visual Basic for Applications

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked about a forum post of mine from a few years ago. It was about how to call a Dexterity report from Visual Basic for Applications (VBA).  I checked the blog and could not find a post that showed the code in its simplest form.  So here one is…

Continue reading

Determine SOP Type in SOP Entry using VBA or Visual Studio Tools

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

I think the most customized window in VBA must be the SOP Entry window.

If the customization is not saving custom data for the header/line items, then it is adding custom logic based on document type and any number of other factors.

In all of this – especially saving custom data to a parallel table – the SOP Number is important as it identifies the document.  And, of course, to be unique your primary key would also include the SOP Type field – just like the SOP10100 table does in Dynamics.

Getting the SOP Number is easy – it is the string value from the window.

Continue reading

Automating or Customizing the Report Destination Window

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have seen this issue come up a number of times.  Trying to automate processes which involve reports and wanting to automate the Report Destination window.  Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA.  This post will explain the reason for this “weird” behavior.

Continue reading

Hybrid – Setting a push button to Hyperspace

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Trivia question for today:

Given the following sequence of events:

In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in “AARON”. The user then presses the associated lookup button.

Continue reading

Hybrid Development and Continuum

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development.  More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box.

Continue reading

Totalling a field in a Conditionally Suppressed Section on a Report

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I was recently asked how can you total a field in a report when that field is in a conditionally suppressed section.  You might ask why should this be difficult.  The reason for the complexity is this….

Suppressing a section just stops it being displayed at the last moment and does not exclude the section from other processing by the report writer.

Continue reading

Using Integration Manager with Analytical Accounting

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.

Continue reading