web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Inquiry shows neg...
Microsoft Dynamics GP (Archived)

Item Inquiry shows negative quantity on order

(0) ShareShare
ReportReport
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)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

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

    Your feedback is highly appreciated,

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,633 Moderator on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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.  

  • Community Member Profile Picture
    Community Member on at

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

  • Community Member Profile Picture
    Community Member on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans