Today we face an error on our client environment that when we run the report Customer Account Statement shows error in info box as.
Stack trace: Field ‘abcd’ in table ‘CompanyInfo’ has not been explicitly selected.
Stack trace
(C)\Classes\CustAccountStatementExtController\setCommonData – line 29
(C)\Classes\CustAccountStatementExtController\runPrintMgmt – line 76
(C)\Classes\SrsPrintMgmtController\run – line 14
(C)\Classes\SysOperationController\startOperation – line 10
(C)\Classes\SrsReportRunController\startOperation – line 12
(C)\Classes\SrsPrintMgmtController\startOperation – line 14
(C)\Classes\SrsPrintMgmtFormLetterController\startOperation – line 14
(C)\Classes\CustAccountStatementExtController\main – line 6
After searching I found reply on Dynamics Ax forum by André Arnaud de Calavon where he gave the link Dick Wenning post, Hat off for them.
http://www.axstart.com/unretrieved-values-on-the-companyinfo-table-in-ax-2012r2/
Problem was in company info table value of “abcd” is null, and by unknown reason Ax did not recognize null value and show as Un retrieve. Due to this error report did not works. I found there are many other fields’ in a row are un-retrieve.
Solution open Sql server and run update query on Dynamics Ax 2012 Database ie. MSDynamicsAX or it depends on installation of Dynamics Ax 2012,
Update table CompanyInfo set “abcd”=”” where Name =”us01”.
Cheers, report run successfully.