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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory item will go negative

(0) ShareShare
ReportReport
Posted on by 35

When attempting to create a debit memo for an item, quantity of 8, I keep getting an error message, "Inventory item will go negative. Do you want to make changes? …"

Inventory available: 11, On hand: 34, on Sales orders: 23

Plenty available, why do I keep getting the error? What needs to be done to make this go away?

pastedimage1585143201390v1.png

I have the same question (0)
  • CFROTON Profile Picture
    4,710 on at
    RE: Inventory item will go negative

    Hello Pat

    Can you tell me what version you are on with SL?

    What screen are you in when you get the error?

    What is the exact error message that goes along with the error?

    Best Regards,

    Jana MacDonald

  • momozazat Profile Picture
    24 on at
    RE: Inventory item will go negative

    have you tried OM integrity check?

  • Pat883HD Profile Picture
    35 on at
    RE: Inventory item will go negative

    My apologies. I forgot about the post. Not sure if it cleared itself or if my DB guy had to make changes behind the scenes, which seems to a common occurrence since we recently upgraded to SL 2018

    Should I have this issue again, I will repost. Thanks.

  • Pat883HD Profile Picture
    35 on at
    RE: Inventory item will go negative

    As far as my DB guy is concerned, OM integrity check is not an option. I believe due to the potential disruption that may cause...but I am totally unfamiliar with that process.

  • Suggested answer
    Mark E Profile Picture
    6,451 on at
    RE: Inventory item will go negative

    The OM Integrity Check to Rebuild Inventory Plan (especially for particular InvtID/SiteID combination) are quite harmless, and indeed necessary at certain times.  It performs a rebuild of the SOPlan table, and sometimes resolves some issues that can be linked to your message (like incorrect Bin Qtys).  There are multiple reasons for the Item will go negative issue, and the majority (I have found) are linked to Bin Qty issues.  Even though the Site may have correct Qtys, Bin Qtys may be incorrect (or you are simply using a Bin with a true shortage).

    I would agree to avoid most of the IN Integrity Checks for rebuilds of Item History, Quantities & Costs unless you really are looking to solve a specific issue related to ItemSite, ItemHist, Item2Hist, etc.  I have needed to do this on very rare occasions, but with a very specific requirement.  Sometimes the IN Rebuild On Order Qtys have value, but again rarely (in my experience).

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,177

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 860 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans