AX / D365FO – Electronic Reporting Format a Date

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

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