Formula for get Bill Credit amount where Bill Credit match with any of Bill applied on the current Vendor Payment

CASE WHEN {type}=’Bill’ THEN {amount} WHEN ({type}=’Bill Credit’ and {appliedtotransaction.internalid} in (‘1726′,’1733’)) THEN {appliedtolinkamount} ELSE 0 END

Leave a comment

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