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