Monday, May 1, 2017

How to Update Project Status by Code in Ax 2012

To Update Project Status by Code in Ax 2012 You can get help from below code sample. In this code if Project status is created then it will update to In process stage.

Same way you can try as per your requirement.

 Projtable projTable;  
   int cnt;  
   ttsBegin;  
   while select forUpdate projtable where projTable.Status==ProjStatus::Created
   {  
     cnt++;  
     projtable.Status=ProjStatus::InProcess; 
     projtable.update(); 
   }  
   ttsCommit;  
   info(strFmt("%1 Project Updated",cnt));