MT940 / CAMT.053 using Bank Account to find customer

Hi @Arend ,

You need to define the Electronic payment address in the customer with the bank account (Account Number column) information for that Customer under the above payment method. Additionally in the External Payment parameter window you need to set the matching parameters as shown above. For the length column you need to provide the Length of Bank account number and for Interval From and To number columns Minimum and Maximum values that could be available for the bank account. For example if the Length of Bank account is 6 you can provide 000000 to 999999 for the From and To interval column respectively. 

Hope this will help.

Regards,

Akila

Hi Arend,

Electronic payment method option enable based on the Payment format. What is the payment format you are using? Generally Payment formats which will generate a payment file will enable Electronic payment address while payment formats that does not require account information such as Check will not enable the RMB option. You can check which payment formats has this by using RMB option Payment address presentation in the Payment formats window records. You can change the Payment address presentation using this RMB as well.

I agree with your second point and that is the reason we do not recommend using bank account as a matching parameter most of the time. But all of the Customer related parameters have same limitation and control. It is hard to define a static logic to look up the customer as different countries has different setup in related to IBAN, Bank Account or Tax IDs. However, if you can convince the customer to refer a fixed unique reverence no for each customer when making the payment you can map it to the Association No or Identifier reference in the customer.

Hope this will help.

Regards,

Akila