Is it possible to store the total COGS per line item in the sales order without scripting? I have a custom transaction line field but I don't see an option to use a summary saved search or to use a formula to join to the related item fulfillments.

Can you use the COGS amount field?

On the formula field of the custom transaction line field?

It should be a field in the saved search. i think its just {cogsamount}

But summary saved search can't be used in custom transaction line field. Applicable only in transaction body field

Does this work?

Thank you. I got error field not found for the applyingtransaction.type. Are joins allowed here?