Introduction: There have been instances where we feel the need of deleting some records in bulk. I was looking at options of doing advanced search and saw that there were 500+ records showing up. Also, at a time Advanced Find allows to delete 50 records in one go. We definitely needed a better option and Data Management provided that option to delete records in bulk. Use Case: I created a Project Task in a project. This was the only task in the project on which I booked all the resources in my company for 8 hours per day until dec-2022 from June-2018. There were around more then 500+ allocations done for all the Resources. Somewhere, I figured out that this was not the task I wanted to allocate and then I tried many ways deleting the allocations. Below is what all I tried. Option 1: I tried to open the schedule board and delete the allocations from there from month view. But. Deleting it from schedule board takes lot of time to delete the allocations even for one month and imagine we have so many months allocation to delete. Hence, this was not a feasible option. Option 2: I tried deleting the allocations from Advanced find by selecting the criteria as shown below in the screen shot. But, it allowed me to delete only 50 records in a go which was again an issue. After trying above 2 methods and doing some research we came across Bulk Delete option in Data Management Module. Below is the solution to the issue. Solution: Step 1: login on CRM and navigate to Settings module and Data Management in there as shown below. Step 2: Click on Bulk Record Deletion option. Step 3: Bulk deletion wizard opens Step 4: Define your search criteria that selects the records to be deleted. It is similar to the Advanced Find tool. Step 5: Name the Bulk deletion job and schedule the same. You  can also tick the check box to notify via email when the job is completed successfully. You are done with the process and it will take some time for the process to delete the records. Conclusion: This blog reflects my personal findings and based solely on my experience of using PSA for last 3 years. For those who are looking for a platform that can track and manage the entire procedures of sales and project managements, I would highly recommend them to try Microsoft dynamics 365 for project services automation. According to my opinion, implementation of Microsoft dynamics 365 for project services automation is one of the best things that we did in CloudFronts Technologies. We have gained a lot with this implementation because we save time and money due to easy access resources and ability to manage them.

Introduction: In this article, I will explain the steps to enable on-demand workflows [JG1] in Dynamics 365 for Customer Engagement’s Unified Interface. With the release of D365CE apps version 9.0, Microsoft has introduced a new user experience – UCI, Unified Client Interface, or Unified Interface – which uses responsive web design principles to provide an optimal viewing and interaction experience for any screen size, device, or orientation. The Unified Interface brings an enriched experience to any client who is using it currently. And it is responsive enough to produce similar experiences on browsers, tablets or phones. Now I’ll show you one of the important capabilities needed to run on-demand workflows in a D365CE Unified Interface app. Scenario After clients are upgraded to D365CE V9, users are unable to use “classic app” functionality to run on-demand workflows[JG2] . This proves to be a showstopper since it encompasses routine tasks and is a much-needed feature. Steps: Below are steps to be performed for enabling on-demand workflows. 1. An admin user should enable the “Microsoft Flow” option for all the users.   a. Navigate to users in Office 365. Post the navigation [JG3] and open a specific user.   b. Enable the license for “Flow for Dynamics 365” in the D365 CE plan (shown in the screenshot below). 3. Enable settings to show Microsoft Flow in the sitemap.   a. Navigate to Settings è Administrator è System Settings by System Administrator Role User   b. Open Customization Tab and enable the Microsoft Flow option 4. Navigate to the entity, shown below, for Account access and open the account entity record.   a. Navigate to the Flow button on the ribbon and expand options. You will be able to view all on-demand workflows for the entity under the run workflow header. Conclusion: This process demonstrates how to enable Microsoft Flow settings on specific environments to allow users to run on-demand workflows in UCI apps for D365CE. I hope this demonstration can help to make these processes easier for your team.

