Amount difference in Advance Bank Reconcillation

(0) Share

Report

Posted on by Community Member

I am Getting Error while doing Bank Reconciliation kindly see the Screen Shot.

Or If we are matching "Same Credit Amount" With "Same Credit Amount" or "Same Debit Amount" with "Same Debit Amount" it's running Perfectly, but as per Bank Payment or Accounting Standard Amount in Cr. Side and in Bank Statement or in ( MT940 ) it is Amount in Dr Side to be Reconciled.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Taran,

Have you tried selecting the first line on the right-Hand side under the open bank documents and then select the 'match' button?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes i did.. But not Worked...

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Taran,

Ok, can you provide some more information on your setup? Such as bank account setup, matching rule setup, etc?

Can you also mention what AX System you are using R3 CU9/10/11?

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I am Using AX System R3 CU10 and Matching Rule that i am using Bank Transaction Code and Amount.

Taran

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Taran,

It is difficult to pin down what triggers the problem in your case.

I would suggest that you take a look at the following sites that give you some additional hints and insights and hopefully help fixing your problem.

stoneridgesoftware.com/how-to-use-advanced-bank-reconciliation-matching-rule-sets-in-ax-2012

blogs.msdn.microsoft.com/.../advanced-bank-reconciliation-setup-in-ax-2012-r2

axfinance.blogspot.de/.../advance-bank-reconciliation-in-ax2012-r2.html

technet.microsoft.com/.../jj729753.aspx

Would be great if you could keep us updated here.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
I Referred to MSD Advance Bank Reconciliation Whitepaper. I had a Main Issue that Dr amount will be Reconciled with Dr Amount,

If i am not able to Make u Understand then can we had a Video Call on Skype.... My Skype Id is TARAN_KATYAL .

.

Was this reply helpful? Yes No
Raj Thakkar 35 on at

Like (0)

Report

Hello Taran,

Standard Ax System matches Debit Statement with Debit Bank Document.

Here you are matching Debit with credit and hence you are getting this error.

If your requirement is that you want to match debit with credit and credit with debit then you have to do customization in bank statement import where amount from debit in bank statement should be inserted in credit of ax Statement and credit of bank statement should be inserted in debit of ax statement.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig & Raj,

Thanks for your reply and i will Discussed to my Technical Team.

Regards,

Taran

Was this reply helpful? Yes No
APG02 on at

Like (0)

Report

Hi Raj,

Withdrawals are always placed on debit side in bank statement while deposits are placed on credit side. So we have reconcile the debit amount as per our books with credit amount of bank statement and vice versa. Could you please explain the working of base AX in this regards, as why it backs matching of debit amount with debit amount, as due the mentioned issue, a very important feature of dynamics AX becomes useless.

Regards,

Anand

Was this reply helpful? Yes No
APG02 on at

Like (0)

Report

Hi Ludwig,

Even if we do manual bank reconciliation, it does not match the transactions in two data sources.

I want to know about base AX functionality regarding bank reconciliation where I matches debit amount as per our books with debit amount as per bank statement while withdrawal always placed on debit side in bank statement while deposit is placed on credit side. This is universally followed.

But if we consider the AX base functionality, it seems that some banks represent withdrawal as credit and deposit as debit. Could you please provide a sample of bank statement as per AX functionality.

Regards,

Anand

Was this reply helpful? Yes No