Create a BAQ similar to Stock status report

Ironically, this is a bad idea - you want to be smarter than the SSR. The SSR fails in that it looks to company settings for non-quantity-bearing (should use PartPlant settings) and forcibly excludes sales kits (which can still have OH qty).

Of course, you kind of need to mimic its failures just to know you made the BAQ correctly. And then mitigate the failures.

Also, I bring in the GL info for the part class for reference, since we use multiple inventory accounts.