Just got it to work. Changed the Summary type to MAXIMUM and the description value to 0. I do have one question, though. Does OR not work in these kinds of formulas?

For obvious privacy issues, I can't show the actual results, since I would have to hide all of them.

Thank you. I've told our staff and we're going to just work with production for now.

Yes, that's correct. I'm not sure why it's configured that way, though.

Our contact at UPS said that is how this item is configured in NetSuite, so it is not broken, after all. You can call me Jess.

For #5, it's our main sales account, so we can't close that one down!

Would you say editing the quantity on a line could potentially cause this? I see an instance recently where the quantity was changed by ten on a line with the offending item.

Right. I can't choose the one right to that: Show as Multi-Select. It does not show up at all if we just add it without checking it. Is it because the field itself is filtered under Sourcing? Trying to figure out why we can't add it.

Sorry for the late response. I was out on PTO last week. My end user was able to shore up the fulfillment by using your first solution. We did not want to touch the settings, so we opted for that. Now we know what to do going forward if it happens again. I have also added our case to the enhancement request for Oracle.…

Yes, we have the latter scenario. 4 were previously fulfilled, leaving only 4 remaining on the Special Order. I have filed a ticket with Support and they've added it to the enhancement (not a defect at this time). I will let you know what the team decides.

Thanks. We've had similar (but not exact) issues before with negative quantities and it has been cleared up a few days later when a diagnostic/correction tool runs. I wish we had better transparency on when that happened, but I will keep an eye on it!

Any idea why it would be showing a negative quantity? I've submitted a case, since it seems like we might be dealing with some miscalculation again. Thanks for all your help!

That is the info for the main location. There are 20 on hand in another location we use, but all other quantity shows 0 or no data.

Yes, it uses Member Item: Available as the result column to show availability. However, it is also showing incorrectly when our staff goes to Create Inventory Count. See attached image.

On the Inventory Item itself, it shows: 161 on Hand, 161 Committed, 500 on Order, 12 on back order, 0 available. So on the inventory item Location subtab, it is correct. It's only under the associated Kit Item and on Inventory Count it is showing with -2 available.

No, they are correct on Sales Order and Quotes. Shows 0 available, as you would expect. It's on the Kit Item. One of its components is showing a negative quantity available. Also, on Inventory Count, it shows up negative. It should be showing 0.

It seems to be working, now! Thank you!

Unfortunately, that also did not work. If I use Main Line False, it shows everything and if I set it to True, everything is eliminated. I see your example uses a drop ship item. Is that set with Drop Ship Item checked? Most of our inventory items are not set up that way.

Still showing up, unfortunately.

Here are the search parameters: Here is a Sales Order with the open PO lines Here is an example of a linked PO record.

Unfortunately, that did not work. It is still showing orders where some open lines are drop shipped and some lines are not.

The issue ended up being a defect, which was identified by Support. An eFix was issued this week that cleared up the problem. I suspect it was broken by 2020.1 or one of the Friday patches, since I pulled historicals on our kit items and found rare instances of this problem dating all the way back to 3/26. Ops team just…

Yes, the line-level location on our orders is driven by the item record. We actually had an issue last autumn where a lot of roles had the "none - default to own" location restriction, which was overriding the line-level location to the user's location regardless of the location on the items. That's why I created a…

Header level. The WF has been in place for months, so there is something else going on. Line level location is driven by the item. I have opened a support ticket and provided the appropriate information. Should I reply here with the solution once the issue has been resolved?

Thank you. In our case, we have as workflow that sets location by default upon quote/order entry, so an empty location would not explain it. Also, we keep all of our component/inventory stock in the same location, so there would be no different locations on either the components or the kits. I wish it had been that easy!

We have Limit to Committed. When I set up a test quote/order, the pop-up does NOT populate unless ALL components are unavailable for the kit. In this case, the item has three components. One has a qty. of 3088 and the other two components are zero. It it showing a qty. available of 3088. We don't want a kit to be shown as…

Just so you know, the original 526 has been billed already. We will probably not be able to delete any records. I will see about the inventory adjustments, thanks!

Here is a solution that has worked. I wish I could take credit for this but unfortunately, it didn't work out that way. It uses Inventory Detail.

Exactly. The poor joins really annoy me. Maybe they'll eventually add that with Analytics. This seems like a search that should easily be possible.

Thank you. They are really concerned with this empty bin search, so I will keep trying other methods.