I want to create saved search or report of Sales Order Transactions that show me Margin and Margin %. Brief: Need Margin and the Margin % Formula: Total sales value (Excl. GST) – total costs + freight) = margin value The costs of Imported items and purchased items comes from Std cost

To get %margin and margin you need to compare the Item Fullfillment to the Invoice. IF {appliedtotransaction.type}=‘Item Fulfillment’ THEN {amount} END Compare to IF {appliedtotransaction.type}=‘Invoice’ THEN {amount} END

Can you tell me how can create the search for this?