You’re offline. This is a read only version of the page.
We are trying to replicate the On Order quantity that shows on the Vendor Item Quantities Inquiry window..
Here is the formula that we are trying:
qtyorder from pop10110 (the PO Line table)
- qtycance from pop10110
- qtyshpd from pop10500 (the PO Receipt Line table)
+ qtyrej from pop10500
We are comparing this to qtyonord from iv00103 (Vendor Item Quantity table)
My numbers just aren't tying out as expected. Are the above tables in sync? Or do they clear to history differently? And if the latter, how is reconcile REALLY calculating this quantity field?
Hi Cindy,
The table IV00103 may not be updated before the documents are all posted. You might also want to consider the PO Line Status to make sure you compare open order (release) with already received / cancelled ones.
Taking the Fabrikam company as an example, my Item PHON-GTE-3458 is showing up in 3 PO's for a total quantity of 14 units, but they are all 3 in different status (Released, Closed, Cancelled), and the only item 'released' is = 4, which is on par with the QTYONORD for that Item / Vendor combination in IV00103.
Keep in mind that POP documents remain in the work table even after they are closed, until someone moves them into history by running a reconcile/remove.
Share
Report
All responses (
Answers (
28,058
