Advanced Find on record forms for CRM 2013

Show Advance find button on entity form MS CRM 2013

Microsoft Dynamics 365 (XRM) links

https://crmadvancedfind2013.codeplex.com/

Add the Advanced Find button to any entity form’s Command Bar for easier access to the feature.

View original post

Action Microsoft.Crm.Setup.Common.Update.DBUpdateAction failed error while installing MS CRM 2013 UR 2

Recently we did a MS CRM 2013 upgrade from MS CRM 4.0 for one of our customer and during the installation of MS CRM 2013 UR 2 we got this error. We tried to look if someone has faced this issue before and found this thread (thanks to poster) ,in Microsoft Dynamics forum, although it is an unsupported changes but it helped us to resolve this issue. We followed below steps which are mentioned there and it resolved our issue.

1. Took a complete backup of your MSCRM_CONFIG database

2. Rename dbo.dbupdateinstallinfo to dbo.dbupdateinstallinfo-old, under mscrm_config db.

3. Rename dbo.dbupdateinstallinfo_V5 to dbo.dbupdateinstallinfo_V5-old under mscrm_Config db.

4. Installed MS CRM UR 2.

MS CRM 2013 UR 2 recreated these tables as per a new installation of CRM 2013.

Hope it will help someone!!

Update sub grids record in MS CRM

Did you get a requirement to update child entity records available in sub grid in parent entity, so for example if you are working opportunity and you need to update all the related quotes records which is available in quote sub grids under opportunity screen. You can use below code and can modify based on your requirement

function GetAllQuotesIds() {
var gridControl = document.getElementById(“opportunityQuotesGrid”).control; //Change grid name here
var subGrid = gridControl.get_allRecordIds();
for (i = 0; i < subGrid.length; i++) {
var Quote = new Object();
Quote.Name = “Demo”;    // change to update your field
var Id = subGrid[i].replace(“{“, “”).replace(“}”, “”);
UpdateQuotes(Id,Quote); } }

function UpdateQuotes(Id,Quote)
{
var jsonEntity = JSON.stringify(Quote);
var ODataPath = Xrm.Page.context.getServerUrl() + “/XrmServices/2011/OrganizationData.svc/QuoteSet”; //Change entity name here
$.ajax({ type: “POST”,
contentType: “application/json; charset=utf-8”,
datatype: “json”,
data: jsonEntity,
url: ODataPath + “(guid'” + Id + “‘)”,
beforeSend: function (XMLHttpRequest)
{XMLHttpRequest.setRequestHeader(“Accept”, “application/json”);
XMLHttpRequest.setRequestHeader(“X-HTTP-Method”, “MERGE”); },
success: function (data, textStatus, XmlHttpRequest) { alert(“Success”); },
error: function (XMLHttpRequest, textStatus, errorThrown) { alert(“Error while updating record” } }); }

Make sure you have REST and Jquery libraries are added to your form.

Hope it will help someone.

Enjoy !!!

Quick Tip for “Permission Denied” error in MS CRM

Are you getting “Permission Denied” error and you are confident that all your scripts are working fine and not causing this issue, you may be correct 🙂 it’s not always you will get this error because of your scripts only, you may get this error if you won’t add MS CRM url under trusted sites in your browser, so make sure to ask your clients to add MS CRM url in trusted site before using MS CRM application.

Hope it will help someone.

Enjoy !!!

Microsoft Dynamics CRM 2013 Online Server IP Address

Recently we did a POC for one of our client and during this POC we demonstrated the integration between MS CRM 2013 online with well-known billing software. The billing software had a prerequisite to store IP address of the servers from where we are consuming their API to communicate with their system. We found this KP where all the MS CRM 2013 online servers IP address are listed based on the region, where your MS CRM 2013 online organization is hosted for example:

North America

Europe

Asia-Pacific

Hope it will help someone!!!