When working with raw materials in Dynamics 365 Finance & Operations (D365 F&O), it’s common to encounter situations where the inventory is stored in one unit (like Liters or Packs), but needs to be viewed or calculated in Kilograms (KG) for costing, reporting, or analysis. In this blog, we’ll walk through a practical X++ code snippet that demonstrates how to convert available inventory (AvailPhysical) into KG using D365’s standard Unit of Measure (UOM) conversion. 📌 Business Scenario Suppose you have a chemical item stored in Liters , but the production or costing team needs to see its available inventory in KG . You’ll need to: Fetch the item’s AvailPhysical from the InventSum table. Get the current unit of measure (UOM) for the item. Convert that quantity into KG , based on predefined unit conversion. 💻 X++ Code – Inventory Conversion to KG Here’s the code block that does exactly that: //******************** Avail Physical as per KG Unit conversion *...
/** * Calculate the managed cost for a given item and site. * * @param _itemId The ItemId for which the managed cost is to be calculated. * @param _siteId The SiteId for which the managed cost is to be filtered. * * @return The calculated managed cost for the given site. */ private real calculateManagedCostBySite(ItemId _itemId, InventSiteId _siteId) { Query query; QueryRun queryRun; QueryBuildDataSource inventSumDS, inventDimDS, inventTableDS; InventSum ...