Category Archives: Dynamics 365
Integration of Teams with Dynamics 365 for Custom Entities using Postman
In this blog we will see how to integrate teams with Dynamics 365 for custom entities using Postman. Solution Step 1- Go to portal.azure.com and select Azure Active Directory. Step 2- On App Registration, click on new registration Step 3-Register an application and follow the steps: Name, Select Multitenant, Enter the required url. Then, click on register. Step 4- Add API permissions and add a permission. The request API permission window will appear where you need to select Dynamics 365. Step 5-The permission window appears and select Dynamics 365 Step 6- As you select Dynamics CRM you will be presented the permission window. Select “Delegated permission” and check the User Impersonation then click Add Permission button. Step 7- After permissions assigned, Grant admin consent confirmation: Click on yes. Step 8- Go to Manifest and change “allowPublicClient”: true Step 9- Go to Overview, save client ID Variable Name URL url https://Dynamicsurl.dynamics.com/ Version 9.0 Webapiurl {{url}}/api/data/v{{version}}/ Client ID Client ID from overview callbackurl http://localhost authurl https://login.microsoftonline.com/common/oauth2/authorize?resource={{url}} Step 10- Go to Postman, create a new environment and enter all the details in the table Step 11- Now connect to the environment from top right most corner. Step 12- Then create a new request Step 13-Include the following in body: Put status as Enable: true Logical Entity Name: Schema name of the entity. Step 14- Go to Authorization From the Dropdown Select OAuth 2.0.Now we will provide the variable values to generate token. Give a name of token Choose Grant Type Implicit and provide corresponding variables for Callback URL, Auth URL and Client ID. Then click Get new Access Token. Now click on Get New Access Token Step 15- Now click on Get New Access Token Step 16- It will prompt you to login Dynamics 365 after you provide your authentication the token will generate. Step 17- Now, click on use token. Step 18- Click on send button Step 19- Now, collaborate button will be visible in ribbon for required entity. Hope this helps!!
Share Story :
Issue in receiving purchase order in D365 finance and operations
In this blog, I am going to showcase how to resolve the issue in purchase orders at the time of receiving. Once the purchase order is confirmed and try to receive it, you may run into the below error. This issue is happing because purchase order lines are not updated properly. When you are received the purchase order line using excel add-in, the purchase order line will not be imported properly. Use data entity in data management to import purchase order line. Steps to resolve this issue in the purchase order. Open the purchase order. Select the purchase order line for which you are facing this issue. In the line details, Check the inventory quantity. The quantity must be there, you will face this issue because the inventory quantity is blank. If the Inventory quantity is blank, then click on the Purchase order tab and make a change request. Click on edit and update the inventory quantity, according to purchase order line quantity, and Save the purchase order. Confirm and again try to receive the Purchase order. In the receive tab, click on the product receipt. If you are facing this issue for multiple purchase order lines then cancel that Purchase order. Create a new PO and import the purchase order line with the data entity. Hope this helps!
Share Story :
Issue in Payment Method in D365 Commerce (Retail) POS
In this blog, I am going to showcase how to resolve the issue in Payment Method on Retail POS. When a customer will come to the shop and want to buy an items with a different payment methods like check, currency then getting the above error on the POS. This error occurred because, in the payment, Some configuration was missing. Steps to identify the missing configuration in the Payment method. Go to all stores and select the store for which you are facing this issue. Click on Payment method. Select the payment method for which you are facing this issue. In the General tab, the operation name must be there. In the Posting tab, all the account number must be setup. Save and Go to Channel Database and run full sync for 1070, 1090, and 1110 jobs. This will take 15-20 minutes to save the data. Refresh the POS link and this issue will resolve. hope this helps!
Share Story :
Integrating Microsoft Teams with Dynamics 365
In this blog we will see how to integrate Microsoft Teams with Dynamics 365 Solution Step 1- To enable Microsoft Teams in D365, Go to Settings –> Administration –> System Settings –> General Tab and flip the below highlighted options to Yes. Step 2- Once done, we’ll be able to see Collaborate button on the ribbon Step 3- Open a record and click on Collaborate Step 4- On Collaborate with Microsoft Teams window, you will see one of the following: If there’s no channel: You can connect the current record or view to any team channel by selecting, Get started. If there is channel that’s already connected: Select a channel from the list and then select, Start collaboration. This will open Microsoft Teams and navigate to the channel that you selected. Or, connect the current record or view to a new team channel by selecting, Create a new connection. Then click on start collaboration. Step 5- Add Dynamics 365 from + button
Share Story :
Import Bulk Data using Excel Template in Microsoft Dynamics 365 CRM
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 !
Share Story :
Quick Tip – Enable/Show Activities on Notes in D365 CRM
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
Share Story :
Use of shared shift in a store with two or more terminals in D365 for Retail
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.
Share Story :
Reopen Closed Appointment Using JavaScript in D365 CRM
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.
Share Story :
C# Code to retrieve lookup value id from target entity in D365 CE.
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 !
Share Story :
How to work with Drop Shipments in Business Central?
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!
 
								 
															