
I have run the PSTL item reconciler and every time it comes up with the same items/errors with an "on order quantity does not match", however, looking at the item, it does appear to match, and running the standard GP inventory reconcile doesn't do anything to these numbers. How can I clean this up/get this removed so it doesn't run them every time?
Thanks,
Kevin
Hi Kevin,
Thank you for using Microsoft Forums.
I have seen this error come up when the values in the QTYONORD field of the IV00102 table are not accurate and don't match the information on the purchase orders.
If you take and looks at the Item Site Maintenance window at the 'On Order' quantities for each site and compare them to the all sites quantities, do they match? If you drill back to the transactions which make up this value do those match?
I suspect these values do not match. If these don't match, the reconcile should have updated the values in the IV00102 table to be correct and then printing that on the reconcile report. If you do the reconcile again, then it should have been fixed and not show up again. If it is showing up each time on the reconcile, then something is not getting updated and I wonder if there might be an issue with one of the PO's making up this balance or something wrong with a record in the IV00102 table.
I would check the information that it is pulling into the Item Quantities Maintenance window and the PO's which are being displayed and compare those to the IV00102. If you see a difference and the reconcile is not correcting it, then I would recommend to open up a support case as there may be an issue with a PO that needs to be resolved.
I hope this information helped.
Thank you,
Janelle | Microsoft Dynamics GP