I was getting following error during customization of Dynamics AX. After some debugging i found that it is due to model. Error can be resolved by updating model. In this blog i am working with smmActivities but it can applied for any table. Goto your table in AOT you will see model name in square…
Month: January 2021
D365FO An error occurred during report data sets execution after adding a new dataset
Hi, A common error in Microsoft Dynamics 365 for Finance and Operations reporting is data set execution problem. It usually occurs after adding another data set to your existing report. The problem is due to caching of previous report state in different programs. One of the following solutions will work for you:Solution 1- Restart report service1.1…
Use X++ wildcard (LIKE and NOT LIKE) in X++ select statement
If you want to use wildcards in an AX X++ select statement (*), you will have to use the LIKE command. The following select statement will find all captions in the batch tasks (BatchHistory) table. For x++ select statements:select firstOnly batchHistory where batchHistory.Caption LIKE “*Test*” For x++ queries:queryBuildRange.value(*Test*); Note the LIKE instead of a ‘==’ and the…
Using Controller Class in Developing SSRS Reports in Microsoft Dynamics AX 2012
Overview Controller class is used to control the report execution as well as preprocessing of the report data. The SSRS reporting framework uses this class to modify the report dialogs, calling the SQL Server reporting services, as well preprocessing parameters for the report. Following are the scenarios where Controller class can be used: Modifying a…