I have an item that is showing a negative quantity on order. It appears that 1,000pcs were ordered, 1,008 were shipped, and 1,008 were invoiced. The PO is Closed. How can I make the negative 8 quantity go away?
*This post is locked for comments
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.
You can either run the inventory reconcile or manually correct the entry in table iv00102
That was the problem. The problem is now resolved. Thank you.
Let all Dynamics GP users close any inventory-related windows ... Sales, purchasing, manufacturing or inventory are closed.
It is not a necessity to let them log out of the system, just close the inventory-related windows.
I ran the reconcile on Sales and Purchasing. When I try to run it on Inventory, I get a message that I cannot complete the process while invoices are being posted, but we are not posting any invoices.
Have you tried running Reconcile on your Inventory records? That would be my first action. Inventory>>Routines>>Reconcile. Run it on just that item number. Running on every item can take a long time, depending on your transaction volumes. It's also best to make sure no one is posting inventory-related transactions and that you take a back up of your database prior to running reconcile, although when running on just one item, the backup may not be so critical.
Initially, have you considered the usual prerequisite including a reconciliation for the purchasing, inventory and sales ?
Your feedback is highly appreciated,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (