It is a very common set up where orders are being fulfilled by subsidiaries and across organizations, therefore cross-org inventory on-hand query is important to track the inventory levels of products across different legal entities, sites and warehouses. It also helps organization to make informed decisions about how to best leverage the stocks and massively improve rate of order fulfillment. It would be very useful for Inventory Visibility to support cross-org onhand query.
Comments
Hi, this option is now available with the product search in inventory visibility. https://experience.dynamics.com/ideas/user-profile/?user=aa5dbf14-d1ca-eb11-bacc-000d3a11210b
Category: Inventory
Administrator on 5/14/2024 2:17:50 AM
In the latest Inventory Visibility release, you can directly query cross-org inventory onhand or ATP by specifying API 2.0 in your query. Refer to documentation here - Inventory Visibility public APIs - Supply Chain Management | Dynamics 365 | Microsoft Learn
Sample query body for org usmf site 1, warehouse 11 and org usrt site 5, warehouse 16 for item A0001 and item A0002:
{
dimensionDataSource: string, # Optional
filters: {
productId: ["A0001", "A0002"],
keys: ["organizationId", "siteId", "locationId"],
values: ["usmf", "1", "11"],["usrt", "5", "16"],
},
groupByValues: ["colorId", "sizeId"],
returnNegative: true,
}