This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Trying to create an Item Saved Search that shows last Transaction date and that type of transaction per item. For the date I can just create a summary type Max Date, but for the transaction type if I do Summary Type Max, won't it just pick the "Max" transaction type name, not that actual last one that matches the max transaction date?

So for example I have an item that last transaction date was 9/25/17, and the max type is a transfer order. But on 9/25/17 no transfer orders took place, but because it is the one with the max first letter in the alphabet it comes back as the max transaction type.