Show Total Discount in Invoice using saved search

Select Formula (Currency)

Summary Type: Select Sum

Formula: Enter Case when {item.type} = ‘Discount’ then {amount} when {applyingtransaction.linesequencenumber} = ‘2’ then – {applyinglinkamount} else 0 end

Custom Label: Enter Total Discount

Leave a comment

Your email address will not be published. Required fields are marked *