Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Allocated Inventory when zero quantity on hand

Posted on by 595

Company had accidentally adjusted the wrong inventory item which created an inventory on hand for the wrong item.  Before this was noticed, they were placing orders through the sales transaction entry and making purchases.  When they noticed there should not be quantity on hand, they went back and reversed the quantity adjustment.  However, now they still have allocated inventory items even though there is zero items on hand.  They can't purchase these items because they're already shown as allocated.  We did a reconcile on the Sales, Purchasing and Inventory, but it didn't correct the problem.  Anybody ever had to deal with this?

*This post is locked for comments

  • Katy Deming Profile Picture
    Katy Deming 595 on at
    RE: Allocated Inventory when zero quantity on hand

    Leslie,

    That is exactly what happened.  Can you describe the process to change the qty to invoice and the qty fulfilled to zero in further detail?  Is that done from the Sales Transaction Entry screen?  Thank you so much for your help.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Allocated Inventory when zero quantity on hand

    Hi Katy,

    Like Frank, I'm a bit confused as to the problem.  I have a little time here, so let me go through what I think might be the problem. It may not be, but this is my interpretation:

    1. They created an inventory adjustment that increased the quantity on hand of XYZ item from zero to let's say 10.

    2. They sold a quantity of 10 of the  XYZ item on a SOP document.

    3. The quantity sold was allocated and fulfilled thereby reducing the quantity available for sale to zero.

    4. On the inventory inquiry window the Quantity on Hand is 10, the quantity allocated is also 10. The quantity available is zero.

    5. They realized the adjustment that increased the quantity of the XYZ item to 10 was wrong.

    6. They reversed the original adjustment thereby reducing the quantity on Hand to zero.

    7. Since they had previously sold 10 XYZ items, the quantity allocated is still 10 and the quantity available is now showing -10

    If the above is correct, the system is working as designed. The only way that I know of to 'un-allocate' the quantity is to take it off of the SOP document. None of the utilities will change those quantities.

    If they are trying to create a PO from the SOP document, they will not be able to because the SOP document will show the entire quantity as fulfilled. In order to create the PO, they need to change the Qty to Invoice and the Qty Fulfilled to zero. Then change the Qty to Back Order to however many you want to order.

    Does the above describe your situation?

    Kind regards.

    Leslie

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Allocated Inventory when zero quantity on hand

    Hi Katy,

    Like Frank, I'm a bit confused as to the problem.  I have a little time here, so let me go through what I think might be the problem. It may not be, but this is my interpretation:

    1. They created an inventory adjustment that increased the quantity on hand of XYZ item from zero to let's say 10.

    2. They sold a quantity of 10 of the  XYZ item on a SOP document.

    3. The quantity sold was allocated and fulfilled thereby reducing the quantity available for sale to zero.

    4. On the inventory inquiry window the Quantity on Hand is 10, the quantity allocated is also 10. The quantity available is zero.

    5. They realized the adjustment that increased the quantity of the XYZ item to 10 was wrong.

    6. They reversed the original adjustment thereby reducing the quantity on Hand to zero.

    7. Since they had previously sold 10 XYZ items, the quantity allocated is still 10 and the quantity available is now showing -10

    If the above is correct, the system is working as designed. The only way that I know of to 'un-allocate' the quantity is to take it off of the SOP document. None of the utilities will change those quantities.

    If they are trying to create a PO from the SOP document, they will not be able to because the SOP document will show the entire quantity as fulfilled. In order to create the PO, they need to change the Qty to Invoice and the Qty Fulfilled to zero. Then change the Qty to Back Order to however many you want to order.

    Does the above describe your situation?

    Kind regards.

    Leslie

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Allocated Inventory when zero quantity on hand

    Allocations come from demand - do you have sales orders or manufacturing orders with the item on them?  You need to locate the source of the demand and remove the item from those orders.

    Also, allocations have nothing to do with whether or not you can purchase the item.  There must be something else going on.  Why do you say they can't purchase them?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans