Skip to Content
avatar image
Former Member

Process bank statement for UK bank key and account with missing /

We have a MT940 format file sent by a bank where the '/' is missing from the bank sort key and account

We use Barclays and the 25 line in the statement is 123456/12345678 which uploads fine in FF_5

The new bank statement is send as 12345612345678. The bank is saying this is standard and they cannot add the /

How can I process the file, can a '/' be added to the 25 line by a code change

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 05, 2017 at 03:11 AM

    Hi,

    In the configuration of house bank, bank account field should have account number as per the statement. in case its mismatch system will not accept the file.

    Please check FI12 or FI12_HBANK

    and in transaction OT83, check Assign Bank Accounts to Transaction Types

    When you import the file in FF_5 for reconciliation system program read account number once the account number as per the statement(MT940) found in system it start processing the import file, In your case system is design with \ whereas bank doesn't don't provide the same in tag 25.

    Hope this helps you. Feel free to write back to me.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      Bank has provided the correct statment, why you want the system to change and have / in first place? In case still you want to change then it will be big development change for the program which is used in FF_5.

      Regards,

      Jain