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

Was trying to exclude a location that has inventory for items, and it wasn't working until i switched things up and started using Location Available, instead of Quantity Available.

Gotta be careful with those multiple joins for non duplicated data

but this is generally how I do it here as well.

Oh, it duplicates the results...not sure if that is a no no for the use of this search.

Hopefully it can be summarized without issue, and I'll put a W in the win column for myself.