Upload account statement MT940 incorrect

[Stanco]

I got a account statement from the service provider PayJoe. The format is MT940. I upload the account statement in the app: Manage Bank Statements. In the app I click on upload, select the format MT940 and click process. Then the protocol shows me an error. 

Termntn during import: Statement no. missing (rec. type :28:): Acct XXXXX XXXXXXX

When I look in the Account statement I identify the rec. type :28C: . But it is mentioned more than one time. It is mentioned seven times. But is always like this:

:28C: 0

I found out that :28C: describes the part of the account statement. The structure of account statement is:

:20:STARTUMSE
:25:
:28C:
:60F:,
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:62M:
-
:20:STARTUMSE
:25:
:28C:
:60M:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-
:20:STARTUMSE
:25:
:28C:
:60F:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:61:
:86:
:62F:
-

Can someone please help with explaining me how I can use the app Map format Data to create a new template for this MT940 format?

Kind Regards

[bjansen]

28C contains the statement number. If this is always 0 you should ask the service provider if they can activate the numbering. Otherwise you will need to update it yourself (badi/userexit)

[VijaykumarV]

Hi Stanco,

You need to put statement number in 28C and  if same statement has multiple parts, you need to put same statement number plus sequence number. If its a different statement, put only statement number. Also don't put random numbers, you have to use statement number given in bank statement MT940 and make sure its not already used in the system for particular bank account.

You can cross check what statement numbers are already uploaded for particular bank accounts in FF67.

Please check and if you still get error, please put full error message.

Regards

Vijaykumar

[VijaykumarV]

Hi Stanco,

28C is a Bank statement number and It seems your MT940 file has multiple bank statements in single file. You can upload multiple bank statements in single MT940 file but make sure 28C is different for each line. Also it should be different from your existing uploaded bank statement number as same number cant be uploaded again.

Please check and upload, it should work.

Regards

Vijaykumar

[Stanco]

Thank you Vijaykumar,

[Stanco]

Thank you Vijaykumar, I tried to enter different variations for :28C:. Like 00001/001, 00001/002. First one is bank statement number. Second one ist the number of the part of the bank statement. But that doesnt work.

[Anita_Ahmadpour]

Hi @Stanco ,

For more information about the Map Format Data for Incoming Files from Banks configuration activity, see the following help content, please: 

• How to Create a Format Mapping
• How to Adjust Your Format Mapping
• Map Format Data for Incoming Files from Banks

I hope this helps. 

Best regards,
Anita

[Chuma]

Hello @Stanco ,

To create a new MT940 format template using the Map Format Data app in SAP S/4HANA Cloud Public Edition, follow these steps:

1. Access the Map Format Data app via the Finance – Bank Integration scope item (‏1J2‏).

2. Click Create Mapping Template, select MT940, and define your source structure.

3. Use the Structure Mapping and Field Mapping tabs to align the MT940 fields to your internal data structure.

4. Save and activate the mapping for use in Manage Incoming Payment Files (F0770)

Alternatively, follow this link,

https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-sap/structured-format-for-fi...

Thank you and kind regards

Chuma