JMack Admin Blue Ribbon

Wanted to add they are concerned about making sure the inventory is correct, not so much the account. I'm not sure what the best way to adjust that is.

We use FedEx, UPS, and USPS. Yes, they have field IDs: thirdpartycountry, thirdpartyacct, etc.

I believe I have resolved the issue by using a Custom Formula instead of Visual Builder for my conditions. So ({entity.balance+{entity.unbilledorders})>{entity.creditlimit}

Thank you. I will let my team know. Any idea why it was designed this way? I'm pretty sure that will be the follow-up question. :)

Trying to keep information protected, so sorry for the really close views. This is based off the standard GL report.

Right. We restructured our e-comm menu, so we needed to quickly pull items from those defunct categories. :)

Sounds good. I ended up just using the Reset button on the Commerce Category page. It removes all the items and subcategories instantly. Just had to import the items into their new homes. It took about 2 hours, all in (for verification, etc.).

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…