Thursday, October 27, 2011

Find On-Hand inventory on given date

This piece of code can help you to find out On-Hand inventory at a particular date.

static void findingOnHandByDate(Args _args)
ItemId itemId;
InventDim inventDimCriteria;
InventDimParm inventDimParm;
InventSumDateDim inventSumDateDim;
// Specify the item to get onhand info on
itemId = '00005';
//inventDimCriteria.InventColorId = '02';
inventSumDateDim = InventSumDateDim::newParameters(mkdate(31,12,2009), itemId, inventDimCriteria, inventDimParm);
info(strfmt("PostedQty: %1",inventSumDateDim.postedQty()));
info(strfmt("DeductedQty: %1",inventSumDateDim.deductedQty()));
info(strfmt("ReceivedQty: %1",inventSumDateDim.receivedQty()));


  1. Hi Faisal,

    I want to trigger an event on change in On hand Stock physical available, What is the right place to put the code for it?

  2. You should trigger a gun on your head instead

  3. It is a good site post without fail. Not too many people would actually, the way you just did. I am impressed that there is so much information about this subject that has been uncovered and you’ve defeated yourself this time, with so much quality. Good Works! website management


I will appreciate your comments !

Download large bacpac (sandbox database) to DEV environment much faster

As the LCS website gets slower and slower and the database backups get bigger and bigger.  Use AZCopy to download objects out of LCS asset l...