cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member198450
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

But is there a way to configure SAP when the account number is non standard?

former_member198450
Active Contributor
0 Kudos

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