Introduction: ERP solutions are complex and hence it is significant for any enterprise to analyse the necessity and extract the complete understanding of the solution so as to derive the full benefits of it internally before it decides to deploy one. Having said this, Microsoft Dynamics 365 is one such platform which rather offers a clarity on the solutions. Microsoft now offers two ERP based solutions on Dynamics 365 Platforms. D365 Business Central D365 Finance & Operations The companies planning to implement D365 ERP need to choose prudently which product will suit their business requirements or best, consult their IT partner for the same. Here is the table comparison of two products which will help the decision makers to take the right decision. I have listed down product features with a general comparison view so that it is easier to understand them in a better way. General Comparison: Product/Feature D365 Business Central  D365 Finance & Operations Multiple Legal Entities Yes Yes Intercompany Postings and Consolidated Statements Yes (only within same country/localization) Yes Complete ERP with – Finance (AR/AP), Manufacturing, Logistics, Inventory, Warehousing Yes Yes Supplier Evaluation Module No Yes Quality Management Module No Yes PowerBI Embedded for Analytics No Yes Dynamics 365 Talent (Core HR, Attract, Onboard) No Yes Dynamics 365 Sales with Integration to ERP No Yes Dynamics 365 Customer Service No Yes Dynamics 365 Marketing No Yes Dynamics 365 Social Engagement (Facebook, Instagram, Twitter, etc) No Yes Dynamics 365 Customer Satisfaction Surveys No Yes Dynamics 365 Customer Support Portal No Yes Mobility (Apps for iOS/Android) Yes Yes Browser-based (Chrome, Edge, Safari) Yes Yes Dev and Production Environments Only Production Yes Minimum User License requirement No Minimum 20 Licensing Cost (US $ per user/month) $100 $200  Module Wise Comparison   D365 BC D365 FOE General Customer Type Small to Medium Medium to Large Deployment Period Short Long   Financial Management Auto Elimination Accounting – Available Consolidation Available Available Budgeting Available(Basic) Available(Advanced) Budget Control – Available Fixed and Variable allocations Available Available Ledger Allocations – Available Fixed Assets Available Available Cost Accounting Available Available Multicurrency Available Available Financial Dimensions Available (Upto 8 dimensions) Available (Unlimited) Multi-company Available Available Multi language Available Available Bank Reconciliation Available Available Electronic Funds Transfer Available Available Global Chart of Accounts – Available Multiple Posting Layers – Available Supply Chain Management Sales Orders Available Available Returns Management Available Available Sales Tax Available Available Purchase Orders Available Available Requisitions Available Available Serialized inventory Available Available Bins Available Available Assembly Available Available Inventory Transfers Available Available Procurement and sourcing – Available Global Customer & Vendor – Available Global Products – Available Advanced Warehouse Management License Plate Tracking – Available Basic Warehousing Available Available Aisle, Rack & Shelf – Available Transport Management – Available Quality Management – Available Warehouse Monitoring – Available   Production Basic Production Available Available Process Based manufacturing – Available Lean manufacturing – Available Multi Plant & Multi Schedule Planning – Available Human Resource Employee Master Available Available Recruitment Process – Available Attendance – Available Payroll – Available Performance – Available Training – Available Skill Sets – Available Project Management Job Costing Available Available Project Accounting – Available Employee Timesheets Available Available Employee Expenses – Available Schedule Board – Available System-wide Capabilities Office 365 Integration Available Available Microsoft user interface Available Available Workflows Available Available Web/mobile client Available Available E-mail Integration Available Available Document Management Available Available

Introduction: I have worked on several D365 Retail implementation projects. The largest one being for one of the clients in South Asia who was a sports goods retailer and owned several stores across the region. Just in case any body needs introduction, Dynamics 365 for Retail provides mid-market and large retailers with a complete head office and point of sale (POS) solution that includes support for online and brick-and-mortar stores. It can help retailers increase financial returns, improve service, manage growth, reach customers, and streamline efficiencies. A lot of retailers approach us with the requirements related to the induction of Coupons in Retail stores. It is a set up that is done to provide coupon in Retail stores. For this, I have decided to list down detailed process of the Store code set up Manual. Store Code Set up Manual Process: Step1: Create Barcode Mask Character for Coupon Code: Step 2: Create a New Barcode. Mask set up. Keep the type as Coupon. Step 3: Create Bar Code for Coupon. Assign the Mask ID which was created in step 2. Step 4: Create Number Sequence for Coupon Code ID and Coupon Number. Step 5: Set the Retail Parameters for Coupon. Assign the Mask ID that was created. Step 6:  Create a New Discount. Mention the discount Price, Products in Lines, Price group, Valid Discount Account and enable coupon code required. Step 7: Create a new Coupon. Mention the usage limit, usage type, associate discount to the coupon, Create a new line for coupon. Activate the Coupon. The Barcode will be generated. Make a note of the Barcode.   Next, To Redeem the Store Coupon Code: Scan the product that is under Discount. Scan the Barcode or Manually inter the Barcode. The discount will be applied to the product along with the discount name. Make Payment. This is it! Hope the above information helps! 😊

Introduction: A very handy approach for admins and users of Dynamics 365 who want to bulk clean up field values – And just selecting them in Bulk Editing them as shown below doesn’t help!! So here’s the scenario – You want to clear the selected records for their Credit Score field. Because primarily, you can commonly put a value in a field using Bulk Edit, but not clear the value. Workaround: What you can do instead, create a quick and simple workflow to clear the field. 1. Create an On-Demand workflow on Contact entity with an Update step for Contact 2. In the Update step, point to the field and then select the Operator on the right hand side to select Clear. 3. Make sure the Clear appears on the field you want to Bulk Update. 4. Once done, save and Activate the workflow. Run on the selected records you want to clear at once. 5. The values will not be cleared for these records. Hope this helps!

Introduction: This blog explains how we can add files from D365 Portal directly into SharePoint which was long awaited feature missing from Portals. Below are the Steps: Step 1: Set up SharePoint integration from Portal Admin Center 1. Go to the Dynamics 365 Administration Center page and select the Applications tab. 2. Select the name of the portal for which you want enable SharePoint integration, and then select Manage. 3. Click on Set up SharePoint integration –> Enable SharePoint integration. 4. Click on Enable button it will then ask you to sign in again. 5. Enter D365 CE (MS CRM) credentials to sign in again. 6. Click on Accept to grant the required permissions. 7. You will get the below message. Step 2: Enable document management for entities (Customization in D365 CE) NOTE: If document management is not enabled already then follow below steps. Go to Settings –> Document Management –> Document Management Settings Select entity Click on Next and Finish. Step 3: Configure the appropriate form to display documents We need to add Document Location subgrid in the form which will get displayed in portal. (NOTE: Add subgrid on Edit form to edit the record in portal only.) Step 4: Creating and Assigning Entity Permissions. 1. Create entity Permission of Scope “Global” for Case (Incident) Entity. 2. Click on “+” to Add Child Entity Permission for “Document Location”. 3. Click on “New”. 4. Enter below details. Entity Name: Document Location Scope: Parent Parent Entity Permission: Case_Global(Select the name of parent entity from lookup) Parent Relationship: Select the name from drop down. Select all the Privileges. 5. Save the record. 6. Your Global Entity Permission should look like below. 7. After Creating Entity Permission successfully assign web role to the entity permissions. Sign in to Portal 1. Open any Case record. 2. You can see Document Section below from where you can “Add files” or Create “New folder” 3. Click on “Add files” button you are shown a pop-up window from where you can choose the files to upload. 4. You can see the New Folder is created in SharePoint for that Particular Case and file is also uploaded inside respective folder. 5. Click on “New Folder” to create new folder this will get created inside the parent folder “Case_CaseGUID” in SharePoint. 6. From portal you can go inside the folder and then upload files which gets uploaded inside the respective folder in SharePoint. “Add Files” in newly created folder. New Folder and Files in SharePoint.

Introduction: This blog explains the steps on how to enable OnDemand Workflow in D365 CE UCI Apps. Scenario: After clients are upgraded to D365 CE V9 version, Users are unable to use Classic App functionality to run OnDemand Workflows which was showstopper since it was routine task and much needed functionality. Steps: Below are steps to be performed for enabling functionality 1. Admin user should enable the “Microsoft flow” option for all the users. Below are the steps: Navigate to the ‘users’ in Office 365. Post navigation, open a specific user. Enable license for “Flow for Dynamics 365” in D365 CE Plan. (below screenshot for reference). 2.  Enable setting to Show Microsoft Flow in Sitemap. Navigate to Settings → Administrator →System Settings by System Administrator Role User. Open Customization Tab and Enable Microsoft Flow option. 3. Navigate to any Entity below screenshot for Account. Open Account Entity record. Navigate to Flow button on Ribbon and expand options, you will view all OnDemand Workflow for Entity under Run Workflow header. Conclusion: This is how enabling Microsoft Flows setting on specific environment allows Users to run OnDemand Workflows in UCI Apps of D365 CE. Hope the above process helps!

