Page 1 of 7312345678910...2025303540...Last »

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!


Filed under: #MSDYNGP, Dynamics GP 2015, GP 2010, GP 2015, GP 2015 R2, GP Power Tools, Microsoft Dynamics GP 2015, SDT, Support Debugging Tool, Troubleshooting

Excerpt from:
GP Upgrade – “Please Select a Company” Message

November 24, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 13

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.


Filed under: #MSDYNGP, General, GP 2010, GP2010, Support

Original post:
GP 2010 Mainstream Support Ends Soon

September 29, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65

Windows 10 .Net 3.5 Framework Installation Bummer: Error Code 0x800F081F

This one’s another issue that was eating my brain for the past 2 days. Little bit if story first.

I have a Windows 10 Pro virtual machine on my MacBook Pro. Things went well until I tried installing SQL Server 2014 Express, which required .Net Framework 3.5. .Net 3.5 is built-in and we need to enable it from “Turn Windows Features On or Off”.

That’s where the bummer was. I could not turn .Net 3.5 on at all. Following was the error message that I was getting:


That “Tell me how to solve this problem” takes you to this link: .NET Framework 3.5 installation error: 0x800F0906, 0x800F081F, 0x800F0907.

Unfortunately, for me, this post did nothing other than wasting my 10 minutes of time. Surfing about this error further led me to this post: Offline install of .NET Framework 3.5 in Windows 10 using DISM.

This post discuss about a workaround, but the ONLY working workaround. Below is a screenshot of how this works:

Screen Shot 2015-09-18 at 8.38.25 AM

I could then install/enable .Net 3.5 Framework on my VM and continue with GP installation.

Happy troubleshooting.


Filed under: .NET, Operating System, OS, Windows 10

Continue reading here:
Windows 10 .Net 3.5 Framework Installation Bummer: Error Code 0x800F081F

September 18, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65

GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

There were couple of exceptions related to GP2015 R2 that I wished to share here. One would be discussed here and other one on the next post.

After upgrading to GP2015 R2, while doing a routine testing, following error message was thrown while trying to open Smartlist:

Screen Shot 2015-07-31 at 6.53.32 PM

Full message as follows:

Unhandled database exception:
A get/change operation on table ‘ASI_MSTR_Explorer_Favorites’ failed accessing SQL data.

Number of results columns doesnt match table definition.

Number of results columns doesnt match table definition.


Debugging this error took me to the table Smartlist Favorites Master (ASIEXP81). Strange, however, that number of columns indeed matched.

I remembered this issue happening in GP 10 and GP 2010. Suggested solutions were to run GRANT.SQL on all databases and changing ODBC provider to SQL Native Client. However, in my case, both were already done and confirmed.

To avoid any further delay or issue(s), I decided to backup the records from ASIEXP81, recreate the table using GP SQL Maintenance and push the records back from the backup table.

Resolution: Drop and create the table Smartlist Favorites Master (ASI_MSTR_Explorer_Favorites, ASIEXP81) using GP SQL Maintenance.

Only that, I did not have to reinsert the records. When I opened the Smartlist after recreating the table, it automatically populated all records. Strange, again. But it worked.

Word of caution: Always take backup before you do anything with the data.


Filed under: Uncategorized

GP2015 R2 Upgrade – “ASI_MSTR_Explorer_Favorites: Number of results columns doesn’t match table definition”

August 2, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 156

MDGP 2015 R2 Feature of the Day: Analytical … – azurecurve

For example, the below SmartList shows how the list would display for a company tracking Cost Center and Project as AA transaction dimensions. Analytical Accounting SmartList. The change in …, …

Read this article:
MDGP 2015 R2 Feature of the Day: Analytical … – azurecurve

May 24, 2015 · Ian Grieve · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 110

Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

Phew! How about that OneRepublic concert?

Day 4 is finally here and with it, all good things must come to an end. For a change, today David and I managed to make it down to the GWCC on time and had a fairly relaxed breakfast at the Meal Hall to then move over to the Phillips Arena for one very interesting closing keynote.

As customary, an energetic Judson Althoff, President Microsoft North America welcomed the crowd to the event and proceeded to recap the week and what will be seen from Microsoft in the coming months.

Judson Althoff, President Microsoft North America

The first thing in his opening was to remind the audience how Convergence is becoming the premier event for business and that Microsoft, at its core, is “the productivity and platform company for the mobile first, cloud first world” and how the company is thinking about innovation and technology.

