cancel
Showing results for 
Search instead for 
Did you mean: 

Customer / Supplier ID recognition after Bank Statement upload

piotr_krol
Explorer
790

Hi,

I am working on developing an import of a bank statement based on the MT940 file. What should I do for the system to recognize the customer / supplier ID based on the bank account number contained in the bank statement file?

My bank statement has been successfully imported into the system. The system reads the bank account number but does not assign a customer / supplier ID. Should I handle this in a script that reads data from a file?

Many thanks for any advice

Piotr

Accepted Solutions (0)

Answers (1)

Answers (1)

frank_jahnigen
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Piotr,

We understand you are developing a custom statement modelled after MT940.

Bank statements are localization- and sometimes house-bank specific.

An identification of business partners via bank account in MT940 DE for example would be facilitated via IBAN match in block :86: and business partner master data.

Field ?31 would hold the IBAN of a payer and would lead to an automatic identification.

Field ?32 typically holds the business partner name, if provided. A match should lead to an automatic identification.

Hope this helps,

Frank