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.
*This post is locked for comments
Hi
In Inventory Stock Inquiry have one field QtyAlloc/AllocQty, from where this value calculated ?
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.
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (