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...
