Finance | Project Operations, Human Resources, ...

bank account reconciliation issue in AX 2012 R3

(0) Share

Report

Posted on by Vinesh Tandel

582

Hey All,

we have encountered below issue, relevant screen attached for references.

There is an issue with the bank account HSBC reconciliation.

Journal "Rappro HSBC 10/19" was posted without any transactions, so AX thinks the ending balance was 0 and this is why unreconciled balance is showing as negative amount of ending balance of "HSBC 10/19 (oct 2019)" journal.

Ending balance of "Rappro HSBC 10/19 (oct 2019 )" journal is 0 and that's why system puts 0 as opening balance in "HSBC 11/19 (nov 2019)" journal (November reconciliation).

This is wrong, so data can't be reconciled. Please advise the solution for a correct November opening balance.

"HSBC 11/19(nov 2019)" journal is not posted, so can it be modified or recreated if it will be necessary.

Thanks in advance !

All responses (3)

Answers (0)

Suggested answer

Vinesh Tandel 582 on at

Like (1)

Report

RE: bank account reconciliation issue in AX 2012 R3

Hey all the solution is found testing in progress :

The second journal which has caused the issue. Once record date is cleared on it then it is possible to delete the wrong journal from front end which makes the third journal we have is correct with correct opening balance.

Follow above screen to follow second journal and third journal for reference.

Thanks.
Vinesh Tandel 582 on at

Like (0)

Report

RE: bank account reconciliation issue in AX 2012 R3

Yes it was posted without any transactions.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: bank account reconciliation issue in AX 2012 R3

Hello Vinesh,

Can you clarify this issue a bit.

You mentioned that you posted a journal 'Rappro HSBC...' without any transactions?

How can?

What kind of journal is that and where was it posted?

Would be great if you could provide more information on what happened.

Many thanks,

Ludwig