Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

Code to approve bom for product in Ax 2012.If you are creating or uploading bom list by code then auto approval may required,below code will help to approve bom item automatically. void God_setBOMActive(BOMId bomid,str 20 approver1) { BOMVersion BOMVersion1; BOMApprove bomApprove = new BOMApprove(); RecId approver = HcmWorker::findByPersonnelNumber(approver1).RecId; boolean ret=true; try { select forUpdate BOMVersion1 where BOMVersion1.BOMId==bomid; BOMVersion1.selectForUpdate(); BOMVersion1.Approved = true; BOMVersion1.Active = true; BOMVersion1.Approver = approver; ttsBegin; BOMVersion1.write(); ttsCommit; bomApprove.init(); bomApprove.parmApprover(approver); bomApprove.parmBOMId(bomid); bomApprove.run(); } catch { info(strFmt("(%1) approval failed.", bomid)); } }

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();