Click on this link for the poll.
How to display the relevant information in other columns in the saved search
Hello NetSuite Guru,
In the Item saved search, I want to group by the Internal ID and only get the row with the minimum of Location On Hand. Then the other columns should display the relevant information with that location on hand:
I create the columns in the result as below:
My report can group the data by Internal ID and show the minimum Location On Hand, but it could not show the other information relevant to the Location On Hand:
Could you please help me how to show the expect data in the Member Item and Member Line columns as in the first image?