Introduction: While working with Microsoft Dynamics CRM we wanted to make query or advanced find to list down all the account which does not have any opportunity associated to it. But in the dynamics CRM with current or earlier version we cannot write down the simple advanced find query which list down the record does not associate to it. Description: With upcoming update of Microsoft Dynamics 365 CRM, you can perform the Search on that criteria as well. You can design this query in the advanced find. Query: Get all the account which does not have any opportunities. 1. Open advance find and select account entity and in filter select opportunitie in related entities, as show below. 2. You will notice that a new attribute has been added, by which you can apply additional filter on opportunities. 3. Here you need to select the “Does Not contains data”. 4. Now click on result. 5. It will list down all the records which does not have any opportunities as shown 6. Fetch XML: let see what modification has been done in the fetch XML <fetch version=”1.0″ output-format=”xml-platform” mapping=”logical” distinct=”true”> <entity name=”account”> <attribute name=”name” /> <attribute name=”primarycontactid” /> <attribute name=”telephone1″ /> <attribute name=”accountid” /> <order attribute=”name” descending=”false” /> <link-entity name=”opportunity” from=”parentaccountid” to=”accountid” notinvalue=”DoesNotContain” link-type=”outer” alias=”af” /> <filter type=”and” isnotinfilter=”true”> <condition entityname=”opportunity” attribute=”parentaccountid” operator=”null” /> </filter> </entity> </fetch> 7. As you can see that it has an addition filter attribute is added. Query: Get all accounts contains opportunities. 1. Similarly, you can get all the accounts which have opportunities associated to it. 2. Here you need to apply filter criteria as contains data; as shown below. 3. It will list down all the account records with opportunities as shown below. Conclusion: Hope this helps while doing advanced find or designing fetch Xml query.  

D365 Field Service has everything to manage your complex business needs from scratch till the end. On the off chance that Field Service is a fundamental piece of your everyday business, Dynamics 365 for Field Service is a start to finish arrangement that can enable your association to oversee complex assistance understandings, track resources and stock, oversee administration orders, rapidly distinguish and dispatch assets, and addition the insight expected to offer prescient and preventive assistance and backing.  Robotize and improve booking to dispatch the correct professional and get the most incentive out of your assets. Upgrade your administration experience by proactively recognizing, investigating, and settling issues so a specialist is dispatched just when vital. Give clients self-administration entries, proactive updates, and expert following to guarantee a positive involvement with each progression.  Introduction: This blog explains how to embed D365 Field Service Charts in D365 Online Portals. Steps of Implementation: 1. Get Guid of Chart and View used for Chart in D365 Field Service. 2. Create a new Web Template, Portals -> Web Templates and write code in Source field with Chart ID and View ID  as copied in Step 1 as below. 3. Create a new Page Template, Portals -> Page Templates and set details as highlighted below. 4. Create a new Web Page in D365 Online Portals and set Page Template created in Step 3. 5. Create a new Link for Dashboard in D365 Online Portals. Hover Mouse on Home button and click on Edit option. Click on New button as highlighted below. Enter details as shown below and click on Save button. Conclusion: Above description in blog helps users to create Dashboard in D365 Online Portals by embedding D365 Field Service Charts as below.

Introduction: In this blog article, we will see how we can expose standard and custom data entities using OData Client code generator to OData API for CRUD operations. Steps: Install OData Client Code Generator v4 Create new Project Execute the OData Client code. 1. Install OData Client Code Generator v4: Open Visual Studio. Go to Tools -> Extensions and Updates Go to Online Fast Tab -> Visual Studio Gallery -> Type ‘OData V4 Client Code Generator’ Click Download. In the VSIX Installer dialog box, Click Install. After Installation, it will ask you to restart the Visual Studio. Click Restart now. 2. Create new Project: Click on new Project. Go to Visual C# -> Windows -> Select Console ApplicationNote: Client Code Generator can work with any project. Enter details and click OK. 3. Execute the OData Client code: In Solution Explorer, right click the solution. Go to Add -> New Item. Select OData Client. Click Add. You will see 2 files added in the solution. Open the file with .tt extension (Text Template). In the file, update the Metadata URI. Save and execute the .tt file. You can see a .cs file generated under the .tt file. Conclusion: This will generate a code that exposes all the Data Entities of D365 Operations. You can use this generated code for CRUD operations. In the next part, we will see how to use this generated code to read and write data in tables using exposed data entities.

