Share
ReportHi There,
Does anyone know why it is showing QTY Sold negative in the Item Quantities Maintenance screen?
Thanks,
*This post is locked for comments
You’re offline. This is a read only version of the page.
Announcements
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
Most welcome,
Thanks, Appreciate it.
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
|
Item |
Document |
Date |
Quantity Sold |
Source Receipt Sequence No |
Unit Cost |
|
Chair |
ADJ OUT |
01-05-2013 |
2 |
123456 |
5 |
|
Chair |
SALES |
05-06-2013 |
3 |
123456 |
5 |
|
Chair |
SALES |
01-07-2013 |
2 |
123456 |
5 |
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
Hope this helps,
So which Quantity should we consider the one in IV00102 table or the IV10200 table?
Hi Mahmoud,
This is a very precise and a good explanation to the question asked, I appreciate all your findings.
Thanks a lot.
Farooq.
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,
Never saw this before, I have to test it and check if this is the case, i will let you know
Thanks,
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 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?
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
