I’m having trouble getting 1 item to commit to sal...
# general
d
I’m having trouble getting 1 item to commit to sales orders. All other items are committing to sales orders normally, except 1. We have stock on-hand and available, supply required-by dates are normal, it is not allocating inventory from a future supply order, it is simply backordering the item regardless of what I do. I also cannot reallocate the item successfully. There is no order reservation for this item, all of the bins it’s in are active, etc. There is nothing in the system info that would indicate a recent change, yet this seems to have cropped up only int he past few days. I have been through the suiteanswers troubleshooting for this issue called “*Item* With Quantity on Hand Is Not Committing to a Sales Order”, but none of the suggestions worked. ideas what could be preventing this item from committing to a sales order?
a
Can you check "Reallocate Items" for the item and location if that quantity is stuck with any transaction?
r
It seems like you have tried everything you can. It might be time to raise a support case with NetSuite
a
Do you see this order at all when you go to reallocate items? Any chance the line is set to Do Not Committ? Is there a fulfillment against the SO already for the item?
d
The reallocate items screen: there is no transaction with enough items to block the available inventory. And yes, I see all of the orders including any order I am looking at in the reallocate items screen. However, the screen will not commit the items--it is stuck committing the same 3 items, all I can do is shoft those 3 items between the open sales orders. Support ticket has been opened
Even cumulatively there are not enough open transactions to block the available inventory.
re: the “do not commit”--I have been through the help menu and seen this suggestion, but nowhere can I find a “do not commit” field, active or inactive. Cant find this option even if I try to customize the form, etc. Not sure what this means, but I’m thinking this means it isnt it? I dont think its possible that if this field is that hard to find, that someone somehow changed it for this one item on a dozen or more sales orders?
There are no fulfillments agasint the order line for any of these sales orders.
p
"do not commit" is a option under the "Allocation Strategy" line item sublist. But sounds like if you are able to allocate even 1 pcs then thats not the issue.
what happens if you temporary adjust inventory adding 10pcs to inventory.
d
Thanks--found “do not allocate” under that option, but that is not the setting on any of these orders, they are all normal.
RE: adding inventory--fantastic idea. I did this, and was instantly able to commit the new 10 units. It seems there is some hidden record that is holding 98 units of my inventory.
I checked bin transfers and all loos normal--XX units out, and the same xx units into the new bin. All units are assigned to an active bin, and the actual physical inventory matches the units that netsuite shows in each bin. No open sales orders other than what I am trying to commit, no transfer orders, no credit memos, no reservation orders…Any idea what could be holding the 98 units of inventory?
p
do you have the supply allocation and "Allocate Orders" screen not the older "reallocate items" screen? In "allocate Orders" does it list all Sales orders as expected?
d
yes--both screens reflect the same orders.
p
I would temporarily add some inventory to get the order shipped. open a ticket with NS support. then once the issue is found remove the adjustment. \
d
OK, this is heartening, as this is exactly what I’ve done--nice to hear I’m not off target!
Can successfully kicked down the road…
THANK YOU for the help by the way!
p
Welcome, just make sure to undo the adjustment soon, you don't want to get to the end of the month with a fake adjustment.
d
well, spent an hour on the phone with netsuite support last week. They had me run a few searches, etc, and turned up nothing--we left it that they were going to look into it via “research”, and I have not heard back since. Followed up by email today, so hopefully something int he next day or two. That’s a long way of saying that I still have no resolution, so if anyone has ideas I am listening.