I have a custom record, with a Currency Field derived from Saved Search:
The Saved Search is a Transaction Search:
When run on it's own, it returns a large value (as expected as there are no filters applied),
And the Custom Field in the Custom Record shows the expected amount (the search filtered by the Call Off Name field)
However, as this is a Custom Field sourced form a Search and the Value is not stored, I cannot source the value of this field into a field on a Sales Order Transaction (which is where I need this value visible - and ideally accessible to Sales Order workflows so that I can query it).
I thought I should be able to create another Custom Field on the Sales Order transaction and source it from the same search? However, whenever I try this the results are blank. I have a dropdown field on the Sales Order to select the relevant Call Off (from the Custom record):
And I have tried leaving the 'Field' drop down blank, or putting in Call Off Name in there, but neither will allow the new custom field to source from the Search based on the Call Off Name.
Should this work? Am I missing something obvious?
Or do I need to look into Client Scripts to source the data from the Custom Record (or the Search) and display it on the Sales Order?