Export data from all legal entities using DIXF – D365 FO
In D365FO, if an export project is created for an entity, it exports the data only from the legal entity for which the user has triggered an export. Setting the property ‘Enable cross-company’ in the base query of the entity doesn`t help here as I observed the same behaviour. The behaviour is decided by one of the property in Data Entity. Check the value of ‘Primary company context‘… Continue Reading...
“Error importing database : could not load the package ” Error in bacpac import
I installed a new VM for the latest PU42 and faced the below error when trying to restore the bacpac. I tried the first option on downloading the latest SQL Data tier Application Framework from the link Now , you will be able to see a DAC folder in either ‘Program Files’ or ‘Program Files (x86)Microsoft SQL Server150’ . Now use this path in import command. The command… Continue Reading...
Append Blob using Http Request trigger in Logic apps
We use logic apps to execute some process as a recurrence or trigger APIs available in external applications. In this post, we are going to see , how to call logic apps from external application (I have used Postman here) . My example described below is simple. Pass a Customer group from Postman which triggers HttpRequest in Logic apps. Upon getting the value of the Customer group, write… Continue Reading AnithaEswaran’s...
Upsert the records using Copy Data tool – Data Factory
In one of my previous blog, I explained on copying the data from D365 to azure DB using ADF`s Copy Data tool. In that example, The tool copies/appends the data as such if there are no indices defined in the target table and throws error in presence of index. Most of our requirements would expect update if the record exists or insert if it doesnt. I am using the same tool but tweaked… Continue Reading AnithaEswaran’s...
CRUD OData Entities – Postman – D365FO
In this post, I will demonstrate CRUD operations for an OData entity in D365FO using postman. Refer to my earlier post to set up postman and now we will proceed to execute these operations using Customer Group Entity. Base syntax for referring this entity in Postman https://D365FOURL/data/CustomerGroups This is not the entity name in FO, but ‘Public Collection Name’ in the… Continue Reading...
Aggregate function in Azure Data factory
This post is about using Aggregate function in ADF. Most of us are aware about using Group by in Aggregate. But we will be facing the issue of displaying other fields which are not included in the Groupby clauses. Let us see how we can bring rest of the fields as well when using Aggregate function. I have a csv file in my storage account which has a list of Accounts and their… Continue Reading AnithaEswaran’s Article on...
Batch job not executing – Ax2012
Batch jobs can create a problem when the database is restored or refreshed from one environment to other environment. Given below the trouble shooting steps and solution to handle this issue. Check if there are any batch jobs in ‘Executing’ state . If yes, cancel them. These jobs consume most of the threads in the system.Check if the AOS is configured as ‘Batch Server’ . This… Continue Reading AnithaEswaran’s Article on...
Connect D365 to Azure DB – Azure Data factory
In this post, I will explain about copying data from CRM to Azure DB . This is done by using COPY DATA TOOL available in Azure Data Factory. Click on ‘Add New Resource’ in ADF. Enter the Pipeline name and description Click on ‘Create New connection’ In the ‘Service and Apps’ tab, select ‘Dynamics 365’ Enter the connection details. In authentication type,… Continue Reading...
Create Azure Data Factory
Given below simple way with screenshots to create a new Azure Data Factory(ADF) from azure portal. Go to portal.azure.com. Select Data factory from Search bar. Follow the steps from the below screenshot Click on ‘Git Configuration’ On clicking Review+Create, the system does the basic validation and throws errors if any. But with the 2 step process, there are not much… Continue Reading AnithaEswaran’s Article on...
The database is in single-user mode, and a user is currently connected to it.
I had this issue when I tried to swap the databases after bacpac restore. “Could not rename the database ‘DbName’. The database is in single-user mode, and a user is currently connected to it” Given below the steps I followed to address this error SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID(‘DbNameWithQuotes’) On executing this statement,… Continue...
Call FO Runnable classes with dynamic parameter from URL – D365FO
We are already familiar with calling D365FO URL menu items or forms or Runnable class. To recap, I am giving few samples below To call Display menu item from URL, https://D35FO/?cmp=EC&mi=SalesQuotationListPage https://D365FO/?cmp=EC&mi=SalesTableListPage To call a form from URL, https://D365FO/?cmp=EC&f=VendTransOpen https://D365FO/?cmp=EC&f=CustParameters To browse the data… Continue...
Date Transformations in Derived column – Azure Data Factory
In my Azure Data Factory journey, everyday is a new learning. Defaulting date to current date is common. I had to requirement to default the date to last date of the previous month. Thus, when I import the data in April month, the date to be set as 31.March.2021 , for May month it will have the value as 30.April.2021 and so on. With Derived column in Azure Data factory, converting the field… Continue Reading...
Data Factory integration with D365FO – Import
In this post, I am going to explain about the import of CustGroup using ADF to D365FO. There are many ways to import data, here I chose OData approach to bring the records. It is also possible to use DIXF which I will explain in next post. Let us start with creating a dataset for CustGroup which is in JSon Format. On previewing the data from the dataset, OData always… Continue Reading AnithaEswaran’s Article on their blog...
Filter expression in Azure Data Factory
If you are working on a bulk data, there is always a need to focus only on a particular set of data. We bring this filter in D365FO using WHERE clause in SELECT statement, do-while loop , DELETE statement etc. It is also possible to filter in Data Factory as well. I will explain in the below section. Create a container in Azure Storage Account and upload a JSON file . In my case, I am… Continue Reading AnithaEswaran’s...
Default a field value in SQL Server
We initialise a field`s value in D365FO / Ax2012 …. (I am saying this as an example since I am from Technical Ax background ) . Similarly, we can also initialise a columns`s value in SQL Server. Use this simple command ALTER TABLE TableName ADD DEFAULT (‘DefaultValue’) FOR FieldName Example : ALTER TABLE workers ADD DEFAULT (‘Ready’) FOR ExportStatus To check if a… Continue Reading...
Delete Sales Order using Postman – D365 FO
Deleting Sales Order from Postman is pretty simple and can be repeated for multiple SOs just by changing SalesId in the parameter of the request. Let us see how this can be done Create an Authorization token. This is described hereThe output of the token will be used in the new request for Deleting the Sales OrderCreate a new Request in the Postman and name it as ‘Delete Sales Order’…. Continue Reading...
Configure POSTMAN for D365 FOTesting
Postman is a handy tool with minimum set up required for testing various APIs. It can be used for various testing scenarios in D365FO – using OData / Data entity / Web services . Before proceeding to post man set up, we need register D365FO application in azure to facilitate Authentication for secured access. Refer my previous post which describes the steps for Azure app… Continue Reading AnithaEswaran’s Article on...
Azure App Registration
Azure App registrations are an easy and powerful way to configure authentication and authorization for a variety of different client types. (for example D365FO , if registered in AD, can be accessed from Postman, Data factory, Logic apps and other external azure apps). When the application is registered, make sure it is in the same Azure AD tenant (An instance of an Azure AD directory is… Continue Reading...
Import Workers D365FO – Inactive to Active status
In order to import the worker using D365FO ,we use the entity HCMWorkerEntity. But on importing the data , you will not find the record in Workers form. It will be directed to Inactive Worker . In this post, I will demonstrate to create the worker (which is Inactive while importing) and then moving them as active worker.. I tried to consume this entity from POSTMAN and created a… Continue Reading AnithaEswaran’s Article on...
Auto-Start Azure VM
We have an option in azure to configure auto shutdown of a VM. But there is no auto-startup. In this post, let us see to setup this option using a simple Runbook. Given below the steps to configure from the scratch Create an Automation account. Make sure the Resource Group and Automation Account are in the same location. If the locations are different , additional… Continue Reading AnithaEswaran’s Article on their blog...
Usage of DIXF method in x++ and security – D365 FO
I had a issue when I called the code DMFUtil::GenerateExecutionId and DMFDefinitionGroupExecution::ExportToPackage in one of my custom class. Export was generating the execution correctly when executed in admin role but it didn`t for a non-admin role. On checking if the role has access to the Data management workspace, the answer was no. So I added ‘Data management Administrator’ role… Continue Reading...
Export / Import attachments in D365 FO – Document Management
Document Management – Storing attachment and notes in D365 FO is a simple and easy go process . More information on configuring Document management is detailed in Microsoft document site. Microsoft has provided an easy way to restore data from Tier-2 environments to other sandbox environments. But Attachment details are not exported in this case. So it would be a tedious job if the… Continue Reading AnithaEswaran’s...
Substring/Replace expression in Logicapps
In this post, let us see how to use Substring and Replace functions in logic apps expression . Let us create a variable and do these functions. In Logic apps design, Click ‘add an action‘ and search for Variables .Select ‘initialize variable‘ Let us take an example to perform a Substring in ‘utcnow()’ function and then perform Replace – to replace the special character on the… Continue...
Get the value of an output array – Logic apps
In order to get the value of the array variable in logic apps, triggerbody() helps. For example , I need to read the value of one of the output variable from BODY section . We can use triggerBody to get the value. Initialise a variable and apply the following In the design view, So , on executing logic apps, we will be able to see the output. Continue Reading AnithaEswaran’s Article on their blog Get the value of an output array...
D365 FO Business Events for outbound to Logic apps
In my previous post , i explained about Business Events and configuring a customised one. In this example, we will see how to use the customised Business event in Logic apps. Go to Azure portal and create a new Logic apps. Select the resource group and give a proper name for our example. Let us call it as AE_BusinessEvent. In our case, there is no recurrence needed. The logic… Continue Reading AnithaEswaran’s Article on...
Business Events to Trigger Outbound from D365 FO
We have number of mechanisms to import the data from external application to D365FO. What if there is a reverse scenario ? Trigger an outbound from D365 FO based on some event in the application. Well, I had such a scenario while upgrading from Ax2012 to D365FO. As we all know, Ax2012 DMF export creates the file in a physical location which can be configured in the system. But this… Continue Reading AnithaEswaran’s Article...
Catch Exception in Logic apps
I had a requirement to trigger a mail alert when Logic apps execution fails. Since there are many actions in my logic apps, bringing an exception for each step looks illogical. We have a setting ‘Configure run-after’ which comes with each action,thus making my job easier With this set up, mail alert is triggered for each failure. Continue Reading AnithaEswaran’s Article on their blog Catch Exception in Logic apps I...
Access OData entities for non-default companies – D365 FO
By default, OData retrieves the data from the default company where the user is mapped to in Users form. In order to get the data from non-default companies, just add ‘cross-company = true’ after the URL and filter. For example, https://BaseURL/data/CustomersV3(dataAreaId=’ABC’,CustomerAccount=”ABC12″)?cross-company=true I tried the same from Postman and got the expected… Continue Reading...
Skip/Bypass validation in DataEntity Import – D365FO
I had a scenario where I need to create the State/County dynamically when importing Customer data. For instance, if the given County/State doesnot exist in the input data, the system should bypass the validation and create it. This will be applied if the State/County is disabled in Address Parameters. I tried the import from POSTMAN with the standard CustCustomerV3 entity… Continue Reading AnithaEswaran’s Article on their...
CoC for Button Click / Enable custom field in Non-Editable datasource – D365FO
I had a requirement to add a custom field in CustPackingSlipJournal form where the field has to be enabled when the button is clicked. So I created a CoC class for the button (not the form ) and placed the logic to enable the field in the form But I had a challenge to enable this field in the form because the datasource ‘CustPackingSlipJour’ is non-editable. In order to enable this after… Continue Reading...
Change standard label names in D365 FO
There are cases where the customer asks for change in the label of product dimensions. Let us take the case where we need to change the label of @SYS Ids . For example, @SYS73726 – Colour @SYS73727 – Size There are 2 ways to address this issue. Creating a label extension and referring the standard label ids with different labels Change the labels of the EDTs of related fields
System.InvalidOperationException using System.Diagonistics – D365FO
I had to spend a day to crack the issue of executing cmd.exe which was giving the exit code as non-zero with System.InvalidOperationExcception. This was my code When I execute this from command line or ps, it gives the expected result. But bringing this in C# or D365 , ended up with above exception. And this is the solution This says the compiler that the arguements to the method is to be… Continue Reading AnithaEswaran’s...
Uninstall/Delete Model- D365 FO
In order to uninstall a model which was deployed through LCS, Stop World wide publishing service , Microsoft Dynamics Batch and Microsoft DIXF services. Remove all the dependancies from the model which is going to be deleted. Delete the model folder from AOSService-> Packages Local Directory Full build the models followed by full Sync. Now if you check in Application explorer, the… Continue Reading AnithaEswaran’s...
Differentiate D365 FO environments URL
We often get confused when we work on multiple environments and end up entering data in wrong environment. I had already given a post to differentiate environments based on colors. This post makes even more easier . Add “Environment Tagger” extension to chrome. Add the URL without Https Check your environment Words speak better than colors , in this case Happy Working… Continue Reading AnithaEswaran’s Article...
File based integration(Import) using Logic apps -D365 FO
In this post , I will brief about the import of Customer Group Entity using Logic apps. Here instead of using data Package, I am using xml file for import. Set up a Recurring job in D365 FO for Customer Group. Make a note of the activity when the recurring job is enabled. Go to Azure portal and create a new Resource for Logic apps. Enter a name and Create. Open the designer and start… Continue Reading AnithaEswaran’s...
Change the label of a dialog field – D365 FO
Without overlayering, is it possible to change the label of a dialog field ? Yes!!! You can do this in Post event handler of dialog method. But I had to chose the option of referring the field name in my code. Given below the code snippet: /// /// Change the dialog label /// [PostHandlerFor(classStr(ReqItemJournalUpdate), methodStr(ReqItemJournalUpdate, dialog))] public static void… Continue Reading AnithaEswaran’s Article...
Add ODataAction in DataEntity Extensions
I tried added a new OdataAction to a standard Data Entity using Extension. But it was throwing the error when I called the action from Postman. Though the system doesnot give any compilation errors, adding Odata action to a standard data entity extension would not work. So either duplicate the standard one or create a new entity to bring your action. After Odata Action is created, do a… Continue Reading AnithaEswaran’s...
Calling a new form method from Extension – using CoC – D365 FO
I had a scenario where I had to call a new method in one of the fields from Vendor Payment Journal Line. The new method exists in Extension class of Vendor Payment journal.(which is a form method). This has to be called in modified method of the field ‘Ledger Dimension’. The steps are as follows [ExtensionOf(FormStr(LedgerJournalTransVendPaym))] final class… Continue Reading AnithaEswaran’s Article on their...
Export/Import/Remove/Audit customized security artifacts
Is there a way to export/import only the customized security objects ? Yes. Security Configuration form has this feature. Navigate to Security Configuration and click on ‘Data’ tab. There are two options . Select Export option and all the roles which were customized with new duties/privileges/tables/sub roles will be exported as xml file. If there are new roles defined, those roles… Continue Reading...
Filter Enum values in form lookup – D365 FO/AX
When an Enum is added to a form control, by default all the enum values are displayed in the form as lookup . There are situations where only few of the enum values are needed. How can we do it? Create a new form and add a new ComboBox control to it. In this post, let us take the enum ‘SalesStatus’. Let us name the control as SalesStatusCombo. 3. As discussed , we are… Continue Reading AnithaEswaran’s...