MSchuette Red Ribbon

That does help, thank you very much for looking into it!

Good to know, thank you for the response.

Setting Location with a workflow is not a problem for me, but what I was trying to do is on the Location subtab on the bottom of the Item, set a particular Location's "Classification" to "C" by default.

Bump. 636 votes and still waiting. Could be one of the most useful tools, is 2nd most popular request. Why won't they do this? C'mon NetSuite!

Thank you for the replies. We do have a lot of inventory, so the scripting solution is probably not efficient for us, but I was able to use JCirocco's idea and get something that will work for us. Thanks!

JCirocco's idea worked well, but the one problem I was running into was that it was including drop shipments (which we do a lot of for inventory we don't have in stock). Since they are 0 available they were showing up in the search even though they have not recently gone out of stock. I found you can search Item…

Thanks michoel. But I think NVL will just remove and replace null values, not a value of zero, right? For us, we do have a few price fields that have zero in them, so technically are not null, and I wanted to not include them in these search results. But I appreciate the response and for a lot of people I'm sure that would…

I just discovered to use LEAST instead of MIN for a formula in NetSuite, which is why my attempts were failing. That led to: Least ({custrecord307},{custrecord13},{custrecord15},{custrecord17},{custrecord19},{custrecord21},{custrecord23}) which worked but returned null values, so I came up with this: Least ((case when…

Good call khultquist, thanks!

Thank you for the reply. But sorry, I probably did not explain well. We are not trying to sort the Items, but within each Line, for each Item, it shows all the Bin Locations where that Item is available. I want to sort those Bin Numbers within that one item line.

Definitely not the best, no. In this regard, worse than the old way the Sandbox worked. But I appreciate the help, thank you!

Thanks, and I would think so, but since the change when I log into my Sandbox Administrator role and go to any employee, they all have Give Access already checked, and have their required roles. Yet only Administrators have a Sandbox Role, and only their Administrator Role. Would I have to refresh the sandbox with the "All…

Can anyone help on this? Is there any way to do this? Seems like it should be simple but maybe I'm just missing it.

Thank you for the response. Yeah, we can do that, but I was hoping to affect the each line item on the PO, not just the total. This way, when we receive in each part on Item Receipts, they will be received in at the actual discounted amount we paid for them. Therfore, our average cost and last purchase price on the…

Thank you, I will look into that.

You could create some new Center Tabs, and you can add more Trend Graphs on each of those. They'd just have to click over to see other Trend Graphs.

Anyone out there using WMS Lite that would have any info on this? Thank you.

I noticed this alternating in certain places too. I put a formula using a case statement in a custom field looking up a check box value in another field, and used the same case statement in a search result. One needed F to work, and one needed False to work. I can't remember which was which now. Now when I write a formula…