Posts

Showing posts from April, 2017

Get the value of Month or YY in SysComputedCOlumns in AX views

Here is the Code: public static server str WFinvoiceDateMM() {     str sDate =         SysComputedColumn::returnfield(             tableStr (WFSyscoInvoicesV),             queryDataSourceStr (WFSyscoInvoicesQ, CustInvoiceJour),             fieldStr (CustInvoiceJour, InvoiceDate)             );     return 'Month(' + SysComputedColumn::fromUtcDateToDate(sDate) + ')' ; }

SysDictField object not initialized. - Views

One of my Colleague had this issue.. I’m using a View (with some calculated fields), as the source for another View (summed fields, so I’m working with “total” records). This 2 nd View continues to have this error message: SysDictField object not initialized. Stack trace (C)\Classes\SysTableBrowser\AddField - line 32 (C)\Classes\SysTableBrowser\showAutoFields - line 95 (C)\Classes\SysTableBrowser\run - line 67 Solution: Go to the Field Groups and delete the fields that are in the Autoreport and delete the fields that are Autoreport and not in the Field List of the View.