Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How do I get items out...
Finance | Project Operations, Human Resources, ...
Suggested answer

How do I get items out of allocated?

(0) ShareShare
ReportReport
Posted on by DiscountFilters 45

We use WilloWare's MO Generator to create a Manufacturing Order in Dynamics GP.  It creates a MO in GP and processes it.  In this case, 90 items of a raw material (an item on the BOM of the item the MO is for) is stuck in allocated.  WilloWare suggested I run Component Transaction Entry and MO Receipt Entry, but I receive errors on both.  The Component Transaction Entry shows a yellow triangle beside the raw material I'm having problems with and clicking Post gives the message "the transaction quantity is greater than the expected quantity needed".  The MO Receipt Entry also gives a yellow triangle beside the quantity to backflush by the raw material I'm having trouble with and clicking Post gives the message "At least one component has a shortage that has been overridden".  This is the extent of my GP knowledge.  I'm a C# developer by trade and am only looking into this because I wrote the batch program that runs the WilloWare software.  How do I get the items out of allocated?

Here is the raw item with 90 items stuck in allocated:

pastedimage1603898461712v2.png

Here is the MO:

pastedimage1603898418798v1.png

Here's the Manufacturing Component Transaction Entry and the error message:

pastedimage1603898509036v3.png

pastedimage1603898534804v4.png

Here is the Manufacturing Order Receipt Entry and the error message:

pastedimage1603898565053v5.pngpastedimage1603898574586v6.png

Categories:
Microsoft Dynamics GP
  • REAL Profile Picture
    REAL 5 on at
    RE: How do I get items out of allocated?

    This is way past, so hope you figured it out,  but overallocation really sets us back on a lot of our transactions. One workaround I've found is to create a backup Site ID, Site Transfer the product you need to that ID, and then alter the line item on the MO to backflush from the backup site while all other components that are not overallocated are pulling from the standard site ID.

  • DiscountFilters Profile Picture
    DiscountFilters 45 on at
    RE: How do I get items out of allocated?

    Thanks again for responding.  Apologies if I'm not being clear.  I don't think that it's been improperly allocated.  My problem is that the allocated needs taken out.  Usually when an MO runs, it removes the raw goods from inventory.  In this case, an MO was made for 90 RWF-122-BASE.  One of the items on the BOM for this item is RWF-122.  So we'd expect the MO to take 90 out of inventory for RWF-122.  Instead, after the MO ran there were 90 On Hand and 90 Allocated.  What we would expect to see is 0 On Hand and 0 Allocated.  It's like something got "stuck" while the MO was processing.  I need to know how to get those 90 out of allocated and instead taken away from on hand.  Since the MO says the status is "released" (we usually just see MO's as "closed"), I'm guessing something needs done to the MO to close it, but I don't know how to do that.  I've been told this needs to be done by end of day on the 30th to close the month.  At this point, I'd be fine with just canceling the MO and I can manually enter and run it again.  Again, I've had very little training in GP; I just created the code that calls the web services call to create the MO.  All I know is that I need the On Hand and Allocated for RWF-122 to be 0.  How do I do that?

    * It's not letting me attach screenshots, but you should be able to see the inventory amounts in the screenshots in my original question.

  • Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: How do I get items out of allocated?

    Where specifically are you seeing the items marked as allocated? Can you send a screenshot showing the incorrect allocations for one of the items?

    When I look at the error, you received when you attempted to post the receipt - that doesn't indicate an item is allocated when it shouldn't be. Rather, the "At least one component shortage has been overridden" message indicates you have a 'shortage' in quantity.

    If you pull up one of the problem items via Inquiry >> Inventory >> Item, and then click on the 'Allocated' (blue) link on the right hand side of the window: are you seeing incorrect allocations for the item here? Can you send a screenshot?

    Overall, if there is a problem with the allocation data associated with this MO, and the steps in the blog didn't resolve the problem: we'd recommend you open a GP support case so we can review the data to determine best steps to resolve the problem:

    mbs.microsoft.com/.../technicalsupportrequest

  • DiscountFilters Profile Picture
    DiscountFilters 45 on at
    RE: How do I get items out of allocated?

    Thanks so much for your quick response.  I ran the inventory reconcile and now have twice as many (180) items in allocated as I did when I started.  Management wants this fixed by tomorrow; is there anything I can do just to 0 it out or cancel the MOs that they were on?  I also tried running the scripts from the blog you suggested.  The MO is not closed, so I didn't run the first set.  The 2nd set returned 0 results.  Updating MOP1400 to 0 worked (2 records affected), but it didn't help my allocation problem.  I ran the inventory reconcile after I did that too.  If there's anyway to just clear the whole MO transaction out, can you tell me how to do it?

  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: How do I get items out of allocated?

    The first thing I’d recommend is to reconcile Inventory quantities which may solve the allocation problem (Microsoft Dynamics GP >> Tools >> Utilities >> Inventory >> Reconcile) in a Test company with a copy of live data.

    When you reconcile in Inventory with Manufacturing installed, the following will occur:

    • Allocated quantities for the items are set to 0 in the Inventory series.

     

    • The on-hand quantity and the allocated quantity for the item are determined by using data from the Inventory, Sales Order Processing, Invoicing, Bill of Materials, and Purchase Order Processing series. The on-hand quantity and the allocated quantity are set to the amounts that are determined by the system. This change is printed on the Inventory Reconcile Report.

     

    • Pick documents from the Manufacturing series are also used to adjust the allocated quantities for the item. This change is printed on the Picklist Reconcile Inventory Allocation Report.

     

    • The Manufacturing tables that store the pick documents are compared. A change to the quantity that is issued for a particular manufacturing order may result. This change is printed on the Picklist Reconcile Report for the Manufacturing series.

     

    If reconciling doesn’t take care of the problem allocations, here’s a link to a good blog written by one of our Manufacturing experts that talks about troubleshooting unexplained allocations in Manufacturing:

    https://community.dynamics.com/gp/b/dynamicsgp/posts/correcting-unexplained-allocations-in-gp-manufacturing

    I hope this helps!

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans