on 2021 Oct 26 9:54 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
39 | |
8 | |
6 | |
5 | |
3 | |
3 | |
2 | |
2 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.