Announcements
No record found.
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.
*This post is locked for comments
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?
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.
Hi
In Inventory Stock Inquiry have one field QtyAlloc/AllocQty, from where this value calculated ?
The numbers shown in the "QtyAlloc" field is the Quantity which are present in a Sales Order and not delivered yet.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
