Skip to Content
avatar image
Former Member

Payment File Conditions

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 02, 2017 at 07:10 PM

    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.

    Add comment
    10|10000 characters needed 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

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2017 at 11:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded