MT940, segments 60M and 62M, instead of 62F

SOLVED

Hey, we are having some bank statements splitted with 62M and 60M segments, for MT940 file format. Any one knows how to configure the format and respective segment?

  • +1
    verified answer

    Hello,

    So the 60m and 62M segments are equal to de the 60f and 62F segments, so that way, the first step is to create these two segments.

    After creating them, you should configure the format of the file. I've used the v12 Standard file to start and then introduce the other segments with the correct value accordingly to the bank statement format.

    In my case, I placed the 60M under the 60F segment and the 62M above the 62F segment. 

    On the Destination table and operation it should be like:

    • 60M - Header - Create
    • 62M - Header - Update

    After that, you need to parameterize the bank import settings and import the file.

    I hope it works for you! 

    Thank you

  • 0 in reply to Rodrigo Jeronimo

    Hi Rodrigo,

    I have the case where the statement has two messages within. The following segments are in one stamement/file to import:

    20

    25

    28C

    60F

    61

    86

    62M

    -}

    20

    25

    28C

    60M

    61

    86

    62F

    64

    Do you know how to configure this format into Sage?

    If I don't have this format in other statement - statement with two messages - this means that I need a second MT940 format defined?

    Thank you.

  • 0

    This occurs when the MT940 file contains multiple statements.  The first statement starts with 60F and the last statement ends with 63F. To me, the M indicates 'middle' i.e. there is another statement following in the file.

    You can use one of 2 approaches.  Set up  separate segment definitions that match the identifier exactly, or change the identifier to read "60 (3 characters, followed by a 1 character dummy and then a 1 character identifier of : in position 5