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
On hand Quantities in Run Rate search
Hi All
Me again! Sorry to trouble you once more with my issues. I was wondering if anyone can help. I have a run rate report which denotes how many items we have sold on a monthly basis.
When I try to add in any current totals - On Hand Quantity, Available Quantity, Quantity on Order, it does not work.
Because the fields are grouped, if I do not choose a summary type the column is not there, but if I do choose a summary type such as "Sum" then it displays the data in a strange way, for example I think that Sum adds up the current value of the stock rather than the Quantity. How do I display the Quantities currently in the warehouse and on order in a report such as this. Screenshots below, any help will be greatly appreciated: