Using the InventOnHand Class

The InventOnHand class can tell you what is currently on hand for a particular item, batch and location, plus many other criteria. Below is an example.

 

static void testInventOnHand(Args _args)
{
    InventOnHand        InventOnHand;
    ItemId              ItemId = "123";
    InventBatchID       InventBatchId = "110101-00001";
    InventLocationId    InventLocationId = "M2";
    
    ;
    
    // see http://msdn.microsoft.com/en-us/library/aa866120%28v=AX.50%29.aspx for more info on num2str
    
    InventOnHand = new InventOnHand();

    // what's on hand for a particular item including inventory with a "hold" status
    InventOnHand.parmItemId(ItemId);
    Info(num2str(InventOnHand.availPhysical(),0,2,1,2));
    
    // what's on hand for the item and a specific batch
    InventOnHand.parmBatchId(InventBatchId);
    info(num2str(InventOnHand.availPhysical(),0,2,1,2));
    
    
    // what's on hand for the item, batch and inventLocationId
    InventOnHand.parmInventLocationId(InventLocationId);
    info(num2str(InventOnHand.availPhysical(),0,2,1,2));
    
}