Skip to main content

Posts

Top 10 Myths about Dynamics 365

Myth 1: Microsoft Dynamics MICROSOFT DYNAMICS CRM is slow. Microsoft has committed a great deal into its server farms and into the technology supporting the environments. Users will find an immediate response time with MICROSOFT DYNAMICS CRM whether in their browser, mobile app, or outlook. Speed is only subject to the user's local internet bandwidth and computer specifications. Myth 2: A company cannot have separate environments with MICROSOFT DYNAMICS CRM. MICROSOFT DYNAMICS CRM can be deployed online just as it is on-premise. For instance, organizations can have development, staging/testing, and production environments. Microsoft includes additional environments at different tiers based on the number of user licenses. The first tier starts at 25 users in which a development environment is included at no additional cost. There are capabilities to copy configurations from one environment to another enabling classical developmental methodologies. Myth 3: Data is not se
Recent posts

Error 1064: An exception occurred in the service when handling the control request

I was working on the Dynamics 365 Finance and Operations environment with Platform update 30, and I had removed a model from my Dev VM. After that, I noticed that batch jobs were not running, and the service 'Microsoft Dynamics 365 Unified Operations: Batch Management Service' was stopped. When I tried to start the service, I encountered the following error: Services Windows could not start the Microsoft Dynamics 365 Unified Operations: Batch Management Service service on Local Computer. Error 1064: An exception occurred in the service when handling the control request. There were also some error messages in the Event log: Faulting application name: Batch.exe, version: 7.0.6651.92, time stamp: 0xa0847b19 Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0x80131623 Fault offset: 0x00007ff9311594e3 Faulting process id: 0x1fd0 Faulting application start time: 0x01d9c6e9e907759b Faulting application path: K:\AosService\WebRoot\bin\Batch.exe Fa

Disable Section Fields Javascript Model Drive App | Dynamics 365 CRM | Power App

This is JS to disable the section attributes function disableSec(executionContext) { disableAllControlsInSection("invoice information", executionContext); } function disableAllControlsInSection(sectionLabel, executionContext) { var formContext = executionContext.getFormContext(); var tabs = formContext.ui.tabs; for (var i = 0; i < tabs.getLength(); i++) { var tab = tabs.get(i); var sections = tab.sections; for (var j = 0; j < sections.getLength(); j++) { var section = sections.get(j); if (section.getLabel().toLowerCase() === sectionLabel.toLowerCase()) { //debugger; if (formContext.getAttribute("statuscode").getValue() == 4) { DisableForm(formContext); } } } } } function DisableForm(formContext) { formContext.ui.controls.forEach( function(control, index) { if (control.g

Delete duplicate records from the table SQL

 WITH cte AS (        SELECT [ITEMID]       ,[PURCHPRICE]       ,[RETAILAMDISCOUNTTYPE]       ,[CURRENCYCODE]       ,[PURCHDISCPERCENT]       ,[SALESPRICE]       ,[VENDACCOUNT]       ,[FROMDATE]       ,[TODATE]       ,[RETAILPRICECHANGESTATUS]       ,[GROUPID] ,        row_number() OVER(PARTITION BY [ITEMID]       ,[PURCHPRICE]       ,[RETAILAMDISCOUNTTYPE]       ,[CURRENCYCODE]       ,[PURCHDISCPERCENT]       ,[SALESPRICE]       ,[VENDACCOUNT]       ,[FROMDATE]       ,[TODATE]       ,[RETAILPRICECHANGESTATUS]       ,[GROUPID]  order by [ITEMID] ) AS [rn]        FROM [ RETAILPRICECHANGETABLE ]     )     DELETE cte WHERE [rn] > 1  

Some use full Javascript Dynamics 365 CRM, Power Platform Model Driven App

Open Main View from the JavaScript  var pageInput = {     pageType: "entitylist",     entityName: "dag_wfacompositeentity" }; Xrm.Navigation.navigateTo(pageInput).then(     function success() {         // Run code on success     },     function error() {         // Handle errors     } ); Refresh the page after 10 second Dynamics 365 CRM JavaScript   setTimeout(function refreshPage() {     Xrm.Utility.openEntityForm(formContext.data.entity.getEntityName(), formContext.data.entity.getId()); }, 10000); Call Power Automate from the button click JavaScript Dynamics 365 CRM, Power App , Model Driven App var flowUrl = "https://prod-85.westeurope.logic.azure.com:443/workflows/7174dc80ca8745e9a52a459129642f7c/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=PRK-k8dNT-w_wtt22xnm-6RB6w7AJUsHRls6iZq-xUU"; var input = JSON.stringify({     "TrackingId": _TrackingId,     "Comment": _comment,    

Dualwrite tips and tricks

Development Guide Dual Write   Prerequisites  Finance and Operations apps that have build version 10.0.9 (10.0.383.20013) (Quality update) and platform update 33 or later Model-driven apps in Microsoft Dynamics 365 that have platform version 9.1.0000.11732 or later Entity Creation I’m assuming that you have already setup and configured Dual-Write in your D365 FO and Dataverse (CDS) environments. Furthermore, required entities are already created in FO and Dataverse (CDS) applications and fields are also added as per the following data type mappings. MS D365 FO Field Type MS Dataverse Field Type String Text String (Memo) Text (Multiline) Base Enum Choices Boolean Yes/No Integer / Real Decimal Date Date Only Date Time Date and Time Create Integration Key It is very important to properly create and configure table key in MS Dataverse as per F&O entity key to avoid below error during mapping. Mapping is missing for integration key - Requisition Number Following are the steps to cre