Pawan's Ax blog: How to get all the planned orders for a particular demand. in Ax2012

[Blog bot]

Источник: http://pawansaxblog.blogspot.com/201...rders-for.html
==============

When we create a sales order in Ax. Basically we are creating demand in system and when we run scheduling in system it generates the planned production or purchase orders.



Following is the step by step process.


·Create sales order. And check the explosion from salesline->Product and supply. Initially there are no planned orders. So there is no record in explosion.

·Check the explosion from salesline

·Now run the planning from Master planning ->Periodic->Master scheduling

·Check the explosion from sales line

·If we want to get all the planned production orders detail we can get it through following x++ code. We can get top level planned order from REqPo table where on the basis of pegging reference of sales order we can find top level planned production order. We can use that planned order as a parameter in a method and retrieve all the lower level orders.


private voiddoUpdateReferences(reqPo _reqPo)
{
ReqTransExplode reqTransExplode;
Map mapReqTransLocal;
MapEnumerator enumerator;
container conMapReqTrans;
Map mapReqTrans;
reqTrans reqTrans;
ReqPO reqPo = _reqPo;
Map plannedOrderMap = new Map(Types::Int64, Types::Record);

;


while (reqPo)
{
if (!plannedOrderMap.exists(reqPo.RecId) )
{


reqTransExplode = reqTransExplode::newReqTrans(reqPo.reqTrans(),ReqExplodeType::Down,true);
reqTransExplode.run();


conMapReqTrans = reqTransExplode.packMapReqTrans();


mapReqTransLocal = (conMapReqTrans) ? Map::create(conMapReqTrans) : new Map(typeName2Type(extendedtypestr(recId)), Types::Record);


mapReqTrans = newMap(typeName2Type(extendedtypestr(recId)), Types::Record);
enumerator = mapReqTransLocal.getEnumerator();
while(enumerator.moveNext())
{
reqTrans = reqTrans::findRecIdCrossCompany(enumerator.currentKey());
if (reqTrans.RefType == ReqRefType::BOMPlannedOrder)
{
Info(reqtrans.reqpo().refid);
}
}
}


next reqPo;
}


}

Источник: http://pawansaxblog.blogspot.com/201...rders-for.html