Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

Saturday, September 14, 2013

Item Quantities Inquiry - Negative Quantity Sold Justification

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:


Inquiry > Inventory > Item

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: 


Data Flow - Item Inquiry Data Sources
  • 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.


Calculation Criteria: 
  • 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.

Note:
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, 

Tables View 

  • 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


Best Regards, 
Mahmoud M. AlSaadi

No comments:

Post a Comment