Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
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. Register now
Orders that COULD HAVE shipped - Per day
I want to make a saved search that shows the number of packages that COULD have shipped per day, vs the number of packages that DID ship per day. The idea being, I want to see when our volume grows large enough that it exceeds the physical abilities of our shipping team, implying that its time to add another shipping employee to the shipping staff
For example:
Date---------Eligible to Ship----Actually Shipped----%Efficiency
1/15/2013----51---------------40------------------79.4%
1/16/2013----53---------------41------------------77.4%
1/17/2013----35---------------35------------------100%
The column for "Actually Shipped" is easy...because you can just group fulfillments by date.
But, how would I count the number of orders that COULD have shipped? per day?