MT940 Bank Statement Import

Question

Hello I am interested in starting a dialog with someone that has a client or an end-user that is using the Bank Statement Import (MT940) in a live environment that is described in the video below. 
 https://youtu.be/s-06luh7_c0 
 Thanks, 
 Kevin

John de Kock · Answer

It works pretty well out of the box. You may/will have to tweak the segment definitions depending on how your bank delivers the file. In this particular case I had to accommodate the fact the the statement arrives within a SWIFT transmission wrapper, but was easy to get around that. The other issue was that multiple statements arrive within a single transmission, so you have changing segment identifiers on the :60F: and :62F: records. Once you realise that the statement import loads the data into the BSIIMP and BSIIMPD tables, it is pretty easy to map incoming data to fields in these tables. 
 My best tip would be to work on getting the statement to import as a flow type of 'Reconcilliation Only' under 'Bank Import settings' Get that working before you even attempt to use Standard or 'Post Validation Transfer' flows. 
 At this stage my biggest challenge is getting some information on the BSILIB functions, which you can use to transform your imported data.

Sage X3

MT940 Bank Statement Import

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING