Identifying where SmartList Column Data comes from

Recently, I had a support case which asked the following: “When I go to Add the Sales Account Number to the Sales Line Items SmartList, there are three Sales Account Number Columns available. What is the difference between them?” So, I wanted to work out a method to make it fairly easy for customers and…

2

Quick Tip: Where does that customisation come from?

I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what…

1

Quick Tip: VBA ADO Connection Run-time error '3709'

It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to…

2

Edits To Dynamics Launch File Won't Save

My blog post today isn’t anything earth shattering but something a partner ran into that was unexpected.  Logical – but unexpected nonetheless. A recent forum post detailed how the user was trying to set forms & reports dictionary paths using the Edit Launch File window.  What they found was that after editing the launch file…

3

Changing the Phone Number Format

One of the most common customisations outside of North America is changing the Phone Number Format.  The North American default format of (XXX) XXX-XXXX  Ext. XXXX is not always suitable for other countries. For example: Australia, Singapore and Malaysia now use a domestic format of a 2 digit area code and a 8 digit phone…

10

Why does Microsoft Dynamics GP 10.0 and later use a Data Folder?

I recently responded on a forum post which asked why the paths for the custom forms and reports dictionaries in the Dynamics.set launch file where pointing to the Data folder. The post also asked why the application did not complain about the fact that the dictionaries listed in the Dynamics.set did not actually exist in the Data…

2

Dynamics GP Customizations Summary

First Jivtesh Singh creates the awesome portal site GPWindow.com and now he starts using it to gather all the best posts together. His latest blog post covers Microsoft Dynamics GP Customization with its many tools and methods and highlights a large number of fantastic posts from around the community. This post is well worth a…

1

Avoiding VBA Circular References when using a Dynamics GP Lookup

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…

4

Errors when importing Customization Maintenance Packages

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…

7

Microsoft Dynamics GP 2010 Technical Web Seminars

With the release of Microsoft Dynamics GP 2010 this is THE place to get ready to learn about this release, innovative development tools, best practices and more. Help ensure your PEOPLE are your most powerful asset by gaining technical readiness for Microsoft Dynamics GP 2010.  Learn about the new features and tools by attending the…

2

Smartlist: Splitter control in Smartlist window doesn't work

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…

2

Microsoft Dynamics Convergence Atlanta 2010 Wrap Up

I am finally back home in Perth and the time has come to wrap up my first Convergence (and my first trip to Atlanta, Georgia, USA).  The trip was a great success and Mariano and I will hopefully be given the opportunity to come back and present again. It was worth the 27 hours flying to get to Atlanta…

2

Smartlist: Only the data area should grow

I’ve seen several questions over the years on Smartlist of the “Why doesn’t it?” variety such as: Why does Smartlist export to Excel so slowly? Because Smartlist exports row by row and sets each cell individually. Why does Smartlist automatically try to display the default Smartlist when the node is selected (such as Customers)? It…

14

Checklist for creating a new Dexterity Window

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. This checklist is valid for Dexterity when creating new windows or editing existing windows which will…

3

Hybrid - Setting a push button to Hyperspace

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. What happens? A. Focus moves to the button causing the field change script to run and validates that Customer Number “AARON”…

0

Hybrid Development and Continuum

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. With all the tools available to the Microsoft Dynamics GP developer, and each tool having its strengths and weaknesses, it…

5

Understanding Cross Dictionary Dexterity Development

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? However, I thought I would try and clarify what can be achieved with Dexterity for each of the different situations….

6

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

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. The method to make this happen is to use Visual Basic for Applications (VBA) to “press” the expand button as…

1

Removing References to Fields in VBA Revisited

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. A few months back, Mohammad Daoud published a post on the same subject. His…

1