Hi There,
Does anyone know why it is showing QTY Sold negative in the Item Quantities Maintenance screen?
Thanks,
*This post is locked for comments
It could be that the system has got itself a bit mixed up. If you view the item transactions in the Item Transactions Enquiry window or via smartlist, does that provide you with any extra information to explain the position?
If you run an Inventory Reconcile (via Tools > Utilities > Inventory > Reconcile) for just that one item, does it correct the position after reviewing and recalculating the supporting transactions?
I did the reconcile for the sku that is showing negative and does not do anything, seems weird I have lot of items that have this problem. When I run the Smartlist also it shoes negative in there.
Let me know if any other things in there.
It could be if you had more returns for this item when sales.
Never saw this before, I have to test it and check if this is the case, i will let you know
The precise answer to this question is simply (Sales Returns). Although, let me add further explanation on this issue;
The "Quantity Sold" field shown above, is different that the "quantity sold" in the Purchase Receipt layer and Details (IV10200 and IV10201).
Calculation Criteria:
Now the question remains, how ( IV00102 ) calculates and records these quantity fields. In our case, I will be illustrating mainly on both fields;
Finally, let me list down all the transactions performed on the item (123123123) which is shown in the screen shot above, and show how the (Quantity Sold) is calculated, and why it is Negative
Please never hesitate to share any further inquiries.
Hope this helps,
Hi Mahmoud,
This is a very precise and a good explanation to the question asked, I appreciate all your findings.
Thanks a lot.
Farooq.
So which Quantity should we consider the one in IV00102 table or the IV10200 table?
The Quantity Sold Value in IV10200 should match the value of the Quantity Sold in IV10201, since the value in (IV10200| Purchase Receipt Work) is a summation of the detail in (IV10201 | Purchase Receipt Details)
Part of the Inventory Reconciliation is to match the quantity in IV10200, and collect the details in IV10201 to ensure that they match. In case they don't match, A "RECON" document is created automatically through the reconciliation process in IV10201.
Let me give an illustrative example for that;
IV10200 | Purchase Receipt Layer
Item
Document
Date
Quantity Received
Quantity Sold
Receipt Sequence No
Unit Cost
Chair
Receiving
12-04-2013
10
7
123456
5
IV10201 | Purchase Receipt Details
Source Receipt Sequence No
ADJ OUT
01-05-2013
2
SALES
05-06-2013
3
01-07-2013
To ensure that, you could run the inventory reconciliation , you could make use of the scrip below on my blog for detailed quality check on the inventory purchase receipt layers:
Purchase Receipt Work and Details
Thanks, Appreciate it.
Most welcome,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
