Search This Blog

Tuesday, August 8, 2017

An input for 'parentcustomeridtype' field is required in order to process lookup field 'parentcustomerid' correctly. The input value should be one of the following entity names, or its corresponding entity type code in integer format: 'account', 'contact'.

An input for 'parentcustomeridtype' field is required in order to process lookup field 'parentcustomerid' correctly. The input value should be one of the following entity names, or its corresponding entity type code in integer format: 'account', 'contact'. 


Solution:
This error will occur when you map the "parentcustomerId" to CRM destination using text lookup but "parentCustomerId" field is customer dataType it contains both account and contact id. It will decide based on the "parentCustomerIdType" field.



In order to solve the issue we would need to map that field in the CRM destination


Monday, August 7, 2017

Check whether dll is 32 or 64 bit

Sn Path:C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin
C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>CorFlags.exe D:\Source\Data\HelperUtility.dll

Download CorFlags Tool

To Determine the type of dll:
Any CPU: PE = PE32 and 32BIT = 0
x86 bit: PE = PE32 and 32BIT = 1
64-bit: PE = PE32+ and 32BIT = 0


Check dll is signed using SN.exe tool

Sn Path:C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin
sn -v D:\Source\Data\HelperUtility.dll
Download SN Tool

If it is signed then:



Tuesday, July 25, 2017

Business Process stage onChange event

You can’t cancel the stage change using code in a handler for this event

//Put the below code in the onload function of the form
Xrm.Page.data.process.addOnStageChange(onStageChange); 


function onStageChange(ExecutionContextObj)
{
debugger;
alert(ExecutionContextObj.getEventArgs().getDirection()) // alerts "next" or "previous"
} 
This onStageChange method gets trigger when you click next or previous button. But it is not triggered when you click the link of the stage.

Thursday, July 13, 2017

Dynamics CRM SSRS report Visual studio version comparision


Panel
Description
Dynamics 365,2016
·         Microsoft Visual Studio 2015 and SQL Server Data Tools in Visual Studio 2015
·         Microsoft Visual Studio 2013 and Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013
·         Microsoft Visual Studio 2012 and Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012
·         Visual Studio 2010 and SQL Server Data Tools
·         To install SQL Server Data Tools, on the PC running Visual Studio 2010 go to the Microsoft SQL Server 2012 Express download page, download the following files appropriate to your CPU architecture and language:
·         ENU\x64\SQLEXPRADV_x64_ENU.exe
·         ENU\x86\SQLEXPRADV_x86_ENU.exe
·         Select the "SSDT" or "SQL Server Data Tools" installation.
2015
·         Microsoft Visual Studio 2012 and Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 

-- OR --
·         Visual Studio 2010 and SQL Server Data Tools
·         To install SQL Server Data Tools, on the PC running Visual Studio 2010 go to the Microsoft SQL Server 2012 Express download page, download the following files appropriate to your CPU architecture and language:
·         ENU\x64\SQLEXPRADV_x64_ENU.exe
·         ENU\x86\SQLEXPRADV_x86_ENU.exe
·         Select the "SSDT" or "SQL Server Data Tools" installation.
2013
The following components are required:
·         Business Intelligence Development Studio and Visual Studio 2008 Service Pack 1

-OR-

·         SQL Server Data Tools and Visual Studio 2010
·         On the Microsoft SQL Server 2012 Express download page, download the following files appropriate to your CPU architecture and language:
·         ENU\x64\SQLEXPRADV_x64_ENU.exe
·         ENU\x86\SQLEXPRADV_x86_ENU.exe
·         Select the "SSDT" or "SQL Server Data Tools" installation.
2011
The following components are required:
·         Business Intelligence Development Studio and Visual Studio 2008 Service Pack 1
-OR-
·         SQL Server Data Tools and Visual Studio 2010
·         From Microsoft SQL Server 2012 Express download page, download the following files appropriate to your CPU architecture and language:
·         ENU\x64\SQLEXPRADV_x64_ENU.exe
·         ENU\x86\SQLEXPRADV_x86_ENU.exe
·         Select the "SSDT" or "SQL Server Data Tools" installation.

Download Reporting extension for Dynamics 365, 2016

Download Reporting extension for Dynamics 2015

Download Reporting extension for Dynamics 2013

Download Reporting extension for Dynamics 2011


Wednesday, July 12, 2017

Dynamics CRM DateTime format filter in web API

Dynamics CRM DateTime format filter in web API:
function getODataUTCDateFilter(date) {
   var monthString;
   var rawMonth = (date.getUTCMonth() + 1).toString();
   if (rawMonth.length == 1) {
       monthString = "0" + rawMonth;
   }
   else { monthString = rawMonth; }
   var dateString;
   var rawDate = date.getUTCDate().toString();
   if (rawDate.length == 1) {
       dateString = "0" + rawDate;
   }
   else { dateString = rawDate; }
   var hourString = date.getUTCHours().toString();
   if (hourString.length == 1)
       hourString = "0" + hourString;
   var minuteString = date.getUTCMinutes().toString();
   if (minuteString.length == 1)
       minuteString = "0" + minuteString;
   var secondString = date.getUTCSeconds().toString();
   if (secondString.length == 1)
       secondString = "0" + secondString;
   var DateFilter = "datetime'";
   DateFilter += date.getUTCFullYear() + "-";
   DateFilter += monthString + "-";
   DateFilter += dateString;
   DateFilter += "T" + hourString + ":";
   DateFilter += minuteString + ":";
   DateFilter += secondString + "Z'";
   return DateFilter;
}

"IN" operation in fetch XML on Lookup control AddPresearch

"IN" operation in fetch XML on Lookup control AddPresearch


In the account lookup filter two(n of account) account name:
<filter type='and'>

<condition attribute='name' operator='in'>
<value>Test</value>
<value>ABCD</value>
</condition>

</filter>