How to get new Sales order number,Project proposal id and Transfer order number in Ax 2012


To get new Sales order number,Project proposal id and Transfer order number in Ax 2012 You can get hints from below code.


 //Get new sales Id   
 salesTable.SalesId = NumberSeq::newGetNum(SalesParameters::numRefSalesId()).num();  
 //Get new project proposal id  
 NumSeq = NumberSeq::newGetNum(NumberSeqReference::findReference(extendedTypeNum(ProjProposalId)));  
 //Get new Transfer order number  
 inventTransferTable.TransferId = InventTransferTable::numberSeq().num();  

Where parameter table is used and extended data type passed in method.

Check SSRS Report data through job in Ax 2012

If you want to Check SSRS Report data through job in Ax 2012 without executing report then you can get idea from below code.

   SalesOrderValueTmp tempTable;  
   SalesOrderValueDP dataProvider = new SalesOrderValueDP();  
   SalesOrderValueContract contract = new SalesOrderValueContract();  
   contract.parmCustAccount("Test001);  
   contract.parmNoOfBuckets(6);  
   dataProvider.parmDataContract(contract);  
   dataProvider.processReport();  
   tempTable = dataProvider.getSalesOrderValueTmp();  
   while select tempTable  
   {  
     info(strFmt("%1,%2,%3,4",tempTable.CurrencyCode,tempTable.SalesId,
     tempTable.Monthname,tempTable.CurrentMonthSum));  
   }  

In this code while look is use to get data inserted in temporary table from data provider class . Contract object is SSRS Report contract class object.