Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
Reports: *Still* Useless...
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