Skip to main content

Posts

Add custom Lookup for Employee id in Ax 2012

By
To Add customLookup for Employee id in Ax 2012 you can try below code sample in datasource filed of the form. You can add data method to lookup easily to get the name of the employee. Here HcmWorker is a master table of employee and personnel number and name is the field of Hcmworker table. SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(HcmWorker),_formControl); Query query = new Query(); QueryBuildDataSource queryBuildDataSource = query.addDataSource(tableNum(HcmWorker)); queryBuildDataSource.addRange(fieldnum(HcmWorker,Tester)).value(queryvalue(Noyes::Yes)); sysTableLookup.addLookupfield(fieldNum(HcmWorker,PersonnelNumber)); sysTableLookup.addLookupMethod(tableMethodStr(HcmWorker,Name)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup();
Read more

Ax 2012 Dynamic or run time Query Range without coding in Reports

By
I am sharing This clip which will show you How to Add Dynamic or runtime Query Range without coding in Report In Axapta. This tips will work in all version of Axapta. Ax versions which are available in Market are from ax 2.5 to Dynamics 365. How to use query range in a smart way to avoid customization and coding. Dynamics ax is very much user-friendly ERP. I hope you will like this tips.
Read more