In various ERP implementation & support projects, sometime it is very hard to replicate a production / UAT environment scenario in dev box for debugging or in some cases it is tedious to do any kind of unit testing due to lack of business data. But luckily, we can solve this problem by doing restoration of transaction database backup in your dev box from a UAT or production .In most of cases, developer can only access in his/her development box and developer is not allowed to access in UAT/Production sever . After restoring database backup, developer starts to face issue – “You are not authorized to login with your current credentials. You will be redirected to login page in few seconds” because his/her developer login ID is not available in AXDB D365 FO database .
To solve this issue, Microsoft has provided a tool called – AdminUserProvisioning.exe . After restoring the database from your UAT/PROD server in your development box, you can add your userId in your dev box D365 FO instance.
The path of tool AdminUserProvisioning.exe is C:\AOSService\PackagesLocalDirectory\bin\AdminUserProvisioning.exe
As we know, “InventTrans” table is one of the largest table in Microsoft D365 for finance and operations and this table keep growing through out the ERP lifecycle and consume more space. BUT ! here is the good news that Microsoft has released a standard feature and a standard batch job to archive inventory transactions and purge InventTrans table data.
What is deep links in Microsoft Dynamics 365 for finance and operation? Deep links are shareable and secures URLs to a specific form. Optional filters can be passed so that when user will open the deep link and navigate to a specific form then it will show filtered data ore records. In Microsoft D365 FO, below library – Microsoft.Dynamics.AX.Framework.Utilities.UrlHelper.UrlGenerator is used to generate deep links using X++ .
Sample Code – Below is the sample code of developing & generating deep links for D365 FO forms and records using filter and ranges in form data source. In below example, i am generating the sharable URL (deep link ) of a form – CustAccount and applying a “CustAccount” filter on custTable datasource.
Customer has saved some JSON files in local folder of laptop or server or drive. Customer wants upload the JSON files from local drive to microsoft Dynamics 365 finance and operations for further business process. A dialog will open in Microsoft D365 fin & ops, customer will select JSON files and import.
Error- During the package deployment or applying VSTS/DevOps build package in UAT or Production , below error is coming in LCS (Life cycle services
“The selected package is missing the following modules that are currently deployed on your environment. You must create an all in-one deployable package that contains all your code customisations & ISV solutions.More information can be found at the following link:https://go.microsoft.com/fwlink/?linkid=2118104.Missing module(s) [AcxDocumentReports]“
In Microsoft Dynamics 365 finance and operations, client has an data entity for importing list of customer account into a table.During the time of importing of customer accounts using Data entity, client also want to capture & save values of few fields.
Microsoft Dynamics AX, Microsoft Dynamics 365 for Finance and Operations, D365 FO, Retail, SQL, Microsoft Power Apps, Microsoft Power BI, Microsoft Azure, Logic Apps, Microsoft Flow, Microsoft power automate, Microsoft Power Platform,.Net, X++, C#, Power BI DAX, Data Warehousing, Microsoft Analysis Services, SQL Server Reporting Services