Since this is in Preview, it won’t be available for users until next update. However, this is how it works and seems so easy to implement it. Enable Step Action from System Settings: Since this is a Preview feature in Dynamics 365 July 2017 update, it appears in the Previews section where you can go and enable the same. Once you’ve enabled the Preview feature, you should be able to see Action Step visible in the Business Process Flow editor as shown below: Add Action Step in BPF: You can trigger an Action or a Workflow in the Step Action feature. I have a Workflow to create a New Invitation entity record in D365. I’ll be adding the same in the BPF. In the Business Process Flow editor, I’ll add an Add Action Step in one of the stages as shown below: I’ll add the already created a Workflow to the Business Process Flow in the Step Action. Once done, I’ll simply activate the BPF and we can see it in action. Working with Step Action: Let’s see how easy it is to execute this workflow using the Step Action. On the Business Process Flow, I can see that the step appears from what the Display Name in Business Process Flow is set. And clicking on it, the workflow will run the background performing it’s operation. (You’ll see a quick ‘Processing’) message while it triggers the workflow. As seen below, the record for New Invitation was created as directed in the Workflow I created. Conclusion: Putting it simply, it works very quickly and is as simple as clicking a button.

Introduction: In this blog, we shall see how can a user install multiple Portal Instances for Microsoft D365 CRM Online. Pre-Requisites: D365 CRM Portals D365 CRM Environment Overview 1. A user can set up more than one Portal for a given D365 Environment provided that the second portal is different from the first portal that is installed. For eg: If the user has already installed a community portal then the user will have to install a different type of portal like partner portal , employee portal etc. 2. The user cannot install two portals of the same type. For eg. If the user has already installed a customer portal then he cannot install multiple portals which are customer portals. 3. As we know that a user can have multiple portals associated with the same D365 (CRM) instance and along with a single D365 Subscription the user gets out of the box a single portal license, which means that the user gets only one free portal add-on. 4. The user can go to the Instance page and install multiple portals as shown below in the available multiple options. In order to have a second portal add-on on the D365 instance the user will have to follow the Steps given below: Step 1: Opening the Admin Center.  Go to D365 and open admin as shown below. Step 2: Opening the Purchase Service In the Admin Center Page click on the Billing option in the left side menu bar and select Purchase Services under that. Step 3: Selecting the Subscription In the Purchase Services, we will have to find the following subscriptions which are as follows: Dynamics 365 Enterprise Edition – Additional Portal Dynamics 365 Enterprise Edition – Additional Portal Page Views **Note: These Licenses are only shown to the user if they have a purchased license and are not using trial version of the license

Introduction: This blog explains how to configure Create Customer Assets Page in D365 Partner Field Service Portal. Steps of Implementation: 1. Create a new Entity Form in D365 Field Service. Create a new Form for Customer Asset Entity with name “Portal Customer Asset – Create” and publish as shown below. Create Entity Form with name “Create Asset” as shown below. Open “On Success Settings”, set On Success as “Redirect” and Web Page as “Assets” as highlighted below. Set Submit button on Entity Form, Click on “Submit” Action and enter label as “Create Asset”, as shown below. Create a new Entity Form Data to set “Expose to Customer” equals “True”. Select Type as “Attribute” and select Attribute Logical Name as “Expose to Customer”. Check on “Set Valule on Save”, select Type as “Value” and enter Value as “true”. 2. Create a new WebPage in D365 Partner Field Service Protal. Open Assets Page. Click on New => Child Page in Administrative Panel. Enter details as below and click on Save button. 3. Add Create button in Assets Entity List in D365 Field Service. Open “Assets Customer Web View” record in  Entity List as highlighted below. Open Grid Configuration Section in Options Tab. Create new Action “Create”, Select Target Type as “Web Page” and select Redirect to WebPage as “Create Assets ( Partner Portal )” as shown below. Conclusion: Above description in blog helps users to create Customer Assets from D365 Partner Field Service Portal. Create button on Asset List Page. Create Asset form. New Asset record is shown in list. Blog Tips: How to redirect to page after a record is created successfully by using “On Success Settings” tab. How to set data on record from D365 Portal automatically by using Entity Form Metadata. How to show data created in D365 Field Service Portal as soon as it is created by setting field “Expose to Customer” equals to true.  

