I am trying to identify items in our warehouse that have on hand quantities in a bin that is NOT their preferred bin. I'm using an item search to try and filter down to only list items that have a Bin On Hand: On Hand qty greater than 0, and where the Preferred Bin is False. however, I still get values of on hand quantities in my report for the preferred bin and its quantities. I'll include a short video in the thread of the criteria, an example item record, and the results produced. I've also tried doing a inventory detail search, and inventory numbers search, but with no success.

@Tim_Pedersen I'm not sure if this will help you, but here's a SuiteQL query that returns items that are in alternate bins.

SELECT
	BUILTIN.DF( Item ) AS Item,
	BUILTIN.DF( Bin ) AS Bin,
	OnHand
FROM
	ItemBinQuantity
WHERE
	( PreferredBin = 'F' )
	AND ( OnHand > 0 )
ORDER BY
	Item

I hope that helps.

@tdietrich I'm embarrassed to admit that I don't know how to do that.

You can download this script which will let you run queries in NetSuite: https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/

Thank you @tdietrich. I have made several attempts to correctly implement this script, but haven't had any success. To preface, I haven't done this before. Here's a video of what I've attempted so far. Would you be so kind to show me what I am missing? https://www.loom.com/share/dbfc433b00bd41198cf5ff5d3a2bc5fe

@Tim_Pedersen Take a look at this: https://rmnsug.files.wordpress.com/2020/09/2020.9.16-tips-tricks-suiteql-1.pdf It's from a presentation that was made to the Rocky Mountain NetSuite User Group. In it, the presenter gives good instructions on installing the script.

that's funny. That's exactly what I was using. I can't seem to figure out how to run the script in Netsuite. Is that tool a pop up window, or perhaps a portlet on the home dashboard I would need to create? I embarrassingly haven't figured that part out yet.

Ahh... On the deployment record, you should see a URL. Just click it.

No worries. Thanks for the tip. I clicked the link and got the following error message - "type":"error.SuiteScriptModuleLoaderError","name":"MODULE_DOES_NOT_EXIST","message":"Module does not exist: /SuiteScripts/SuiteQL_Query_Tool_Suitelet.js","stack":[]}

The URL that you'll want to click is here:

Thanks!

No problem.