To keep track of all your customer data in one place, you may want to import contacts, leads, or other record types into Dynamics 365 Customer Engagement (on-premises) from other sources, such as from an email program, a spreadsheet, or your phone. In this blog we will be looking on how to import bulk data from excel and populating it in Microsoft Dynamics 365 CRM. Use Case: Importing Bulk amount of Leads into Microsoft Dynamics CRM. Solution: Step 1 : How to download a template for data import Go to Settings > Data Management > Templates for Data Import. Select the entity that you want to import the data for from the drop down list, then click Download. (Note) You can use a text file, a compressed zip file, an Excel spreadsheet, or Excel workbook to do the data import. The template will have the fields of that particular entity as the columns to be filled by the user. Adding all the details for the lead to be imported. Step 2 : How to import leads with a template Go to Settings > Data Management > Imports. Click on Import Data > Browse. Choose the file you’d like to upload, then click Next. In this example, I used Lead.xls. (Note) If you used a template for the lead upload, your data will automatically be mapped. If not, see Above for how to get a template for the upload. 4.) Set the owner on the Review Settings and Import Data screen, then click Submit. Once submitted, your lead will show up on the My Imports leads screen. When the upload is completed, the status will show as “Submitted.” 5.) Open Dynamics CRM to see whether the data has been imported or not as in the excel sheet. You can further use this according to your requirement either to import Accounts, Contacts and for many other Entities related customizations. Hope this helps !

In this blog, we will see how we can show activities on Notes in D365 CRM.  Step 1 – Click on Entity and check marked Activities. Save and publish the Entity. Step 2 – Open Main form where you have added timeline, Double click on timeline notes and mark filter by as Show all. Save and Publish the form. Output before enabling the activities Output after enabling the activities

Introduction: A “shared shift” configuration lets retailers have a single shift across multiple registers, cash drawers, and users. A shared shift has a single starting amount and a single closing amount that are summarized across all cash drawers. In this scenario, a separate cash drawer isn’t reserved for each register. Instead, all registers can share one cash drawer. Note: Before using shared shift make sure that all the existing shifts at all the POS terminals of the store are closed. Steps: Login with user id at the main MPOS terminal. Open a new shift Now login at all the other terminals of the store Select the option: Resume an Existing Shift Perform Sales and other functions on all the devices End of the day before closingthe shifts Make sure that all the users have logged off from the other terminals except Main MPOS. On the Main POS: Close the shift. Using Shared shift all the transactions done across the store would be captured under one shift.

Introduction: When an appointment is closed in D365 CRM, the appointment is not editable. There can be a requirment when Users wish to edit the closed appointment and add some missing data. This can be achieved by adding a new button on the Appointment form. Solution: Add a new button and use below JavaScript. var AppointmentForm = { setActive:function(primaryControl) { var formContext= primaryControl; var status= formContext.getAttribute(“statecode”).getValue(); if (status==1) { formContext.getAttribute(“statecode”).setValue(0); formContext.getAttribute(“statuscode”).setValue(1); formContext.data.save(); } } } To understand the status and status reason details, you can refer the Microsoft document- https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/appointment?view=dynamics-ce-odata-9 Note that, you need to update both statecode and statuscode, trying to update only one will give a system error. Conclusion: You can Activate and edit the appointment, once done user can click on Mark Complete, to close the appointment.

Let us consider below example as use case We have Plugin that triggers on Update of Contact Table and wanted to retrieve Customer related to Contacts. Customer is Lookup field on Contact Table. Hence here our target entity is Contact. Code – Entity targetEntity = (Entity)context.InputParameters[“Target”];   Guid ContactId = targetEntity.Id; Using the above code we get the target entity Contact Guid and now we need to retrieve Customer lookup from the target Entity. var cols = new ColumnSet(new String[] { “parentcustomerid” }); Since we only want Customer lookup from Contact hence retrieving only Customer and you can retrieve columns as per your requirement. Entity parententity = service.Retrieve(“contact”, targetEntity.Id, cols); We have stored Retrieved values in parententity. Guid ParentAccount = ((EntityReference)parententity.Attributes[“parentcustomerid”]).Id; And in above step we get the Guid of Customer. Conclusion – This was simple example of accounts and Contacts, you can use the above code(specify the schema name of lookup field you want to retrieve) to retrieve any lookups from your target entity based on your requirement Hope this helps !

Introduction: Drop shipment is used when the shipping on the items is done from the vendor directly to the customer without the item coming back home to your warehouse and you delivering them. Steps to achieve the goal: To do so first create sales order and then add field drop shipment which is of boolean type using personalize features in business central Add item in sales order line and mark drop shipment if you want that item to be transported directly from vendor to customer Then create purchase order assign vendor to it and then don’t add any purchase lines instead of that go to shipment and payment tab in Ship-to field select customer and then add that customer which you want And go to action tab in purchase order page -> Drop shipment -> Sales Order ->Sales order list window Select the item that you want to get shipped directly and that item will be added in purchase orders line  In order to check the link is established between sales and purchase order. Go to Sales order then in sales order line -> Order -> Drop Shipment -> Purchase orders It will open the corresponding purchase orders which you created And post the Sales order. Conclusion: Thus we saw how we can use Drop shipments in Business Central. Thank you very much for reading my work. Hope you enjoyed the article!

We added a new User in CRM, User has the System Administrator role but still were getting the below error. You do not have permission to view files in this location, Contact your Microsoft team owner or SharePoint administrator for access.  We did check User’s SharePoint access and, but it did not work. Solution – In User entity [OOB], there is OOB field called as “Sharepointemailaddress”.  Add same email id of User -> save the record and it will be resolved. Hope this helps!

Sometimes we may feel the need to copy our data from one Microsoft Dynamics 365 CRM environment into another for scenarios such as moving data from UAT environment to production, copying data from Parent organization to Child, etc. This can be easily achieved by leveraging Tibco Cloud Integration’s simple and no code approach. Following is the method in which we can integrate our data Go to app.scribesoft.com and from the dashboard create a new integration app. Inside the app dashboard click on the Hamburger style button and then click on Create integration Map option In the page that opens up we can name our map as desired. Since I am going to integrate account entity in this tutorial I have named it as account integration. Now we have to add a source connection from which data will be extracted, here we can use existing connectors or create a new connector. After clicking the Ok button the metadata for source connector will load, in the meanwhile we can add Destination connector as well. We have to wait a while until the metadata of both source as well as destination gets loaded. After the connectors get loaded we have to drag the Query block from the source connector to the map designer as we want to Query and get the required entities first. Double click on the Query block and from the entity drop down you can select any entity you want to copy from source to destination, for this tutorial I am selecting Account entity. From the filter tab you can choose to filter records from the entity based on the fields. After adding filters, in order to check if correct data is being pulled from source along with the filters applied click on the Preview Tab and verify the values of the fields of the entity. Validate and click on Ok button. Now since there may be multiple records, for each record in source we have to create a record in the destination for doing this we use For Each loop from the Controls section. Since for each record we found in source we have to create a record in destination we will insert the Create block from destination connector in between the For loop. Now we will double click and open the Create block and select Account in the Destination Connector’s Entity. In the fields tab we will map all the necessary fields required to create an Account in CRM and then click on the OK button. If some important field isn’t mapped correctly it will throw an error during validation. Our map is now ready without any errors we will click on the Apply button and save the map and proceed for debugging. Debugging is important as it helps us to understand the flow of Data and if in case of any errors they can be tracked easily, In the Debug mode click on Start. Click on Next to see step by step execution of the map, and continue to finish running the map. After execution is complete the following window will be shown If you check the destination CRM now you will find the new record has been reflected from source. This was it, in few steps we copied Data from one CRM system to another. Thank you for reading my blog, hope it helped !!

In Microsoft Dynamics 365 Commerce version 10.0.16 and later, Retailers can define multiple modes of delivery that shoppers or sales associates can choose among when they create an order that will be picked up at a store. In this way, organizations can provide multiple pickup options to their shoppers.  For example, many retailers now offer shoppers the choice of in-store pickup or curbside pickup for their orders. Commerce supports the configuration of these different pickup delivery modes. Users can then take advantage of them when they create customer orders in any supported Commerce channel (e-commerce, call center, or store). To use this functionality, turn on the Support for multiple pickup delivery modes feature in the Feature management workspace in Commerce headquarters. After you turn on the feature, additional configuration is required. After you turn on the Support for multiple pickup delivery modes feature, you can define multiple pickup delivery modes in the Pickup mode of delivery grid on the Modes of delivery FastTab on the Customer orders tab of the Commerce parameters page. In store channels, if a customer order for pickup is created through the point of sale (POS) application, the sales associate is prompted to choose among the available pickup delivery modes, if any have been configured. If only one valid pickup delivery mode is available for the channel and item, the sales associate isn’t prompted to select it. Instead, the available pickup delivery mode is automatically applied to the order lines. Hope this helps!

Ability to restrict discount to one or more stores The way this discount works is: If a particular customer buys something from a particular store , only in that case discount is applied. Lets check the setup below All you need to do is enable Match all associated price group button to enable this. And in the price group you need to create a price group for the customer and also for the particular store as you can see below. Such setup will allow only certain customers with student affiliation to get discount at San Francisco store Ability for cashier to remove a periodic discount As a cashier you may come across as scenarios where you will see incorrect system discounts or sometimes the discount amount is so high that it could result in  huge loses. In such cases, this option would be highly useful to remove incorrect or unnecessary discount from a transactions The changes can also be made on HQ but that’s time consuming and its not possible for cashier to make the customers wait while they correct the issue in HQ. Here the Cashier has two options. Remove the discount Add the discount After the discount has been removed, Cashier can add a manual discount percentage and give the correct discount to the customer. Hope this helps