Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, June 11, 2014

Error: The query could not be processed. The field(s) salesTableTmp.AddedFiled do not exist in the report provider table salesTableTmp. in Dynamic Reports.

Hi,

Error:
The query could not be processed. The field(s) salesTableTmp.AddedFiled do not exist in the report provider table salesTableTmp.

When opening the customized standards reports like SalesInvoice, PO etc. above error will be prompted sometimes.

Solution:
Synchronize the table used for DP tmp table and restart the reporting server.
The error will be cleared.

Regards,

Error: Parameter _reportName cannot be null or empty. SSRS in Dynamic AX

Hi,

"Parameter _reportName cannot be null or empty."
The AssetBasisRdlContract.getAttributes() reflection API could not create and return the SrsReportNameAttribute object. Please check the parameters."

This error will be prompted on opening any reports / it can be standard or customized.
Solution:
 Need to compile class AssetBasisRdlContract
 If compile some time it may again show some other class again so it will chain.
permanent solution is full compilation of all the class(standard).

Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...