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!

VAIDY

Advertisement

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.

VAIDY

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.

VAIDY

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. 🙂

VAIDY

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. 🙂

VAIDY

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.

VAIDY

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.

VAIDY

Dynamics GP 2010 is compatible with SQL Server 2012


Mariano, in his new post, confirms that Microsoft Dynamics GP 2010 is compatible with SQL Server 2012. The post also has got links to both CustomerSource and PartnerSource.

This is a good news, since SQL Server 2012 will precede Dynamics GP 2013, which means customers would be first upgrading their SQL Server first.

SQL Server 2012 has got tremendous amount of features that are going to be crucial in future.

So let’s gear up for some serious upgrades.

VAIDY

Check Links for Analytical Accounting in Microsoft Dynamics GP 10 & 2010


Inside Microsoft Dynamics GP blog has got a post that cautions us about two important things:

1. Don’t run Check Links process for AA at this time on versions GP10 and GP2010.

2 Apply latest Service Packs or Hotfixes for Microsoft Dynamics GP (versions 10 and 2010) to get AA related latest fixes.

More on this here: Information about Check Links for Analytical Accounting in Microsoft Dynamics GP.

VAIDY

Complete list of Microsoft Dynamics GP 2010 R2 SSRS Reports


Inside Microsoft Dynamics GP has listed out all SSRS reports for Microsoft Dynamics GP 2010 R2.

The list categorizes reports by module and indicates whether it’s a normal report or KPI based report. This would be the best document to make us aware of and convince our customers that GP does have such expansive list of standard reports and KPIs.

VAIDY