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!


GP 2010 Mainstream Support Ends Soon

All GP customers, ISVs, VARs and consultants should bear in mind that GP 2010 mainstream support ends on October 13, 2015.

Extended support runs till 2020, however it is strongly advised to upgrade your GP to most recent version (or a higher version on which your other modules/add-ons are compatible with).

You may want to bookmark this complete support schedule on Microsoft’s portal: Microsoft Support Lifecycle – Dynamics GP.


Error when switching back to Microsoft Dynamics GP from Modifier – Fixed in SP3

With the release of Microsoft Dynamics GP 2010 SP3, MSFT GP development team has fixed one of the nagging bugs which got introduced in Microsoft Dynamics GP 2010 R2.

The following posts would explain what exactly that issue is:

Error When Switching Back To Microsoft Dynamics GP From Report Writer (Ian Grieve)

Unhandled script exception: Illegal address for field ‘[Not Found]’ in script ‘Unregister_Triggers’ (Mariano Gomez)

Rest assured that this bug is now fixed with the release of Gp 2010 SP3.


Microsoft Dynamics GP 2010 SP3 Released

David Musgrave informs us about the release of Microsoft Dynamics GP 2010 Service Pack 3. Read his post and plan for the upgrade.

Got to plan my Saturday accordingly now. :-)


Choosing a Development Tool for Microsoft Dynamics GP

Microsoft had published a white paper on choosing a development tool for Microsoft Dynamics GP, at the time of GP 2010 release.

Though it’s pretty old, it’s still valid even now to refer to this white paper.

Download it here: Microsoft Dynamics GP 2010 White Paper – Choosing a Development Tool

Soon, we would all be getting ready for Microsoft Dynamics GP 2013 and I am sure, this white paper would still be valid. :)


Prevent Users from Keying Incorrect Document Dates in GP 2010

Awesome tool and I would say, its need of the hour.

Now, I read this post on Microsoft Dynamics GP Support Blog on a tool that comes with Professional Services Tools Library (PSTL) to Prevent Users from Keying Incorrect Document Dates in GP 2010.

But unfortunately, scope of this tool is limited to following transaction entries:

  1. Payables Transaction Entry
  2. Receivables Transaction Entry
  3. Invoice Entry
  4. PM Manual Payment Entry
  5. SOP Entry
  6. IV Transaction Entry
  7. Cash Receipts Entry

I would have expected this to have even more reach, especially on POP side. Today, just today, I received a bunch of PO Invoices being posted on a wrong date. I would have loved to have this tool on my environment had this covered much more types of transactions.

However, this is still very good than reinventing this by developers or partners.


Dynamics GP 2010 Upgrade Paths

Njevity Blog has got an important piece of information, posted by Melissa Sandrovich, on available Upgrade Paths for Dynamics GP 2010.

The paths are detailed from versions 9.0 till lower versions of GP2010 to it’s current version.

Those who are looking for this information anywhere else, this post would be of immense time saver.