We know that you can make custom transaction body ...
# suitescript
a
We know that you can make custom transaction body fields global searchable, is there any intelligent solution for making a custom transaction item column line field global searchable? in the scenario that for all transaction item lines the data in the custom column field is unique? I can potentially think of a couple creative solutions, but wanted to get some input from the brain power here. Thanks.
e
One option would be to create a custom field to hold all of the line item column field data. Maybe use a script to loop through each line and update the custom field when the record gets saved
Like if your column was called "color" you could make a custom field called "All Line Colors" then use a script to set the custom field to each of the line colors. And make the "All line Colors" field globally searchable
a
This was also my first idea 😃 Thank you!