We currently have a negative amount showing up on order for several inventory items and we do not have any open PO's at this time. Does anyone know how/why this happened and how we fix it and how to prevent it from happening again?
Thanks,
Jennifer Pegg
Engine Control Systems Limited
*This post is locked for comments
Thanks for acknowledging this.
This past summer we applied patch KB2769063 (GP10.00.1868 and the problem is just about completely disappeared. We saw one incident in 5 months since the patch.
"You can either run the inventory reconcile or manually correct the entry in table iv00102"
I actually did both. I would update the table during operating hours then reconcile during the off time.
It seems to be a bug in the system if more are shipped than were originally ordered. when you close the purchase order it doesn't do the correct housekeeping. I have the screenshots to prove.
You can either run the inventory reconcile or manually correct the entry in table iv00102
We brought purchasing online in August and we are seeing these on a weekly bases with as many as 3 items a week. What I have done is added a report in SSRS to list items that show a negative QTYONORD. I watch this and other issues on a daily basis and we correct them with a reconcile as soon as possible.
In our case the POs are not Drop Ship but standard POs that are over-received. The only other activity on one case was inventory usage adjustments and one site to site transfer.
With all those people coming by, I do remember you.
Wish I had some more ideas for you :). Your suggestion of reconciling inventory at the end of every week is the only thing I have found to work. It was nice meeting you at Convergence by the way. I am the guy who's dad went to Furman.
I have this happening with customers that do not drop ship and do not use Sales Pad. For that matter, most of my customers back order quantities not on hand, manufacture the items, turn the BO's into orders and ship from stock. And They get the problem. (???????)
I am looking for ideas.......
The issue we have found occurs when dropship sales orders are created and purchased within Salespad. The on order and on hand qtys act as if they were not dropships. Therefore, if you dropship 3 widgets with 0 on hand in your warehouse, it will show 3 on order and -3 on hand. Reconcile always fixes the problem. We are running GP 9 and an older version of eConnect, but according to Salespad, the issue still exists in the latest builds.
I intentionally have received more than ordered and this does not seem to affect the problem. While reconcile (Check Links did not hurt but does not affect the totals) will reset the values properly, the issue will return. Just put running reconcile in your weekly maintenance task list.
It is interesting that problems have been found in eConnect, my customers with this problem do not have eConnect.
Thank you everyone for your responses. My IT dept ran checklinks and reconcile and it has indeed fixed itself.
I don't think that the cause came from our 3rd party products - Encore (bank rec), Smartlist Builder and Extender (eOne).
The only thing we could come up with is if we received more items than were originally on the PO.
Thanks again!
Hi Ron,
Can you describe the bug and how to recreate it - what versions etc? We do a lot of eConnect integration stuff so I'm interested in anything like this.
Best regards,
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
