JMack Admin Blue Ribbon

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.

I'll be honest, I'm not 100% sure the difference between Location and Inventory Location. I'm relatively new to inventory management. These are also different on literally every item. I don't see the inventory location on the item record. The main Location under Classifications is correct, though. I recently updated that…

@JGriffin Also, not sure if this helps, but for one item, the Bin Number, Bin Number : Bin Number, and Bin on Hand : Bin Number will all be different, as will the locations associated with them. I am unsure why this is or if it's expected.

Sure. 1776 bins are returned. We only have 464 Bins active right now. Old locations still show up and even if I filter down to our one location we currently use, I still get 525 results.

Thank you, John. I assume this is part of the Item search, because I don't see Bin On Hand and Inventory Location fields available on the inventory/bin search. This did not work for me, either. Now I'm back to the problem of getting far too many results.

Unfortunately, this search also did not work. It only pulled up 20 results and only eight of those were actually empty. All other bins had items in them. I really am at a loss as to what to do. If you have any other ideas, I would be glad to hear them.

I have sent this to our ops team. Fingers crossed. If I receive feedback, I will let you know. Thank you so much!