Is there any way on a Report (Sales by Item) that displays "Current Quantity Available" and "Current Quantity on Order" to define the locations that these fields pull from? NetSuite just lumps every location into it. Trying to isolate locations simply breaks the report.

you have to use the “Location Available” and “Location on Hand” fields. Not sure if those are available in reports, but you can get to them in a Saved Search. I recommend using the Inventory Location field as well so you can see which location the quantities are related to.

Yea, report doesn't work exactly the same. I REALLY hate reports.

I hate reports too. I typically go straight to Saved Search for anything that is not a financial report.