Get on hand inventory (quantity) of an item using x++

To get on hand inventory (quantity) of an item using x++ in Microsoft Dynamics 365 for Finance and Operations or in Microsoft Dynamics AX 2012 is always a headache because there is no field in the table which gives the on hand inventory. So, to tackle this issue I am sharing this function. It gets two arguments which are as follows:

1. ItemId
2. InventDimId

It returns on hand inventory.

public InventQtyAvailPhysical onHandInventory(ItemId _itemId, InventDimId _inventDimId)
{
    InventOnhand    inventOnhand;
    InventDim       inventDim = inventDim::find(_inventDimId);
    InventDimParm   inventDimParm;

    inventDimParm.initFromInventDim(inventDim);
    inventOnhand = InventOnhand::newParameters(_itemId, inventDim, inventDimParm);
    return inventOnhand.availPhysical();
}

So, this is how you can get on hand inventory (quantity) of an item using x++ in D365FO or in AX 2012. Moreover, you can also explore more functions and tricks. Don’t forget to share your code in comments.

If this helps you, please Like, Comment and Share to help other people.

Blog: Click here

YouTube: Click here

GitHub: Click here

A pessimist sees the difficulty in every opportunity; an optimist sees the opportunity in every difficulty. – Winston Churchill

ax2012 D365FO DAX2012 Microsoft Dynamics 365 Finance & Operations Microsoft Dynamics AX 2012 on hand inventory onHandInventory quantity X++

Moeen Ahmed Sultan

I am Moeen Ahmed Sultan from Pakistan, an Independent technical consultant for Microsoft business applications. I am Microsoft Certified Professional, I always seek opportunities to showcase my skills in the extensive field of Computer Science. I have successfully championed to the enterprise by working in extensive areas including Microsoft Power Apps, Microsoft Dynamics AX 2012, Microsoft Dynamics 365 for Finance & Operations, and Microsoft Share Point Online thereby fueling the industry-wide transition.