Skip to Content
0

Payment File Conditions

Feb 24, 2017 at 02:39 PM

81

avatar image
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

capture.jpg (46.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Alexandre Colombo
Mar 02, 2017 at 07:10 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
avatar image
Former Member Mar 08, 2017 at 06:36 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Andreanne Trudeau Mar 15, 2017 at 11:58 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded