Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Filter transaction search to only display max value
I've got a transaction search with the following criteria:
Date is within last month
Type is Sales Order
Item : Type is Inventory Item
On the result side, I'm summarising columns:
Date Group
Item Group
Quantity Sum
This works fine and gives me the total number of any given item sold on each day.
I now need to refine this further, so it only shows the row with the highest quantity sold for any given item. Basically, we're trying to identify how much stock needs to be available in a given location in order to satisfy typical daily demand.
Can anyone shed any light on how to do this?
0