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.

maybe you need an additional custom body field that sources from a Saved Search that distinctly listaggs/ns_concats the values from the line item field? i'm not too familiar with custom fields and sourcing tho so just spitballing here

A script that groups the values of the custom transaction line fields into a custom transaction body field (type of Long Text - that is searchable globally) is possibly the most eligant solution. That transaction body field could even be hidden (I am pretty sure even if a field is hidden it is still searchable - or you can add it to the system information tab out of the way).