For the modern-day organisations that have global scalability and digital intelligence, dynamics 365 for finance and operations is definitely the need of the hour. Make more precise interest estimates to improve your items’ accessibility and limit your stock expenses. The apparatus utilizes Microsoft SQL Server determining calculations, Microsoft Excel perceptions, and Dynamics 365 for Finance and Operations models—for conjectures you can rely on. Get perceivability across associated circulation, client assistance, deals, and promoting frameworks so you can develop your items and procedures to meet rising desires.  Get continuous data on practically any gadget, whenever. Elements 365 for Finance and Operations improves and quickens business process changes. What’s more, it’s situated in the cloud, so it coordinates with inheritance frameworks and scales universally effortlessly Introduction: Job is collectivity of tasks and responsibilities which are required of worker who perform a job. Pre-requisites: Before setup jobs, need to create below elements: • Job Title • Job Function • Job types • Compensation level • Survey company • Skills and skills level • Certificate type • Test type • Education • Screening type • Job tasks • Areas of responsibilities Steps: Below are steps to create department- Click Human resources > Jobs > Jobs. Click New In the Job field, enter a name for the job. In the Description field, type a brief description of the job. In the Title field, select a title for the job. In the Maximum number of positions field, indicate the number of positions that are allowed for the job: Maximum positions – Select this option and enter the maximum number of positions that are allowed for the job. Unlimited – Select this option to indicate that an unlimited number of positions are allowed for the job. In the Full-time equivalent field, enter an employment factor from 0 to 1. The value 1 indicates a full-time job. For part-time employment, enter a number between 0 and 1. For example, enter .5 for a half-time job. In Description Fast tab, enter detail description of the job. Click on the Job classification fast tab In the Job type field, select a job type to associate with the job. In the Function field, select a job function. Click on Compensation fast tab. In the Level field, select a wage level for the job. In the Survey company field, select the survey company that is responsible for the survey that was applied to establish the market-based pay range for this job. In the Reference job field, enter the job code that the survey company uses for this job. In Market Price Range information, specify market based pay range in source field. In Low threshold, control threshold and high threshold, specify minium, basic and maximum amount that paid to worker who assigned for this job. On Skills fast tab, enter skills required for the job. In level field select skills level and in importance field, select importance level (From1 to 6) On the Certificates fast tab, optionally enter certification requirements for the job and importance of the certificate On the Tests FastTab, enter tests for workers are required to pass for the job. On the Education FastTabs, optionally enter educational requirements for the job and the importance of the education. On the Screenings FastTab, optionally enter any screening that workers are required to pass for the job. On the Job tasks FastTab, optionally enter job tasks to the job template. On the Areas of responsibility FastTab, optionally enter areas a worker is responsible for in jobs. Conclusion: By attaching job to position you can assign position to worker and it will help to maintain and track Job tasks, responsibilties, Skills, education, certifications, tests.

Introduction: This blog consists of steps to change the name of the custom app in Dynamics 365. Initially the app name is “Dynamics 365-custom” as shown below. Steps: We can change the name to our organization name as shown below: Navigate to Settings–> Administration–>System Settings In General Tab–> Set options for the default app:Dynamics 365-custom–>Change the default app name The App name is changed to “CloudFronts Apps” and will be visible as below: Conclusion: Like this way, you can change the name of custom application in Dynamics 365.  

