One of the cases I have been working on recently on the Microsoft Dynamics Community is the Justification of having negative "Quantity Sold" filed on the Item Inquiry.
After thorough and continuous testing, I have figured it out, and the answer is simply "Sales Returns" !
I will start my post with the end-result in my mind, here is what the inquiry will show:
The fact is that the window above retrieves the data from (Item Quantity Master Table | IV00102 ) in base unit of measurement. And the question remains on the Data Source from which Item Quantity Master retrieves data, and how does it calculate and record these numbers.
Date Flow and Data Source:
- Item Inquiry retrieves data primarily from Item Quantity Master (IV00102)
- Quantity fields in Item Quantity Master are updated after every transaction (IV, SOP and IVC). In addition, Inventory Reconciliation re-calculates correctly these quantities.
- IV00102..Quantity on Hand = IV10200.. Quantity Received - IV10200.. Quantity Sold (excluding returns documents)
- IV00102..Quantity Sold = SOP30300..Quantity Sold - SOP30300..Quantity Returned
When the Quantity Returned is greater than the Quantity Sold, Item Inquiry will show negative quantity value.
Adjustment and Transfer documents don't update the "Quantity Sold" field in Item Quantity Master (IV00102).
Finally, I will list down the transactions performed on the test item (123123123) shown in the screen shot above, and show how the "Quantity Sold" field is calculated,
- IV00102..Quantity on Hand = IV10200.. Quantity Received (100) - IV10200.. Quantity Sold (22) = 78
- IV00102..Quantity Sold = SOP30300..Quantity Sold (12) - SOP30300..Quantity Returned (20) = -8
Mahmoud M. AlSaadi