Has anyone found a meaningful way to use and/or extract data from the Relationships tab on a Sales Order record?
We don't use it generally because it is hard to use and (seemingly) impossible to report on.
However, SuiteCommerce Advanced stores the Contact who raised the online order in the Relationships subtab.
I cannot find a way to access this Contact via Saved Search or Workflow. The closest I have come is a Custom Field sourced from a Saved Search which will show the name of the contact as plain text - but this cannot then be used in any subsequent searches or workflows as it is sourced from a search.
I found this article relating to opportunities:
Retrieve Contact Value Under Relationship Subtab of an Opportunity Record Using Workflow Action Script (custhelp.com)
I tested this script - adapting the 'get company' section to pick up the Entity of the Sales Order - but there is nothing I can see in the script that references the Relationships subtab. All that script appears to do is search for all Contacts linked to the Company, and then return the ID of the first one found?
(I appreciate Opportunity fields may behave differently - we don't use them so I am not overly familiar with them).
Is there any documentation on how this Relationships subtab is meant to be used or referenced - in particular with Transactions?