Tag
As you might know MSDyn365FO’s data access layer pretty different from T-SQL. This means that if you copy a query on AX and paste it in SSMS it won’t validate in the 99% of the cases (the other 1% being a select * from table).
In Microsoft Dynamics 365 for Finance and Operations we can execute the CRUD operations from code in two different ways, record per record or set based . Microsoft’s recommendation is to always…
There’s no mystery here but a misperception. Recently, a colleague found a little issue when using an AOT query to feed a view with a range dynamically filtered using a SysQueryRangeUtil method.…