Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Shipper will not Release

Posted on by 215

I have a shipper that will not release because it says the <inventory ID> will go negative.  Even though there are 2 in stock and we only want to sell 1. Using Dynamics SL 2011.

  • Suggested answer
    ChandraDX Profile Picture
    ChandraDX 55 on at
    RE: Shipper will not Release

    The numbers shown in the "QtyAlloc" field is the Quantity  which are present in a Sales Order and not delivered yet.

  • Suggested answer
    RE: Shipper will not Release

    Hi

    In Inventory Stock Inquiry have one field QtyAlloc/AllocQty, from where this value calculated ?

  • Suggested answer
    Valerie Huffman Profile Picture
    Valerie Huffman 90 on at
    Re: Shipper will not Release

    Hi Patti,

    We have been strugglilng with that problem for a while, and think we finally have it sorted out.  

    One of the things that we have discovered is that our error message is actually referring to the quanitiy available.  Here are some things to find out what is consuming that available quantity:

    1.  On your shipper are you pulling from the correct bin location?  Also, on the shipper screen, I do an F3 lookup to confirm the qty on hand and qty available.  If the qty available is not enough for the order, then I dig deeper.

    2. If you are, then run and inventory item status inquiry.  Highlight the correct site and click the location button.  This screen will show where Dynamics SL is consuming that inventory.  For us, it is usually either:

    -  on other shippers, in which case I will open those shippers and update them with another bin location

    - allocated to project inventory, in which cases I go to project inventory allocation and releases the allocation (this is the only way we can release the shipper if this is what is preventing it from release).

    3.  Sometimes we have to run an integrity check against both inventory and order managment.

    Hope this helps. I truly feel your pain.

  • Re: Shipper will not Release

    Hi Patti,

    Do you have access to SQL Server Management Studio?  When you are confirming Shipments the system will use the following to determine quantities:

    The location table quantity onhand minus the value in the s4future06 field

    If lot / serial tracked it will look at the same fields in the Lotsermst table.

    Could you run a select statement result from SQL Server Management Studio from the location table as well as lotsermst if you are lot or serial tracked for the item you are attempting to confirm.  If it is a specific lot / serial you would want to restrict the select to that item / lotsernbr.

    Could you see if the above equation yields a negative number?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans