Included below is the scenario that I hope someone here can help me with.
A buyer created a multi-line standard purchase order.
Line 1 was for 4 cases (CS40) of item CJ-16. Each case contains 40 each.
One CS40 of item CJ-16 was received on 9/6/12. This left an open order balance of 120 EA.
A second shipment arrived at our dock with 117 EA on 12/10/12.
The buyer cancelled the remaining 3 CS40 on the original order line and added a new line for 117 EA.
The P.O receipt, including the new line for 117 EA, was processed via Receivings Transaction Entry.
For this receipt, Purchasing Quantity Status Inquiry shows the following values under the Posted to Date column:
Shipped 117, Invoiced 0, Rejected 0, Matched 0.
It also shows:
Remaining to Ship 0, Remaiing to Invoice 117, Remaining Posted Shipments to Match 117.
However, a query of table IV00102 (Item Master) for item CJ-16 shows the following:
Last Receipt Quantity = 40, Last Receipt Date = 2012-09-16, Quantity on Order = 0.
The preceding data from the item master does not agree with the Purchasing Quantity Status Inquiry application.
I think that we are not using the correct process to handle this scenario and I would like to know what procedure others use to handle it.
Thank you.
