I said it before and I'll say it again: Reports in NS are absolutely, positively, emphatically useless!
Here's a great example.
We have two locations for inventory: Sales and Main.
I have a user who wants to simply run a report that provides them with a current list of items AND their respective serial numbers, currently in inventory (so they can match it against what's physically there).
OK, I go an run the Inventory Physical Worksheet report. so far so good. Let's add Location as a grouped item so the user can see the quantities in each location. Wow, guess what, they list them correctly except that there are quantities of zero with serial numbers (they were inventory items in Main but were assembled and are now in sales as assemblies). OK, let's put a filter in that says only show on hand quantities of 1 or more (to get rid of the zero). Wow, that worked, except now even though I see two serial numbers aside an item that currently has 2 on hand, the quantity on hand says 12! and every other quantity on hand is whacked out as well. Remove this filter and I get the right quantity but see line items that should not be there. Wow, unbelievable how something like this at version 12 is so pathetically screwed up.
OK, I'll run an Inventory Status report. Works a little better. I see the locations and I see the serial numbers. Hmmm, when the location drop-down in the report is set to only sales, I see the total for sales but I SEE THE LINE ITEM FOR THE ITEMS IN MAIN WITH THEIR SERIAL NUMBERS (Even though the quantity on hand is zero). I try to set a filter to not show any line items with zero quantity but that doesn't work because the Main location does have a quantity greater than zero (EVEN THOUGH I'M CURRENTLY VIEWING SALES LOCATION ONLY).
I give up! One hundred and some odd reports in NS and my clients use ZERO of them. They all have reverted to saved searches. How ridiculous is that!
If there is a way, it is in no way intuitive for the average user and I consider myself to be reasonably experienced with NS at this point and I can't figure it out. What a humungous waste of time and resource energy and after subsequent versions and releases, no improvement.
Reports are THE ULTIMATE thing every client wants once they commit to putting everything into an ERP system. It represents the heart and soul of what the company is doing yet to extract ANY USEFUL INFORMATION IS IMPOSSIBLE. It can't possibly be this bad, can it?