Category Archives: MS CRM 2013

Duplicate lookup reference was found -{Quick Tip}

inspector-160143_640

Introduction While importing data into Dynamics 365 with lookup fields, sometime we get duplicate reference found error, if you are getting same error then here is the quick tip for you . Details While we are importing data into Dynamics 365 CE with lookup field, Dynamics try to relate lookup records based on the primary field name by default. So… Read more »

Create Order Button is Missing on Quote Dynamics 365 CE

Introduction Recently faced one issue where Create Order button was missing from Quote entity form in one of the sandbox environment, I am going to provide step here how I fixed it. Details When we faced this issue in Sandbox environment, first thing I checked if it is available in production or not, and it was there, next thing I… Read more »

Calling Entity bound Actions using Xrm.Web API with Entity Collection

Requirement In this article we are going to discuss about calling entity bound action which have entity collection as parameter, we need to created this parameter from array list, while sending entity collection we need to send customer lookup as well, so let’s see how we can do that. Details Earlier, we discussed about calling out of the box actions… Read more »

Downloading Notes Attachments using Paging

Introduction This article is about downloading Notes attachment from Dyanmics 365. If you have large number of records from where you want to download attachment, you can face different issues like timeout, slow downloading etc. Here I am going to provide sample code which you can use to download attachments from small set of data. Details To download attachment from… Read more »

Copy Phone call field to Case while converting -Nocode Solution

Introduction Today I saw one question on Microsoft Community, which helped me to write this article (If you are still not part of Microsoft Community forum you are really missing lot of learning, this is a great learning source, I have learned a lot from community forums, so join it today to share your knowledge with others and learn from… Read more »

SystemUserAccessMode is not either of (NonInteractive, SetupUser)

While creating work order record, I got following error: “Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The user with SystemUserId=2….. in OrganizationContext=5…… is not licensed, and its SystemUserAccessMode is not either of (NonInteractive, SetupUser)……..” First thing I checked if the current user Access Mode is not set to Administrative or non-interactive as the error message was saying, but it was… Read more »

Query intersect entity and it’s attribute- Sample Code

Introduction When we setup system N:N relationship between two entities an intersect entity is created internally, which is not accessible directly. Let’s say we have N:N relationship between case and workorder entity. And if you will try to see attributes of this entity, you will find following attributes So in case we want to query this entity, we need to… Read more »

No Code solution for Filtering Subgrid based on the Lookup

There is a common requirement to filter subgrid based on the lookup field, but there is no easy way to implement it without writing code. In this post I am going to discuss a quick workaround to implement this requirement. Let’s see how we can implement this. Requirement: We want to show marketing list for accounts in contact form based… Read more »

Re-adding accidently deleted statusreason option- Quick Tip

Requirement: Have you been in a situation where you accidently deleted status reason option from quote entity and now want to add it back as soon as possible?? If yes then this article is going to help you. Solution: While adding options to option set, it’s value is generated automatically based on the option value prefix (You can find this… Read more »