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

[Solved] Table browser not working

Hi Folks,

 Few days back I got a new dev box which was recently rolled out by one of a colleague.  All of a sudden it started behaving strangely. Whenever browsing a table I was getting below error.

 

Access Denied: You do not have sufficient permissions to open the menu item systablebrowser. Please contact your system administrator.

I double checked all the access, I got full admin access on this server but still same issue. This created more confusion when I was trying to run the debugger, I started getting below error. 

Access Denied: You do not have sufficient permissions to open the menu item sysclassrunner. Please contact your system administrator.

So to overcome this issue, double-check if the developer configuration key is enabled, in my case it was disabled and that was the root cause of these problems.

 

Now if you see the message on top of this form (Sysadmin > setup > License configuration) it is saying you cannot edit any record in the form until the server is in maintenance mode.

(See this link for how to enable maintenance mode in D365FO)

So first you need to enable maintenance mode on this server and then enable the development key.

Once than done, make sure you disable maintenance mode. And give it a try now, you should be able to browse a table. ( Also, the debugger is working fine as well 😊 )

Merry Christmas to all. Have a great holiday ahead.

-Harry 

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

QuickFix -16:[Solved] ComputedFieldMethod: Method return type of 'ExtendedDataType' is invalid; expected values(s): 'String'

While adding a computed field and creating a method for the same, getting below error for method. 

ComputedFieldMethod]:Method return type of 'ExtendedDataType' is invalid; expected values(s): 'String'

Solution: You need to double-check the method signature and it must look like below

public static server str myCal()

    {

        str mycal;

//Business logic

        return mycal;

    }

Build your solution and give it a try.

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