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

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

Smartlist: Splitter control in Smartlist window doesn’t work

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

Last week, I enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety.

In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.

Continue reading

Checklist for creating a new Dexterity Window

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

Today, we go back to basics. It is always good to make sure that we have the foundations handled properly.  When I teach the Dexterity, I always go through the standard checklist below for creating (or modifying) Dexterity windows.

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

Understanding Cross Dictionary Dexterity Development

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

A recent newsgroup post has raised the question of whether it is possible to customise an alternate form using Dexterity.  This is covered on my earlier blog post: Can I customise a 3rd party form with Dexterity?

Continue reading

Modifier – How to Expand the GL Transaction Entry Scrolling Window Example

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

One of the customisations that I have heard requests for a number of times is to open the General Ledger Journal Entry (GL Transaction Entry) window’s scrolling window (grid) to its expanded state when the window is opened.

Continue reading

Removing References to Fields in VBA Revisited

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

Michael Johnson (the MBS Guru) has posted a great article about removing invalid references from a Visual Basic for Applications (VBA) project. This has prompted me to revisit the topic and gather together all the relevant resources from a number of blog authors.

Continue reading

Creating SQL Views of DUOS Data

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

Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields.

The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in a string field 132 characters long.

Continue reading

Handling Translation when Customizing with VBA

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

From the Translating Dexterity Applications Series.

The final topic in the series is one that was added later after I was asked about how to handle translated applications when writing customizations.

Continue reading

Customizing Visual Studio Tools Addin Modules

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

In a recent Newsgroup posting, it was asked if Modifier and VBA (Visual Basic for Applications) and the Extender module worked for windows created as part of a Visual Studio Tools for Microsoft Dynamics GP Addin module.

Continue reading

Customizations that you do not need to do

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

Having supported the various customization tools over the years, you run into common requests again and again.  Something that often surprises me is that you get requests to ‘customize’ Dynamics GP to make it do something and as it turns out Dynamics GP already does this out of the box.

Continue reading

Hybrid – Adding Named Printers control to Reports using VBA

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

Named Printers is a module to allow controlling of the printer and settings used when printing reports.  It was originally developed for v3.00 by me while I was working for Sequel Technology (that’s why the tables and calls are prefixed with ST).  Later it was purchased by Great Plains for v5.50 and included in core code (Dynamics.dic) for v6.00 onwards.

Continue reading

The “Do you want to save?” dialog appears when no changes are made

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

Recently I responded to a newsgroup post where the Sales Transaction Entry (SOP_Entry) window was popping up the “Do you want to save?” dialog when moving between records even though no changes had been made by the user.

Continue reading