https://netsuiteprofessionals.com logo
#suiteanalytics
Title
# suiteanalytics
j

JR

04/13/2022, 7:34 PM
In a transaction saved search of type sales order, If i have main line set to no, is there a way to reference a field in the "main" record of the sales order. for example the main "Location" field. I would like to display it, and filter by it. thanks.
m

mattdahse

04/13/2022, 8:16 PM
I don’t think you can do this as written. The location field will be different for mainline result rows vs non-mainline result rows because they’re essentially the same column in the database.
j

JR

04/13/2022, 8:22 PM
@mattdahse Thanks for you response Matt. Yeah, makes sense that that specific field wouldn't work. I wonder if there is anyway to join onto that "mainline". We have a custom field that sits in the "sales information" section on the top of the sales order. there has to be a way to reference that? No?
m

mattdahse

04/13/2022, 8:24 PM
Yes, almost any other field would be represented on the lines even if it were a body field. Location, class, department, etc are special cases.
j

JR

04/13/2022, 8:25 PM
ah, gotcha. I'll give it a shot, thanks. any new books on the way? i enjoyed your last one...
m

mattdahse

04/15/2022, 3:57 PM
Ha! No new books on the radar, but I am doing some in-person training soon.
💪 1
2 Views