On a sales order on a search result what column would give me the status as 'SalesOrd:A' or is that even possible?
g
Gregory Jones
03/21/2019, 2:53 PM
You could use a case statement
Gregory Jones
03/21/2019, 2:53 PM
The 'A' is the 'orderstatus', which isn't available as a result in a saved search
j
JohnnyC
03/21/2019, 3:01 PM
Thanks. I had built out lib file for statuses and was using these on records but the search returns something different. SalesOrder:G is billed but a search would return fullyBilled, just have to find out the text strings for a search result and extend my lib file a little
That's more or less what I have but more complete so thanks for that. Now I want to have the corresponding result for a status column in a search result. So Sales Order:Billed -> SalesOrd:G -> fullyBilled (on search result).