Technical Tutorials on MS Dynamics Axapta 2012,D365 FnO

You can clear log for batch job history in Ax by following code. This code can work in most of ax version . If you want to clear  log till some date that you can also specify in query . You can just copy and paste below code run or execute. BatchJobHistory BatchJobHistory; date startDate; TimeOfDay startTime; utcDateTime rangeStart; startDate=mkDate(21,12,2014); startTime = str2time("6:00:00 am"); rangeStart = DateTimeUtil::newDateTime(startDate,startTime); delete_from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart; //select count(RecId) from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart ; // info(strFmt("%1 till cleanup done ",BatchJobHistory.RecId)); info(strFmt("%1 till cleanup done ",rangeStart));

Design user control To design user control you need to open visual studio then you can create new user control on form designer you can do below steps. add data source- add formid-add axsection=add grid or group Then Add lookup.   Add dataset add control for lookup and set dataset and fields in  Add range on init method or any other method to get range value filter Autopostback to true property on field to save data immediately. selectedindexchangeevent code this.AxDataSource1.GetDataSet().DataSetRun.AxaptaObjectAdapter.Call("datasourceRefresh",DropDownList1.SelectedItem.Text);