Friends, This code snippet will help us to get posted , deducted , received quantity on specific date.
static void SR_OnHandByDate(Args _args)
{
InventDimParm inventDimParm;
InventDim inventDimCriteria;
InventSumDateDim inventSumDateDim;
ItemId itemId = “1003”;
;
// Set the dimensions
inventDimCriteria.InventColorId = “02”;
inventDimParm.initFromInventDim(inventDimCriteria);
inventSumDateDim = inventSumDateDim::newParameters(mkdate(05,06,2007),itemId, inventDimCriteria, inventDimParm);
info(strfmt(‘Posted Quantity is %1’,inventSumDateDim.postedQty()));
info(strfmt(“Received Quantity is %1”,inventSumDateDim.receivedQty()));
info(strfmt(‘Deducted Quantity is %1’,inventSumDateDim.deductedQty()));
}
June 22, 2011 at 5:54 pm
[…] https://dynamicsaxgyan.wordpress.com/2011/03/04/find-invent-onhand-by-date-dynamics-ax-x/ […]