Import MT940 Bank statement text file to the Microsoft Dynamics NAV

Like (1) Share

Report

Posted on 2 Jan 2018 10:44:21 by Community Member

Dear all,

I just trying automate our bank req so in the proces our bank has given us a TEXT file which is called MT940 (standard structured SWIFT format) but we couldn't import this plain text file to the Microsoft Dynamics NAV.Please can you help me on this matter can you give me a step guide to do this it would be very help full. Below i have put the samples of our MT940 file

Sample

{1:F01NDBSLKLXAXXX7669000001}{2:I940NDBSLKLXXXXXN}{3:{108:1817010576.04}}{4:
:20:20170928-1
:25:101000215627
:28C:1/2
:60M:D170928LKR1338115,25
:61:1709060906CR1500000,00NTRF101000214503//FT17249TZ37S
Transfer
:61:1709070907DR1584,00NCHK302143//NDBACHIN-09-07
Inward Clearing
:61:1709070907DR4880,00NCHK302146//NDBACHIN-09-07
Inward Clearing
:61:1709070907DR670,00NCHK302153//NDBACHIN-09-07
Inward Clearing
:61:1709070907DR6020,00NCHK302160//NDBACHIN-09-07
Inward Clearing