Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory over allocation
Microsoft Dynamics GP (Archived)

Inventory over allocation

(0) ShareShare
ReportReport
Posted on by Patrick Patterson 630

All,

We are having a frequent problem with allocations.  Our inventory is lot controlled and we are using manufacturing as well as GP 2010.  Our issue is that the system is allocating more inventory than exists.  In the iv00300 table the quantity received may be 2454 pcs of an item/lot number but it will show 6000 allocated.  When the user attempts to use that item/lot number it shows on the screen as (3546) and they cannot do their job.  This morning I kicked everyone off and ran Reconcile on a section of the parts affected.  It cleared out the over allocations.  I then ran it again against another group of affect parts.  They were corrected but the first group is again over allocated.  While we have some manufacturing orders that are completed with the inventory allocated not issued the quantities but don’t seem to match up with the issue.  While I have worked with this system for four years the original setup was done around  2005 by 2-3 different consultants/companies and predates V9.  Has anyone seen this issue before?  

*This post is locked for comments

  • Patrick Patterson Profile Picture
    Patrick Patterson 630 on at
    RE: Inventory over allocation

    Update:  We found that any picklist that was saved not issued triggered this problem.  When we posted the picklist the part was removed from the over allocation.  However, the amount over allocated was not directly related to the quantities on the pick list so that is still a mystery.  Also, this only accounted for about 75% of the issue, 25% is still occurring without orders to trigger them.  Does anyone think that running check links might account for the missing 25%?  

    Also, I am still wondering why the system would react this way.  If saving a picklist partially complete causes problems why allow the process???

    Patrick

  • Patrick Patterson Profile Picture
    Patrick Patterson 630 on at
    RE: Inventory over allocation

    Note: we had a MO that had it's inventory saved on the pick list but not issued.  This registered as allocated.  When I had the users issue off the pick list the over allocations dropped off the system for these part numbers.  This could be coincidence, but I don't believe in them.  If this is our issue why is the system so over allocating the quantities as the user is putting in the amounts and lot numbers for the pieces we have picked and are leaving the rest alone.  Any ideas.

  • Patrick Patterson Profile Picture
    Patrick Patterson 630 on at
    RE: Inventory over allocation

    Trevor

    No luck on the override button's so far.  The only usage I've found involves non "official" inventory items such as marketing materials and catalogs.  Any other ideas???  I'm still testing and searching.

    Patrick

  • Community Member Profile Picture
    Community Member on at
    RE: Inventory over allocation

    Hi Patrick,

    We have the same problem here.  What we found was that even though inventory is set to NOT allow negatives, manufacturing will still allow the planner to "override" when he releases the MO.  We have the system set to auto-allocate on MO release.  So, we've trained our planners to never use the override option and the problem has been minimized, though not completely resolved.  I do run reconcile at least weekly even though it takes several hours because of this.  Note that we are also using multi-bin, which I attribute most of the problem to (rightly or wrongly).

    -Trevor

  • Patrick Patterson Profile Picture
    Patrick Patterson 630 on at
    RE: Inventory over allocation

    Frank

    That's one of the weird things on this one.  If I go to the item allocation screen it will show maybe 7500 allocated for all lot numbers and also all the orders/MO's, but when I go to the table iv00300 it will show 12,000 allocated for one lot number.  I have been searching for the demand that is causing this allocation without luck.  I've checked Sales orders, Manufacturing orders, Back orders,... and even BOM's any suggestions?

    Patrick

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: Inventory over allocation

    Well, allowing negatve WIP implies that you can receive or close an MO prior to issuing the material to it.  Not sure that would cause the issue.  Have you been able to trace back to documents that are creating the over-allocation?

  • Patrick Patterson Profile Picture
    Patrick Patterson 630 on at
    RE: Inventory over allocation

    Frank

    In inventory control setup I didn't find a allow negative, but in manufacturing it is set to allow negative wip quantities.

    Patrick

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at
    RE: Inventory over allocation

    By chance is your system set to allow negative inventory?  Check your Inventory Control setup.  Not saying that's it, but it could be.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans