CRM 2011 Update Rollup 1 Released


CRM 2011 Update Rollup 1 is released. List of all bugs that are fixed can be read on this KB Article #2466084.

Looks like there are some really critical bugs that have got fixed. Those who are in CRM2011 RTM, it’s time for you to sit up and take notice of this rollup.

VAIDY

Microsoft Dynamics GP Support And Services Blog


I am not going to introduce this blog, because that part is taken care by the first post in this new blog from Microsoft.

Microsoft Dynamics GP Support And Services Blog, is from Microsoft Support Team catering various support and services topics of Microsoft Dynamics GP.

Start following this blog for more critical information. Stay tuned.

VAIDY

Failed To Create Object – OLE Error due to Adobe Reader X


Something seems to be amiss with Adobe Reader X and Dynamics GP. Yesterday we upgraded Adobe Reader to version X on our Terminal Server, where our Dynamics GP application resides.

Till then, users were able to attach PDF files to GP records using OLE Object Container. But post upgrade, all users are facing the following error message whenever they try to attach a PDF file or view an existing PDF attachment:

Looks like I am not the only one to face this issue. There is a community forum post which raises the same question. Link to that post: Errors when opening or creating PDF OLE Attachments in Dynamics GP notes.
Not sure how to resolve this at the moment, other than retaining older version of Adobe Reader.
VAIDY

Changing a Smartlist Favorite’s visibility thru’ SQL


Warning: Method shared in this post is NOT supported or advised by Microsoft team. This article explains a SQL method and therefore the intended audience is a GP and SQL Consultant / Developer / Administrator.

Couple of Smartlist Favorites created by an end user, but created it with a wrong visibility: Visible by User ID. What this user should have selected is: Visible by System. Since these favorites are suppose to be accessed by all Users across all Companies.

This end user is currently out and even as SA I could not access the Smartlist Favorites. Easiest and direct approach is to reset this user’s password, modify the smartlist favorite and notify him of the new password. Once this user is back, he/she would change the password.

But, is there any other simplest method for someone like me? A GP & SQL Administrator? Of course, I do.

I can modify a Smartlist Favorite using a simple SQL UPDATE statement, targeting the Smartlist Favorite tables ASIEXP81 and ASIEXP86. Display Name for these tables are Smartlist Favorite Master and Smartlist Favorite Columns Master respectively. Both tables are in DYNAMICS database.

Below are SQL statements that I used to change the visibility:

UPDATE DYNAMICS..ASIEXP81 SET ASI_Favorite_Save_Level = 1, USERID = ”, CMPANYID = 0 WHERE ASI_Favorite_Name = [Favorite_Name_Given_By_That_End_User]

UPDATE DYNAMICS..ASIEXP86 SET ASI_Favorite_Save_Level = 1, USERID = ”, CMPANYID = 0 WHERE ASI_Favorite_Name = [Favorite_Name_Given_By_That_End_User]

In above statements, field ASI_Favorite_Save_Level is the Visibility Type that we set up when we create a Smartlist. Value 1 denotes the first option in that Drop Down, which is SYSTEM. Since I have to set visibility to all users across all companies, all I have to do is to set USERID as an Empty String and Company ID as ZERO.

This will change a particular Smartlist Favorite’s visibility as required.

Simple, isn’t it?

VAIDY

Microsoft Dynamics GP "12" To Have For Support Mac Computers


** Excellent news from David. Microsoft Dynamics GP “12” to have support for Mac Computers.

Exciting to say the least. And I am dying to see GP “12” feature additions and enhancements.

VAIDY

This was an APRIL FOOL DAY’s post from our beloved David Musgrave. Alright I did not know that in first place. I was damn so excited that it didn’t strike my mind.

David, you caught me there.

The Future of Microsoft Dynamics GP Technologies – Mariano


Mariano highlights 5 coolest technologies for Microsoft Dynamics GP in coming years to watch out for. I can’t agree for more, since I am already seeing 3 of the highlighted 5 currently.

Just to list you those technologies:

1. Microsoft Lync
2. Microsoft Silverlight
3. Microsoft Visual Studio Lightswitch
4. Cloud Computing
5. Microsoft Dexterity (yeah you did hear it right)

And to know why the above are cool, check out his post: The Future of Microsoft Dynamics GP: 5 Cool Technologies You Should Watch For (and Learn) in the Coming Years

VAIDY

Last Sale By a Customer & Item – Victoria’s SQL View


Victoria‘s latest SQL view retrieves the last sale by customer and an item. With little tweaks here and there, this SQL view will serve us immensely to show various information pertaining to Customer and/or Item sales.

Thanks Victoria for this view. This has come especially when I am working on some dashboards and reporting. It’s surely going to help me deriving some important reports.

VAIDY

Disenchanted with Support? – Kuntz Consulting


How many times have to faced such incidents? And how many times have you given such incidents to your customers?

This post, Disenchanted with Supprt? I understand your pain, from Kuntz Consulting blog reminds us of the badness of NOT attending to your customers or at least a courteous response.

Good one.

VAIDY

Microsoft Dynamics GP 2010 R2 – Business Portal External Lists


Looks like an excellent feature addition. So far, we had to rely on Extranet Services for any edit from Business Portal. This Business Portal External Lists feature now fills that gap. We have to wait and see how much we can do using this External Lists.

Errol introduces this feature to us on recent Inside Microsoft Dynamics GP post.
VAIDY

Microsoft Dynamics GP is very much here to Stay


Today, I had another opportunity to attend one of Microsoft’s high rated event, Microsoft Dynamics GP Customer Event. I have been fortunate to attend such events off late and I sincerely hope I will be in future as well.

What’s the highlight of this event? Elcome International LLC, with whom I have been proudly associated with for the past 1.7 years, presented Microsoft Dynamics GP 2010 Customer Testimony. Mr.Jimmy Grewal, Executive Director, Elcome International LLC, briefed about Elcome’s GP experience and future plans.

Is that all? Nope. There is one more information that I would like to share with you all from this event. Specifically, for those who predict a doomsday for GP and it’s future, with all due respect, I would like to assure you that GP IS HERE TO STAY AND MICROSOFT IS IN NO MOOD TO DISCONTINUE WITH GP. This was mentioned by none other than Microsoft MBS Product Manager (Gulf), Mr.Ahmed Salama.

There is an interesting statistic which I would like to share and emphasis on my point: Microsoft Dynamics is having 1500 customers in GCC region excluding Egypt, North Africa and Saudi Arabia. Out of these 1500 customers, 40% is for Microsoft Dynamics GP. That calculates to 600 customers. These 600 customers include some of the high profile customers including Elcome International LLCIf we consider overall customers count across this vast globe, Microsoft has more reasons to support this product than abandoning it. 

Even us, human beings, have limited lifetime. We still enjoy our life and we live it to it’s fullest, don’t we? Like that, I love this wonderful product called Dynamics GP and I AM IN NO DARN MOOD TO LEAVE THIS PRODUCT.

VAIDY