Alfasith AX

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

Monday, June 8, 2015

To flush out all temp files like AOD, Data, Dictionary & Reports server in AX 2012

Hi,

Run following menu items.

1. Go to AOT\ Menu items\ Action.

1. SysFlushAOD
2. SysFlushData
3. SysFlushDictionary
4. SysFlushReportServer

Regards,

How to get the particular field value( not as dataset field) in SSRS

Hi,

 Add the below expression with your textbox name in the field you want.

=ReportItems!Textbox157.Value/ReportItems!Textbox151.Value

here TextBox157 is my field name.

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...