Need to add a SQL Server function to make some smart calculation into a D365FO AOT View based on Query? In this example I will show how to do that. I will use the FORMAT date function to convert a simple date in YYYYMMDD format First of all you must have a view based on … Continue reading AX / D365FO – Use a SQL Server function in an D365FO View
Category: View Computed Column
AX / D365FO – Export Data Entity Enum fields labels in BYOD using Computed columns or Virtual fields
When you export a Data Entity in BYOD the base enums fields values are shown as integer values. This is a big problem because it's very difficult to understrand the real value of the field. To solve this issue you can extend the standard data entity or modify a custom one using a virtual field … Continue reading AX / D365FO – Export Data Entity Enum fields labels in BYOD using Computed columns or Virtual fields
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 – X++ – Computed columns and virtual fields in data entities
This article provides information about computed and virtual fields, which are the two types of unmapped fields that a data entity can have. The article includes information about the properties of unmapped fields, and examples that show how to create, use, and test them. The sample code is targeted towards creating or modifying an entity … Continue reading AX – D365FO – X++ – Computed columns and virtual fields in data entities
D365FFO – AX – X++ – Walkthrough: Add a Computed Column to a View
This walkthrough describes how you can add a computed column to a view in Microsoft Dynamics AX. A computed column is the output of a computation that inputs a regular column. For example, suppose your table has a column that is named AnnualRent. Your view could return a computed column that is named MonthlyRent and … Continue reading D365FFO – AX – X++ – Walkthrough: Add a Computed Column to a View
AX / Dynamics 365 For Finance and Operations blog 