Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Advanced bank reconcil...
Finance forum
Suggested answer

Advanced bank reconciliation MT940

Posted on by 10

Hi all,

I'm currently having trouble with the setup of the reconciliation part of MT940.

The setup for importing an MT940 file is done and importing a file is not a problem, but I can't reconcile the imported MT940 file.

Here is the setup I've already done for the reconciliation part:

- I created a bank transaction type

- Created a bank transaction code mapping

- Created a reconciliation rule

- Created a method of payement

- setup all the number sequences in the cash and bank parameters

When I run the matchin rules or the matching rule set, I get this error message:

"0 statement lines have been matched according to matching rule MWBD"

What is going wrong here?

Thank you.

Categories:
  • Kyra Philipsen Profile Picture
    Kyra Philipsen 10 on at
    RE: Advanced bank reconciliation MT940

    If I send you the information in tag 61 from the MT940 file, would it be possible to tell what needs te be filled in in the matching rule,...?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation MT940

    Hello Kyra,

    Please have a look at the following MS docs sites that describe the matching rules in more details

    docs.microsoft.com/.../set-up-bank-reconciliation-matching-rules

    Setting up those matching rules is not easy and if this is not correctly done, no matching will be found.

    Best regards,

    Ludwig

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: Advanced bank reconciliation MT940

    Hi Kyra,

    What is this bank transaction type value '00100' stands for in matching rule?

    In your imported statement no such value is showing!

    Best regards,
    Sourav Dam

  • Kyra Philipsen Profile Picture
    Kyra Philipsen 10 on at
    RE: Advanced bank reconciliation MT940

    Hi Ludwig,

    I've adjusted the Matching Rule, but I still get the same message.

    Adjusted-Matching-rule.png

    Error-message-deel-3.png

    Thank You

    Kyra

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation MT940

    Hi Kyra,

    Your allowed date difference is 0 days but the payments are posted 17 June while the bank statement is from 1st June...

    Best regards,

    Ludwig

  • Kyra Philipsen Profile Picture
    Kyra Philipsen 10 on at
    RE: Advanced bank reconciliation MT940

    Hi,

    Thank you, now I get a list of payments:

    Error-Message-deel-2.png

    But when I run the matching rule it keeps saying that there are no statement lines matched.

    Is there something wrong with my matching rule or...?

    Thank you,

    Kyra

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation MT940

    Hi,

    Many thanks for your screenprints.

    If I look at your last one, then I can see that the section on the right-hand side is empty.

    That must be because there is no payment against the bank posted.

    Can you test posting a customer or vendor payment against this bank account and open the form again?

    You should then see a line to reconcile.

    Best regards,

    Ludwig

  • Kyra Philipsen Profile Picture
    Kyra Philipsen 10 on at
    RE: Advanced bank reconciliation MT940

    Here are my screenprints

    - Bank transaction type

    Method-of-payment.png

    - Bank transaction code mapping

    Bank-Transaction-Code-Mapping.png

    - Reconciliation Rule

    Reconciliation-rule.png

    - Method of payment

    Method-of-payment.png

    -Number sequences

    Number-Sequences.png

    - The error message I receive

    3660.Error-Message.png

    "Have you recorded customer and vendor payments in a customer/vendor payment journal against the bank account for which you imported your statement?"

    is the necessary when I want to do the reconciliation with matching rules as automated as possible?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Advanced bank reconciliation MT940

    Hi,

    Unfortunately, we cannot see your screenprints.

    Please save them as pictures and upload them via the 'use rich formatting' form.

    About the advanced bank reconciliation function:

    Have you recorded customer and vendor payments in a customer/vendor payment journal against the bank account for which you imported your statement?

    About the setup:

    Please have a look at the following sites that contain some sample file for testing purposes.

    docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans