Skip to Content
0

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

Apr 04, 2017 at 03:20 PM

160

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jain varghese Apr 05, 2017 at 03:11 AM
0

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,

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0