Does anyone know how to add mainline fields in the...
# suiteanalytics
m
Does anyone know how to add mainline fields in the item sublist on a saved search? I have a custom transaction that has mainline fields like 'TRAVEL', 'TAX', 'FREIGHT' that I would like to add to the 'Items' array. The goal is to create a sales order with line items for each Part Number as well as the Travel, Tax, Freight, etc. Formula I am using currently is: Summary Type: Group
CASE WHEN {custbody_travel} > 0 THEN 'Travel' WHEN {custbody_handling} > 0 THEN 'Handling' WHEN {custbody_taxes} > 0 THEN 'Taxes' ELSE NULL END
However, this is only returning the greatest value. Any thoughts would be much appreciated.