Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Sunday, September 13, 2015

Rule of Thumb | Negative Quantity Sold on Item Maintenance


Another common question is brought up by users is related to the item maintenance window, which may displays a negative quantity under the field "Quantity Sold", is this a normal behavior or not ? If so, what's the comprehensive explanation for that. 

Negative Quantity Sold on Item Maintenance Window
Initially, it is quite essential to shed a light on two important definition according to the "language" of Dynamics GP, which is the Quantity Sold in the Purchase Receipt (IV10200) and the Quantity Sold in quantity master or item quantity inquiry (IV00102)

  • Item Quantity Master or Item Quantity Inquiry retrieves data from IV00102, which stores quantities in base unit of measurement, it recalculated associated quantities after every single inventory-related transactions (IV, SOP, POP ...etc). The quantity sold in IV00102 is calculated based on the following equations

    IV00102.Quantity Sold = SOP30300.Quantity Sold - SOP30300.Quantity Returned
  • As for the purchase receipt (IV10200) quantity sold field, it could basically be any "out"  transaction withdrawing from a specific cost layer, such as an adjustment out, POP return, SOP invoice ...etc
In this essence, it is quite logical that it is normal to have a negative quantity sold on the item inquiry window only when Returned Quantities exceeds the Sold Quantities, which results with negative result. 


Example:

Item : 128 SDRam
Transactions:
  • Receiving: 100 piece 
  • Sales Invoice:12
  • Adjustment out: 10 
  • Sales Return: 20
Quantity on hand = 100-22 = 78 (excluding sales returns)
Quantity Sold =  12 - 20 = -8 (negative amount)

Item Quantity Calculations

In this essence, having a negative quantity sold on the item maintenance window is a normal behavior due to a expected calculations. But the question remains, how would you have more returned quantities than sold quantities int he sales module ! That's absolutely represents a logical error.


Note: 
The rule of thumb series is a collection of frequently asked questions either by the community members or clients, the answers to such inquiries have been analyzed and verified by the concerned party. This case is a community thread from 2013 which can be found on this link

Best Regards,
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete