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,

Get a table ID in SQL - D365

Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,