Does anyone know how to pull an accurate report for inventory details items I'm having issues and I know this is something that NetSuite falls short in. I'm trying to pull just items that show status = rejected Qty = Greater than 0 I tried to run something but I'm getting false information where the saved search is reading expired items as rejected and it's pulling in all qty for inventory details. It's hard to determine what is actually rejected vs what once was but is now not. My joiners for inventory details : status = is the only place where I can pull the actual status. I don't know what to do here. Should manual work go into this to check the data? Has anyone else found a way to do it successfully on one SS? HELP ME PLEASE... haha

Have you looked at Inventory Balance search instead? It will replicate what you see on an Item's inventory if you go the item.

No I haven't

I had the same issue recently and Inventory Details search was giving me bogus inventory detail. I had to switch everything over to an Inventory Balance search and was able to get the actual item's inventory detail. You may have to take a look at your search and make sure its all good column wise and its not looking for some kind of join.

HAHA. Same boat my friend