AX/365 F&O Development learning and sharing

  Before the introduction of Dynamics 365, the earlier versions of Dynamics AX consisted of an Application Integration Framework that enabled seamless integration of AX with other applications. The feature – that allowed transfer of data in a SOAP format between applications – has since been deprecated from D365 Finance and Operations (D365FO). Instead, a new type of integration has been introduced in the form of  OData  Services. OData or Open Data is a standard protocol based on the Representational State Transfer (REST) for creating, reading, updating, deleting, and consuming data. By applying web technologies such as HTTP and JavaScript Object Notation (JSON), OData enables integration across products and provides user access to information from various programs. OData Authentication All the new services launched under OData use OAuth 2.0 for authentication.  There are two approaches for the authentication:  1) a native client application that requires a use...

  AX/D365 Technical Blog: Error importing database: could not load package from dynamics 365 'D:\Exportedbacpac\swelltestupgradebackup.bacpac'. File contains corrupted data. (rahulmsdax.blogspot.com)

Move database from sandbox to development in D365 Finance and Operations MS Reference: Export a copy of the standard user acceptance testing (UAT) database

  How to delete workspace from TFS Visual Studio | CloudFronts

  Login to  https://portal.azure.com/ Search for the logic app in the search bar in the top header. Click on Add. After clicking on Add, you will see two options one for consumption and the other for Preview. Click on the consumption a create new form opens. Select Subscription, here I selected  Dynamics. Select Resource group, here I created a new Resource Group with the name  D365Automation. Enter a Logic App name in my case it is  SendEmailOnAccountCreation. Select the location, here I selected East US 2 . Now, click  Review + Create.   After, clicking  Create  Deployment of app starts. Post-deployment completion you will be redirected to the App overview page.

There are two ways to deploy the SSRS reports in D365 for finance and operation. The first choice would be to deploy the report directly from Visual Studio. Open the Build menu, click Deploy. Alternatively, in Solution Explorer, right-click the report project and then click Deploy. In Solution Explorer, right-click the report and then click Deploy Lastly, we can deploy the reports using PowerShell. Open Windows PowerShell in Admin mode and execute the below commands as per requirement. For deploying all SSRS reports K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation “K:\AosService\PackagesLocalDirectory” For deploying the specific report K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -Module ApplicationSuite -ReportName <ReportName> -PackageInstallLocation “K:\AosService\PackagesLocalDirectory” (Replace <ReportName> with required report name such as Reta...

There are many ways to integrate with D365F&O OData is one of them. This post show you how to do simple integration.  Simple architecture  of OData with 3rd party application There are 3 main steps: Create a table, data entity, and OData service endpoint  Register and prepare (OData client) application authentication in AAD and D365FO Create OData client application  Create a table, data entity, and OData service endpoint First, we create a sample 'MyCar' table. CarID, BrandName, SerieName and Color declared as string, Price as real, and PurchasedDate as date. Then create an index for CarID and set that index to be table's Primary Index.  Then create a data entity. After finished creating, note some data entities, tables, and security privileges are added into project. Now, re-check what we've just created. Table   https://yourboxmainurl/?mi=SysTableBrowser&TableName=MyCar&cmp=DEMF&limitednav=true&lng=en-us OData https://yourboxmainurl/d...