When doing a search, is there a way to visually co...
# beginnersc
Caleb Fong
04/08/2021, 10:53 PMWhen doing a search, is there a way to visually collect all of the same item together, kinda like how the reports do?
I've tried to use the
GroupCountk
KevinJ of Kansas
04/09/2021, 12:07 AMUse your sort orders
KevinJ of Kansas
04/09/2021, 12:08 AMIf you want one result per item you group by item
KevinJ of Kansas
04/09/2021, 12:08 AMJust have to make sure no other fields are grouping
c
Caleb Fong
04/09/2021, 4:32 PMThis is what I'm trying to weed out.
Caleb Fong
04/09/2021, 4:33 PMAnd in the "dumb question" section, Sort is not the same as "Group" right?
k
KevinJ of Kansas
04/09/2021, 4:55 PMLooks like you are grouping by item rate
KevinJ of Kansas
04/09/2021, 4:56 PMand by last purchase price
KevinJ of Kansas
04/09/2021, 4:57 PMyour profit percentage column is all jacked up too
KevinJ of Kansas
04/09/2021, 4:59 PMI'd also be tempted to see if "display name" is the same for all the items (i.e. do you have more than 1 item with the name "HG PLUS 25"
c
Caleb Fong
04/09/2021, 5:05 PMyeah the profit percentage is a trash fire of incomplete data in our inventory items. Part of the point of this is to find where we need to fill in the essential gaps.
Caleb Fong
04/09/2021, 5:06 PMI am marking several of the fields as "group" so they appear in the view of the results. It's the only why I know to do this.
Caleb Fong
04/09/2021, 5:08 PMThe values in the Name column are the NetSuite 'Item Number' so they should all be unique. Which is partly why I'm confused about why I see several of them together.
k
KevinJ of Kansas
04/09/2021, 5:13 PMdo "Max"
KevinJ of Kansas
04/09/2021, 5:13 PMinstead of "group" - but you should note - your grouped prices that are different won't show up there.
KevinJ of Kansas
04/09/2021, 5:13 PMMight be worth doing multiple columns "Min" and "Average" too - so that you can see that there are different amounts making it up
c
Caleb Fong
04/09/2021, 5:20 PMGood idea. Thanks @KevinJ of Kansas
2 Views