Introduction: In this blog we will see how we can create folder structure in SharePoint for Leads when the record is created in CRM using MS Flows Pre Requisites: SharePoint Integration must be enabled for the required entities Implementation Step 1: Here in our Flows we have used “Create of a record(Leads)” as trigger condition. Step 2: Then we create the folder structure in SharePoint using the “Create File” action Here we will create a text file which can be deleted later if not required. Folder Path: /Lead/Topic_toUpper(replace(triggerBody()?[‘leadid’],’-‘,”)) Here “Topic” is Dynamics value and for the record ID copy paste the expression written above in the Expressions tab and add it at the end of the Folder Path. After we have created the folder structure if the file is not required we can delete the text file by adding the delete step as shown below Step 3: We will also store the Folder ID in a variable “FolderId” to use in the later steps Step 4: Now we will create the same folder structure in CRM (Document Location) Here for the parent site or Location we have we have added the GUID of the Parent Document Location site for Leads. We can get this from the URL of the Parent Document Location record from Advanced Find (Document Location Entity) Lead document location record URL: https://org.crm8.dynamics.com/main.aspx?etc=9508&extraqs=%3f_gridType%3d9508%26etc%3d9508%26id%3d%257b1957C431-5F15-E911-A96F-000D3AF29269%257d%26rskey%3d%257bF5B008AC-07D9-4554-8509-2C05767BFF51%257d&histKey=17520860&newWindow=true&pagetype=entityrecord&rskey=%7bF5B008AC-07D9-4554-8509-2C05767BFF51%7d#371473802 Step 5:  Similarly we can also create sub folders within the main folder as per the requirements Hope this Helped!

Often, when a real-time workflow is being executed in the background, users don’t know how long it will take for the processing to finish. setFormNotifications in D365 v9 come handy! Scenario Here’s how I put my scenario – I call the Real-Time workflow using JS, example, on change of a certain field or the JS being called from the Ribbon button. The JS will trigger the Real-Time workflow I have. Now, while the Real-time workflow is running, the user doesn’t know it has been called and should the user retry the same action? Here’s when the form notification is vital. While the processing is happening, the message will remain as a notification on the form. Once the processing is complete, the notification will be cleared. JS Implementation: For the JS code implementation, the function to call the workflow needs ProcessJS which is available on https://github.com/PaulNieuwelaar/ So on the Form, I’ll add my file after ProcessJS file. Here’s the Account Form code I wrote. I created a JS file to call the Real-Time workflow. In the above code, the Xrm.Page.ui.setFormNotification(Message, Type of notification, Unique Identifier); This will set the notification. Page.ui.clearFormNotification(UniqueIdentifier); will clear the notification from screen. Using this, When the Process enters in Processing mode, the message is shown on screen as “Please wait while processing”. And once the execution is finished successfully, the notification is cleared. Similarly, you can even use this approach for WebAPI calls and have clearFormNotification set in the Success/Failure callbacks. Hope this helps!

Anyone who uses a CRM on a regular basis hopes that it will work seamlessly without errors. But from time to time, when creating and qualifying a lead, confusing error messages popup and leave users wondering about a resolution.  A very common error in Dynamics 365 Project Service Automation comes up when trying to qualify a lead using the Project Information form when the lead is type is set as “Work Based.” The popup below shows the error message: This error cropped up after I did the following steps: Step 1: Create a lead with the basic required details Step 2: Ensure the form selected is Project Information form Step 3: The Type of lead field should have the value Work Based Step 4: Save the lead Step 5: Try Qualifying the lead. This will lead to the above error shown in the screen shot. The best way to resolve this issue is to check the parameter settings, shown in the screenshot below. Upon researching the issue, I found that there is an important parameter setting that is missing, which needs to be changed in order to get to a resolution. When the lead is created, even though we do not have a customer specific price list, PSA asks for a default price list, inferring that this could be a potential customer. The go to place where PSA checks the global parameter setting is Project Service–> Parameters. Click on the default organization unit. In my case, CloudFronts Mumbai. Click on the price list tab (shown in the screen shot below) and then click on the add new project parameter Price List button on the grid. A pop-up opens that asks for the price list. Select the price list and save. Now, when you create your lead in the Work Based type and qualify it, the error will not reappear. With these changes, the price list for the organization unit is updated in PSA. Whenever we use the organization unit again for a quote, contract, or project, this price list will be the default setting. Most importantly, the parameter helps to qualify the lead successfully. This process reflects my personal findings, based on my experience using PSA for the last five years. We have benefited a lot from the implementation of PSA, because we save time and money due to easy access to resources and the ability to manage them.