Share
Report
4Hello Dynamics Community,
I've been struggling for a few days trying to find a reliable way to fetch inventory stock levels by item variant, and I'm hoping someone here has a solution.
My Goal:
I need to get the current inventory stock (e.g., quantity on hand, or projected available balance) for each specific variant of an item (e.g., Item "TSHIRT", Variant "RED", Variant "BLUE").
What I Have Tested So Far:
-
API v2.0
/items?$expand=itemVariants and /item and /itemVariants-
This successfully returns the parent item and a list of its variants. However, the
itemVariantsentity only contains descriptive data (code, description) and does not contain any inventory fields.
-
-
API v2.0
/itemLedgerEntries-
My plan was to calculate the stock myself by summing the
quantityfrom this endpoint. -
The Problem: The
itemLedgerEntriesresponse only includes the parentitemNumber. It's missing thevariantIdorvariantCodefield, which makes it impossible to link a ledger entry to its specific variant.
-
-
ODataV4 Endpoints
-
I have inspected several standard OData pages (like
ItemLedgerEntries,PostedSalesShipments, etc.), but they all seem to have the same limitation.
-
My Constraint (Important):
I am building an integration that needs to be scalable for multiple clients. Therefore, I cannot deploy custom AL code (like a custom API page or query) to the client's environment. The solution must use the standard, out-of-the-box API or OData endpoints.
My Question:
Is there a standard API or OData endpoint that I'm missing? How can I get the inventory stock for each specific item variant without writing custom code?
Thank you in advance for your help!
All responses (
Answers (
