Hi @MSu thank you for the response .
When there is no currency match it should check the match for the last 4 digits of the “account” in Remit_ID field and return the Supplier_ID corresponding to that .
For eg. For the above data , if we have currency as “BRA” and account number as “987893456” then Supplier_ID - SUPPLIER_CONNECTION-3-2345 should be the extracted.