Microsoft Dynamics AX (Archived)

Bank Reconciliation matching rules

(0) Share

Report

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

I have the same question (0)

All responses (7)

Answers (0)

Veronika Filonenko 1,261 on at

Like (0)

Report

Hello,

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

Was this reply helpful? Yes No
Munib 2,500 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Veronika Filonenko 1,261 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Veronika Filonenko 1,261 on at

Like (0)

Report

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..?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
72camaross 320 on at

Like (0)

Report

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?

Was this reply helpful? Yes No