Banging my head against the wall here. Trying to find a way to have a search return the Selling Price from a sales order as well as the actual COGS cost from a fulfillment. No matter which option I have tried I either get the Sales Order total amount ("Created From... Amount") or NULL (Applying or Applied To Transaction... Amount.
I even tried creating a Custom Transaction Column field that sourced from the sales order but if will not show on the fulfillment line.
Is this even doable? Should I do the Search from the Sales order to start?
Appreciate all the expert help.