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:
(Above screenshot courtesy: Ugan)
As a thumb rule, I searched on GP community and stumbled across two most relevant forum questions and suggestions.
- Please select a company message after company has been selected and logged into
- 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.
If you were able to log in, you could use GP Power Tools’ Database Validation to cleanup all the databases and users for your test system.
I was not aware of it. I was under the impression that it performs “Clear Companies” task, but not the user option where a user selects a company as default. I will check this out soon.
Thanks for pitching in with that input.
Pingback: GP Upgrade – “Please Select a Company” Message – Nov 24, Dynamics GP – Learn & Discuss |