Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Bank Reconciliation ma...
Microsoft Dynamics AX (Archived)

Bank Reconciliation matching rules

(0) ShareShare
ReportReport
Posted on by jasontl 275

Hi all,

Suppose I have this case which I need to import and activate the auto-bank reconciliation.

> bank statement line with document no. such as '1500520'

> bank transaction line with payment reference such as 'BID1500520'

How can I make use of the bank reconciliation matching rules to achieve this?

I have tried several methods like using Contains, =, <>, Begins with also does not work.

Can someone advise? Or does this have to be customized beyond standard?

Thanks in advance.

*This post is locked for comments

  • 72camaross Profile Picture
    72camaross 275 on at
    Bank Reconciliation matching rules
    I also have this issue of leading zeros from the bank statement, but there are no leading zeros in my bank account transactions in D365fo.

    Has anyone found a workaround?
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bank Reconciliation matching rules

    Hi Veronika,

    I have the exact same problem as your #1. Leading 0s on the statement but not in AX. I know this post is quite old. I'm wondering if you ever found a solution for this?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: AX2012R3 Financial - Bank Reconciliation matching rules

    I was wondering if you could please help?

    I am trying to set up a rule that is

    "Statement description contains cashbook payment reference",

    this however gives me nothing, if I however change it to  payment ref to

    "Statement description contains cashbook desctription",

    this rule then works, my problem though with this is that in our live environment the transaction description contains additional info to that which appears in the bank statement description where as the payment ref will be the info that is on the bank statement.

    Is this a possible bug where you can only match the statement description to the cashbook description?

    I would have thought it would be able to match to other fields since they are available as matching options.

    Thanks in advance

  • Veronika Filonenko Profile Picture
    Veronika Filonenko 1,255 on at
    RE: AX2012R3 Financial - Bank Reconciliation matching rules

    Hi,

    There seem to be a lot of hotfixes for BankRec.

    I found on LCS website that a penny difference is NOT allowed on all document types only on Electronic payments... Isnt it a interessting information to know..?

  • Veronika Filonenko Profile Picture
    Veronika Filonenko 1,255 on at
    RE: AX2012R3 Financial - Bank Reconciliation matching rules

    Hi,

     

    I have couple of problems with the basic criteria which i can't make work.

    1-Additional criteria: i have check numbers with leading zeros coming from statement line, in AX i have the same check number with no zeros. I want to map

    Field:  Document number                    1234

    Operator: Contains

    Statement fields: Reference No.   00001234


    System cannot find a match

     

     

     

    2 a)- Check difference of amount : system does not respect my criteria of 0.01 allowed. (On the bank form the penny difference is allowed 0.01. just to let you know) The system can't find a match. I have an additionnal criteria where Amount = Amount. So even if i take out the Amount = Amount rule still when i ran my rule for Checks, this check with the penny difference is not being picked.  

    3- Check difference of day: does not respect my criteria either. I set my threshold on 5 days. So if my Statement date is the 20th of July and the AX bank statement is the 14th July, making it a 6 day difference, regarding the system made a match.

    (sorry i cant seems to joint my screen shots)

     

  • Munib Profile Picture
    Munib 2,500 on at
    RE: AX2012R3 Financial - Bank Reconciliation matching rules

    Have you tried to use "Ends with" operator. It will a search by *1500520.

    Sounds like you are searching the bank transactions from the statement transactions. Which is supported.

    The other way around is not supported.

    What are your other rules? Maybe provide a screenshot or detail the rules you have set up.

    They maybe stopping it from working.

  • Veronika Filonenko Profile Picture
    Veronika Filonenko 1,255 on at
    RE: AX2012R3 Financial - Bank Reconciliation matching rules

    Hello,

    Have you found an answer to your problem? If so, please share?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans