In Electronic Reporting you can easily format a Date or DateTime using DATEFORMAT() or DATETIMEFORMAT() Here is an example of how to use it DATEFORMAT needs 2 input parameters : Date (or dateTime in case of DATETIMEFORMAT)format (which is the output conversion format) Code below shows how to convert current date in yyyyMMdd format DATEFORMAT(TODAY(), … Continue reading AX / D365FO – Electronic Reporting Format a Date
Author: Marco Saad
AX / D365FO – Electronic reporting Get current Legal entity name
How to get the Legal Enity name in Electronic reporting? It's easy.. there is a predefined function called "GetCurrentCompany()". You can find it in the formula editor.
AX / D365FO – Electronic Reporting set output file name
By default the name of the electronic reporting output file is made up of : "UserId"+ fixed string ".out". We can change this name in a static or dynamic way. In my case I prefer to set a unique name. For example consisting of : a static prefix (eg. PriceList) + LegalEntity+ execution date / … Continue reading AX / D365FO – Electronic Reporting set output file name
AX / D365FO – Send a message to all online users in LCS #d365fo #ax #msdyn365fo
In LCS you can send a message to online users to warn them that it will not be possible to log into the system in view of an upcoming update. Check online users Login to LCS Open you Project Access Production environment To see the list of online users click on "Monitoring" > "Environment monitoring" … Continue reading AX / D365FO – Send a message to all online users in LCS #d365fo #ax #msdyn365fo
AX / D365FO – Using Cross-Company in Electronic Reporting #ax #d365fo #msdyn365fo
When you associate an Electronic reporting Data Model to a Data Source Table or View you can decide to extract Cross-Company data. When defining the data source just enable "Cross-company" Property
AX / D365FO – Create an AOT View based on a Query #d365fo #ax #msdyn365fo
Create the AOT Query object First of all you must create an AOT Query Open Visual Studio and Add a new Query Item Add new Data source Set Query properties Dynamic Fields > to automatically include all Table fields choose "Yes", otherwise chose "No" to select fields manuallyTable > choose the table of query data … Continue reading AX / D365FO – Create an AOT View based on a Query #d365fo #ax #msdyn365fo
AX / D365FO – Format a date of a View with computed column #d365fo #ax #msdyn365fo
In this example I will create a new computed column that sjows the FromDate field of the PriceDiscTable in a YYYYMMDD format Open the view and add a new string computed column Give it "FromDateStr" name Now create a new method The method must be private static server str fromDateformat() private static server str fromDateformat() … Continue reading AX / D365FO – Format a date of a View with computed column #d365fo #ax #msdyn365fo
AX / D365FO – How to create an AOT view in Dynamics 365
Good post that explains how to create an AOT view in D365FO > https://community.dynamics.com/365/financeandoperations/b/howtodynamics365/posts/how-to-create-view-in-dynamics-365
AX / D365FO – Electronic reportings – Export Data model configurations between environments
Have you just created an electronic reporting report in a development environment and want to upload it to another environment without doing it from scratch? The correct way is to share the data model in LCS, but for testing purpose I'll prefer to expor t the model definition using an XML configuration file. So let's … Continue reading AX / D365FO – Electronic reportings – Export Data model configurations between environments
AX / D365FO – Electronid reporting Text functions
Electronic reporting (ER) text functions can be used to perform operations on data sources of the String data type. This topic provides a summary of these functions. > https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-functions-category-text?toc=/dynamics365/commerce/toc.json
AX / Dynamics 365 For Finance and Operations blog 