Introduction : In AX 2012R3 Commerce Data Exchange, Async Server is a part of the asynchronous system that shares data between the Microsoft Dynamics AX database and channel databases. Async Server is installed at headquarters and communicates with Microsoft Dynamics AX. In addition to Async Server, Commerce Data Exchange includes Commerce Data Exchange: Async Client, which is installed at channels and communicates with the channel database. Below are the steps which need to follow: Step 1: Start Microsoft Dynamics AX Setup. Under Install, select Microsoft Dynamics AX components. Advance through the first wizard pages. If the Setup Support files have not yet been installed on this computer, the Select a file location page is displayed. The Setup Support files are required for installation. Provide a file location or accept the default location, and then click Next. On the Ready to install page, click Install. Step 2: On the Select installation type page, click Custom installation, and then click Next. On the Select components page, select Async Server, and then click Next. Step 3: Prerequisite validation results page, resolve any errors. For more information about how to resolve prerequisite errors. When no errors remain, click Next. Step 4 : Configure Async Server page, select the check box to configure Async Server by using Setup. If you clear this check box, the application files are installed, but Async Server is not configured. If you’re configuring Async Server, enter the following information: Application name – The name of the web application that hosts Async Server. App pool name – The name of the application pool that the web application runs under. Website name – The name of the website that Async Server runs on. User name and Password– The credentials for the application pool identity. HTTPS port – The port on which Async Server receives HTTPS requests. You can specify any available port. Verify that the port is open in Windows Firewall, and record the port number. The port is used to create the URL for Async Server in the following format: https://<server name>:port/<web application name>. This URL is required when you configure instances of Async Client that connect to this instance of Async Server. TCP port (optional) – The port on which Async Server receives TCP requests. Specify a TCP port if your environment uses high-performance data synchronization. You can specify any available port. Verify that the port is open in Windows Firewall. AOS service user – The user account that the instance of Microsoft Dynamics AX Application Object Server (AOS) runs as. SSL certificate thumbprint – The thumbprint for the Secure Sockets Layer (SSL) encryption certificate. You must obtain a valid, registered certificate from a provider. Step 5: Select Server Name and Message Database Name. if DataBase does not exit then mention the Name. Setup will create the database. Step 6: the Prerequisite validation results page, resolve any errors. For more information about how to resolve prerequisite errors. When no errors remain, click Next. Step 7: Click on Install button. Conclusion: By following above steps, you can install Async Server for Retail HQ.

Introduction: Finally, one of the most sought after feature is here in the D365 July 2017 Update. The Multi-Select Option Set! A new attribute type added to D365, you can now create Multi-Level OptionSets in D365. Creating a Multi Select OptionSet: A new attribute type is now available that lets you create Multi-Select Option Set. 1. When you create a new field, you’ll see an option to create a Multi-Select Option Set. 2. Here, I’m creating an Option Set for choice of Subjects for Newsletter Company. I’ve named the field as Subjects and I’ll let users select which all subjects is a particular customer interested in in the Enrollment entity. 3. The Multi-Select Option Set looks like a usual option set and my options look like this 4. And I’ll add the same in my form as well and Publish all my changes. Using Multi-Select Option Set: Below is how you can select multiple values in the Multi-Select Option Set. Once on the form, here’s how you can use the Multi Select Option Sets 1. They come with auto-complete feature, so you can start typing the options and they will show up 2. Now, I have selected 3 options namely Technical, History and Science and my subject of interests. 3. Once selected, they appear separated by semicolon (;) And I’ll save the record. Multi Select Option Set on Views: You can see selected values in the Multi-Select Option Sets on the entity views as well. Some Features: Below are the features of the Multi-Select Option Sets Auto-complete the results. Can hold up to 150 values Can be used in Advanced Find as well as FetchXML queries. Hope this was helpful!