This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Anyone have any idea of how to get the value for an inventory item's quantity on hand?  I've been trying a bunch of things this morning, but nothing is giving me the data that is visible on the page.

There is an Inventory Detail sublist (shows as locations on the record), on a Matrix Subitem Item that shows the bin, the on hand qty, and the available qty.  I'm just trying to get the value of the on hand qty.  But, I can't seem to get it via sublist or subrecords.  I've even tried working out through a saved search, but no luck...  Anyone dealt with this?

depending on your account setup and what type of inventory details you are working with

you can do an item search using the inventory detail  / inventory number/ inventory number/bin on hand joins

or you can go directly to a inventory numbers/ inventory details search

let me try those.  thanks.  My latest try was item &gt; inventory details &gt; qtys

it depends on what combination of lots/serials/bins you have

That part I don't know.  Just got into this system.  They just want to show their available quantity, minus a static value (for buffering).