I wanted a summary of transactions containing certain items that would display their item options.
First I created a transaction search however it was unable to actually display the value that was in the custom item options we had created (despite the option being selectable, I guess it needed to be under Item field: custom item option).
The work around that I found was to create an item search that then displays mostly transaction fields, this works fine however it has one major issue, the links on the search lead to the item (because it is an item search) not the sales order.
I did attempt to create a stored value custom link item on the transactions and display that (tranaction body field), however using {transid} the link worked from the transaction but not from the dashboard search as the tag was not being populated.
(Link item was something like (I did have a shorter more accurate version but I do not have it to hand) : https://system.netsuite.com/app/common/search/ubersearchresults.nl?quicksearch=T&searchtype=Uber&frame=be&Uber_NAMEtype=KEYWORDSTARTSWITH&Uber_NAME={transid} )
My next attempt was to use a workflow to update the field, however I could find no way to get the workflow to update the field using the {transid}, if I used static value option the transid tag was not replaced, and if I used the formula I got an error.
Does anyone have any suggestions?