January 11, 2021

Computed columns in Views - Dynamics AX

Hi Folks, 

I came across a useful blog on Computed columns in Views - Dynamics AX, however, its written for AX 2012 but fits pretty well with Dynamics 365FO as well. 

Have a look. 

Computed columns in Views - Dynamics AX 2012

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix : Error on Data entity


Error message: 

Severity Code Description Project File Line Suppression State
Error Infolog diagnostic message: 'Datasource name <EntityName>not found in the view <EntityName>.' on category 'Error'. 0


Possible cause: Check if you are using any calculated field and that method for the field is calling the wrong entity. Also, check if it points to the wrong data entity method. 
Below is the syntax


 dataEntityName      = tablestr(<EntityName>);
        Filed1 = str2Int64(SysComputedColumn::returnField(DataEntityName, identifierStr(<Datasource name>), fieldstr(<Datasource name>, CustTransRecId)));
       


-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta