Hi,
I have a custom Transaction Body Field (for Sales Orders). Free Form Text. "Stored Value" is unchecked.
I want to default the value from a saved search. I have a the Transaction Saved search the finds an "Item" on the transaction and I want the custom field, to display this "Item" value when using the UI.
I have my search successfully finding the appropriate transactions and the appropriate items. But, per an error I get, and per Netsuite documentation, searches must have a summary type in order for the custom field to derive a value from it. I can't seem to figure out how to set up the summary types to make this work appropriately.
I can return the Internal ID of the sales order and the "Item" values that I want. I have the search filtered to "Internal ID".
If I add a "Maximum" summary type to the "Item" column in the results, it will pull only the highest value Item value into the custom field across all sales orders. For example, it might put ZZ9876 in the custom field for all sales orders, even though the appropriate value for the others is different, such as AA1234.
Any advice on how to get this to work properly?