Dynamics 365 Fiscal Year Settings
In Dynamics 365, you can configure fiscal years. To do this, go to Business Management and select Fiscal Year Settings: From here, you can set up the start date, the template and display settings:
Posts
Azure Active Directory User Joining
When a user is added to AAD, the user will receive an email: Click on the email and provide new login information below: Check email and enter verification code: When complete:
Power BI Featured Dashboard
When you log into Power BI, you are presented with a dashboard before you select any of the other dashboards. This is your featured dashboard. If you have not set a featured dashboard before, it will default to another dashboard. To set a featured dashboard, do the following. First, select the dashboard you would like to see when you log in, and click on the ellipse on the top right: Next, select “Set … Continue reading Power BI Featured Dashboard
Return JSON from WebAPI
In WebAPI, you may want to return JSON instead of the out of the box view, which looks like below: The out of the box code for the controller looks like as follows: To display JSON, change View to Json: In running this, you may get the error: “This request has been blocked because sensitive information could be disclosed to third party web sites when this is used in a … Continue reading Return JSON from WebAPI
Connecting Power BI Desktop to Dynamics CRM Online
To connect Power BI Desktop to Dynamics CRM Online, open Power BI desktop click on Get Data: Filter by Dynamics and select “Dynamics CRM Online”: Enter your OData URL and click OK. This will be in the format: https://*****.crm.dynamics.com/XRMServices/2011/OrganizationData.svc Select Organization Account and Sign In: Then click Connect from the same screen. This will load the entities from CRM.
Publish Web Service to Azure from Visual Studio
To publish a web service from Visual Studio, do the following. You may need to install the Azure SDK for .NET. You can find the download link on the Microsoft website: https://azure.microsoft.com/en-us/downloads/archive-net-downloads/ Select the web service. Right click and publish: Select Microsoft Azure App Service and New: Confirm the details and click Create: Press Publish: A webpage will be created with the instructions: And you can access the web service … Continue reading Publish Web Service to Azure from Visual Studio
Deploy Security Roles Dynamics 365
There are situations where you create security roles in one organization and you need to transfer them to another organization, e.g. a development environment to a production environment. We will go through an example of how to do this. First, create a new security role: Next, add some permissions: Create a new solution and select the new security role: Now, in the destination system, select the security role: The new security role … Continue reading Deploy Security Roles Dynamics 365
Create Record in Dynamics 365 using jQuery
To create a new record of an entity in Dynamics 365, use the code below: var account = {}; account.Name = “Sample Account”; var jsonAccount = window.JSON.stringify(account); if (typeof($) === ‘undefined’) { $ = parent.$; jQuery = parent.jQuery; } $.ajax({ type: “POST”, contentType: “application/json; charset=utf-8”, datatype: “json”, url: Xrm.Page.context.getClientUrl() + “/XRMServices/2011/OrganizationData.svc/AccountSet”, data: jsonAccount, beforeSend: function (XMLHttpRequest) { //Specifying this header ensures that the results will be returned as JSON. XMLHttpRequest.setRequestHeader(“Accept”, … Continue reading Create Record in Dynamics 365 using jQuery
Query Dynamics 365 using jQuery
You can query Dynamics 365 data by using jQuery. Here we will go through an example. We will be connecting to the OData Web service. The URL will be: https://yourcrm.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/ To access the AccountSet data, the URL will be: https://yourcrm.crm.dynamics.com/XRMServices/2011/OrganizationData.svc/AccountSet We can pass parameters to the OData to filter the data if required. Add the following JavaScript code to somewhere in CRM. This will retrieve all accounts using jQuery and display … Continue reading Query Dynamics 365 using jQuery
XMLHttpRequest Explained
The XMLHttpRequest is an API used in modern web browsers. It contains methods that allow communication between the web browser and a web server through JavaScript. Although the name is XML, it can also support JSON. Let’s go through an example of how to use it. First, we will use a previous example where we have a WCF web service set up. This service is then uploaded to Azure so it can be … Continue reading XMLHttpRequest Explained