GP Upgrade – “Please Select a Company” Message

This one’s quite simple, yet intriguing.

I am working on a test upgrade; from GP2010 to GP 2015 R2. I decided to only take production company databases and left all test companies, for all logical reasons.

After applying GP 2010 SP4, I decided to perform a unit testing. After logging in to GP, I received following message, without having any issues later on. It was just this message:

Company Message

(Above screenshot courtesy: Ugan)

As a thumb rule, I searched on GP community and stumbled across two most relevant forum questions and suggestions.

  1. Please select a company message after company has been selected and logged into
  2. Dynamics GP 2015R2 Upgrade – Please select a company

None of them is answered.

I had a suspicion that this must be something to do with “Remember this company” option on “User and Company” window. I decided to use GP Power Tools (previously Support Debugging Tool – SDT) and SQL profiler to study this message in depth.

As suspected, results pointed to the option “Remember this company”. Now, if you remember what I said earlier, I took only the production companies for test upgrade and not the test companies. Previous consultant who was working with this client had selected a test company as his (SA’s) default company.

Now, you must also recollect that we have a SQL script to clean up missing companies’ affiliation across DYNAMICS database.

I ran the above script on the test environment and logged on to GP. This time, I was required to select a company and the message never appeared back.

Happy troubleshooting!


Support Debugging Tool (SDT) – Build 18 Released #MSDYNGP

Amidst crazily busy schedule that I have at the moment, this one must be blogged.

Support Debugging Tool (SDT) Build 18 has been released.

I have a fair idea about how much efforts had gone in. Knowing that, list of new features and list fixes this build contains, I think this is one of the biggest releases yet for SDT.

Just stop your work already and download it from provided links on SDT portal.


Refresh Application Navigation – Support Debugging Tool (SDT)

Are you serious about your Dynamics GP as ERP and are you serious about retaining it till GP becomes completely irrelevant to your business requirements? Contact your partner NOW and get Support Debugging Tool (SDT).

Let me come to the topic now. Earlier, before SDT happened to all of us, when I created a menu item using Extender, I had to restart GP to get this new menu item effected. What’s there in that? It’s something common in GP, isn’t it?

How about creating a menu item using Extender, but instead of restarting GP, just click on an option to get this new menu item immediately effected? Magic? Nope, it’s a reality now. With Support Debugging Tool (SDT), you can.

Open Security Profiler of SDT, and select the menu item Refresh Application Navigation, as shown in below screenshot:



This does exactly what happens when you log on to a company. Cool, isn’t it?

Now, reach out to your partner (if you are a customer) OR download this gem from above SDT portal link (if you are a developer/consultant/partner) and install it on your customers’ GP environment.

This post is to show you a very simple yet tremendously useful feature of SDT. Trust me, there are hundreds of such terrific features available in SDT which will ease your life and earn you reputation as smart consultant.

Find time to appreciate the people who made this SDT possible (and made it a FREE tool for all); David Musgrave & Team. There is a voting going on DynamicsWorld to select Top 100 Influential Microsoft Dynamics People and David’s on page 4. Go ahead and vote for him. Without him and his team, Dynamics GP would be just a mere ERP product, like any other.


Fixed Assets Depreciate Button Disabled For User – Solution

This issue was a bit tricky but not THAT tricky, though.

One of the users reported to me that he was not able to run depreciation because when he opened the Depreciation Process Information window (Microsoft Dynamics GP -> Tools -> Routines -> Fixed Assets -> Depreciate), the Depreciate button was disabled. Below was the screenshot that he sent to me (disabled button is highlighted in RED box):

Depreciate Window


Reason: After quite a bit of analysis (Dex Script Log & SQL Profiling using SDT), I found that there is a table where FA module temporarily records the depreciation activity initiated by any user and will retain that record the process is complete.

User confirmed to me that last time when he ran the depreciation process, it got stuck at the time of printing the results.


The table which records the activity is FA40203 (display name: Book Setup for Depreciation). The table contains three fields: User ID, FA Book Index & FA Book ID.

I took a backup of this table (a simple T-SQL SELECT * INTO…) and removed that stranded activity record for that user.

User confirmed that he could then start depreciation process.

Its always good to start a day with some brainy troubleshooting. But not certainly good for users to start with an issue, though.


Adding Customer Item User-defined Fields to SOP Invoice – Mariano

Another excellent post up there on Mariano’s blog, which explains how to add customer item user-defined fields to SOP invoice.

The customization is done using Support Debugging Tool (SDT) to achieve this.

There is an interesting point which Mariano mentions there, which is not about the topic itself, but about how clients have started demanding things from us, consultants, which shows how much clients are aware nowadays.

Modifier with VBA would have been the BEST and easy option for any developer or consultant for this functionality. But looks like the client was strictly against it because *it’s not supported on Microsoft Dynamics GP 2013 Web Client*. :-)

But that demand indeed had led to another superb piece of customization using SDT.


What feature(s) do you use in Support Debugging Tool (SDT)?

Support Debugging Tool (SDT) is a perfect tool for any GP Administrator/Consultant. It is simply terrific. It has become a part of almost all GP implementations nowadays. And I am no exception on having this tool installed on my GP environment.

David wants to know how we use this tool. What feature(s) is/are useful to you on your GP administration/troubleshooting/maintenance?

Check his post, Microsoft Dynamics Convergence 2012 Houston – Day 2, and register your feedback as a comment. Our comments/feedbacks are required ONLY to justify the time and efforts that are put in on this amazing tool’s development. That said, our comments/feedbacks will be valuable.

I have registered my comment. When are you?


Support Debugging Tool (SDT) v11.0 Build 16 is Released

We have a bundle of features and enhancements added to SDT and the new version v11.0 Build 16 is released.

David has a write up on this release with exhaustive details.

Sure this is going to be more useful than previous versions.