Payment File Conditions

[Former Member]

I am creating a payment file and need to add conditions. If an the IBAN is blank I want add the Payee bank account number, but if the IBAN is present I want to include the IBAN

Any help in choosing the right condition, much appreciated.

Thanks

Nathan

[Andie]

Hi,

I have recently faced a situation that is similar. I couldn't find any workaround and each time I was trying to put a condition, the file creation failed. If anyone has a solution for this it would be much appreciated.

Thanks,

Andréanne

[Former Member]

Alexandre

Thanks for your response.

What i need to do is add a condition on line 4 that brings in either the IBAN or the account number, as the suppliers have a mix of IBANS and account number and the payment file requires either the account number or IBAN in position 4 of your example above.

Can field conditions be used to do this?

Regards

Nathan

[alexandre_colombo]

Hi Nathan,

As far as I'm concerned, the payment file fields are not mutually exclusive. Meaning that if you define the field in the structure, it will consume a position in the resulting payment file either way (with or without content).

If you want to include the bank account number and also show the IBAN when it exists, I assume you can simply add the data sources in the file structure. If there is no IBAN the delimiter will still be populated.

For example, if you use comma (,) as a field delimiter and a file has structure as follows: ID, amount, currency, IBAN, bank account

Below are two transactions. First one has account number but no IBAN (note that the 4th position for the IBAN still exists, but its blank)

Second has IBAN but not account number.

BEGIN
100, 966.000000,USD,,1234569
101, 877.000000,USD,GB55LOYD99999999999999,
END

Regards,

Alexandre.

[former_member200567]

Hi Alexandre,

As far as I remember, a field (column) is actually omitted if the condition is not met for the field.

Best Regards,

Fred