Althoff then introduced the upcoming events, Microsoft Ignite which is geared to showcase innovations for IT professionals, the Dynamics User Group Summits hosted by Dynamic Communities.

Microsoft Ignite

Dynamics User Group Summits

Althoff then zeroed in on the upcoming Convergence events and announced the dates and locations for Convergence 2015 EMEA and Convergence 2016 New Orleans. The latter received a round of shouts from the audience.

Convergence next stops

Then came the topic of the day: Cyber-security and the work being conducted by Microsoft and its Digital Crime Unit to counter the effects of online criminal activity.

After a short intro video (above), David Finn, Executive Director Microsoft Digital Crimes Unit who then introduced the work of the new division opened just 16 months ago and located in Redmond, Washington. The unit fights two types of crimes: Technology-facilitated crimes which targets vulnerable population such as children and the elderly, and Malware and reduction of digital risk.

David Finn, Executive Director Microsoft Digital Crimes Unit

Finn then presented a number of grim statistics around the children victimization and introduced Microsoft PhotoDNA, a new cloud based solution that can be licensed by anyone to detect awful images and report them to law enforcement organizations around the world.

Microsoft PhotoDNA

David Finn then addressed the topic of malware and cyber criminal activity using botnets and how Microsoft assisted with the Citadel Malware case, which involved the infection of over 91 million PCs and the hijack of close to half a billion dollars ($500M). The case had a particular focus on using visualization and big data to analyze infection patterns across the world.

The Citadel Case

Citadel Infection Pattern

As a result of these efforts, Microsoft is experimenting with new visualization and sonification techniques to understand infection patterns. One such technique is dubbed the Specimen Box and was presented during the session.

Specimen Box – Live Mode

After the closing session, we returned to the GWCC to do some walk around the Expo. I stopped at the booth of my friends and partners at FieldOne to congratulate them for their new achievement. Microsoft has named them a Dynamics CRM Global ISV which shows their commitment to developing the channel and producing quality products.

The FieldOne team

From the Expo, I went to Mark Polino’s session CS15G003-R2 Microsoft Dynamics GP: New 50 tips in 50 minutes, a jammed pack session filled with bite size tips on Microsoft Dynamics GP functionality. Mark had a full room and as the rock star he is, he commands quite the attention from the attendees. I have to admit I picked up a few good tips for my toolbox.

Up next, I had to complete the repeat of my upgrade session, CS15G002-R2 Microsoft Dynamics GP 2015: Upgrading and deploying. I had been assigned the last slot on the last day of the event, which I have been doing for the past 6 years now. While I did not have the same amount of attendees as with my first bout at this session, 85 people were still pretty good, considering that a lot of people left to catch their flights early in the morning.

After my repeat session, it was time for some relaxation and the famous Tim Tam Slams. Earlier, I had sent out a tweet to a number of people to meet up at the Omni Hotel bar for what has become a tradition among a select few of us. Before the slams though, I managed to meet with a group of friends from Colombia to explain some good ol’ fashioned Microsoft Dynamics GP architecture and deployment options for their company and how the web client and Microsoft Azure have revolutionized the way Microsoft Dynamics GP is deployed.

I then moved over to the bar with my friends Olga Acosta and Eddie Yepes to grab a drink before sitting down for Tim Tam Slams.

Olga Acosta does the Tim Tam Slam

Eddie Yepes does the Tim Tam Slam (and fails miserably!)

The final stretch of the evening would have me doing dinner with my good friends and fellow MVPs Belinda Allen, John Lowther, and of course David Musgrave at Dantanna’s Downtown location, inside the CNN Center. We spent the evening chit-chatting from one thing to another and enjoying John’s vicious appetite for Thousand Island dressing on his salad.

After a wonderful meal and excellent service we proceed to leave, not without running into the Njvity folks.

Chris Dobkins, Mariano Gomez, Emily Roen, and David Musgrave

The event was now over for good and it was time to leave. I really could use some sleep… but wait, still more to come.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Read more here:
Microsoft Convergence Atlanta 2015 (#CONV15) – Day 4

April 2, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 165

Mahmoud Al Saadi – Dynamics GP MVP!!


I am proud to inform you that my colleague “Mahmoud M. Al Saadi” is now Dynamics GP MVP!

Well deserved and well expected!


Mohammad R. Daoud MVP – MCT
+962 – 79 – 999 65 85

View post:
Mahmoud Al Saadi – Dynamics GP MVP!!

April 1, 2015 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 169