AX / D365FO – How to do an Inventory recalculation for on-hand Qty

Sometimes you may see some discrepancy in InventSum table for any item then you may need to recalculate inventsum for particular item. You can try in 2 different ways : With D365FO User Interface With X++ code With D365FO User Interface Go to System administration > Consistency check Choose : "Inventory management" Module Just do … Continue reading AX / D365FO – How to do an Inventory recalculation for on-hand Qty

D365FFO – AX – X++ – Get on-hand quantity

//Get InventDim buffer    inventDim.InventLocationId = importTable.InventLocationId;    inventDim.wMSLocationId = importTable.WMSLocationId;    inventDim.InventSiteId = InventLocation::find(importTable.InventLocationId).InventSiteId;    inventDim = inventDim::findOrCreate(inventDim); inventSum = inventSum::find(importTable.ItemId, inventDim.inventDimId);    

D365FFO – AX – X++ – Query On-Hand inventory using specific inventory-dimensions

Using the class InventDimOnhand, you can determine the on-hand inventory of articles and/or specific inventory-dimensions. The following job determines the inventory for a specific item and a specific inventlocation. This is grouped per color. static void getInventOnhandExample(Args _args) { ItemId itemId; InventDimOnHand inventDimOnHand; InventDimParm inventDimParmOnHandLevel; InventDimOnHandIterator inventDimOnHandIterator; InventDimOnHandMember inventDimOnHandMember; InventDim inventDim; InventDim inventDimCriteria; InventDimParm inventDimParmCriteria; // … Continue reading D365FFO – AX – X++ – Query On-Hand inventory using specific inventory-dimensions

D365FFO – AX – X++ – InventOnHand Vs InventDimOnHand

What the difference between InventOnHand and InventDimOnHand classes and in what cases they must be used? Axapta InventOnHand class is wrapper for InventSum table. Unique index for InventSum table is ItemId + InventDimId. In other word, this class is used to get on hand for item with specific dimension. For example, if you require getting on-hand qty … Continue reading D365FFO – AX – X++ – InventOnHand Vs InventDimOnHand