Dynamics Community Forum Thread Details

Retrieve Qty available pr. variant

Hi all

I need to create a flowfield on variant table, which tells the qty available for that variant.

I know that we have the functionality on Item Card that retrives the variant qty available, I have debugged through the process but I couldn't see the what the relation between the Item ,variant and the Inventory was. If anyone can explain the flow in a more understandable language, I will be very thankful.

I have found out how they are related.

On the Item Variant table I create a new flowfield called "Quantity Available" with below calcformula:

CalcFormula = Sum("Item Ledger Entry".Quantity WHERE ("Item No."=FIELD("Item No."),"Variant Code"=FIELD(Code)));

To test the solution I did following:

Create and post a line in "Item Journal" with Entry Type set to "positive Adjmt." and then choose an item that has variant(s).
Choose a variant in "Variant Code" and enter a quantity for it,
Create a sales order with the item above.
on the sales line, choose the variant code we added.
post the sales order
Open "Item Variant" table and find the variant we used before.
The value for the field "Quantity Available", that i created should now be (Quantity from Item Journal) - (Quantity from Sales order)

Quick Links

Leaderboard