Item Inquiry shows negative quantity on order

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

That was the problem. The problem is now resolved. Thank you.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

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.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,615 Super User 2025 Season 2 on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

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.

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Item Inquiry shows negative quantity on order

Initially, have you considered the usual prerequisite including a reconciliation for the purchasing, inventory and sales ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No