Finance | Project Operations, Human Resources, ...

Unreconciled statements exists. These must be resolved before advanced reconciliation can be activated

(0) Share

Report

Posted on by Majd rami

Hi,

When we try to enable the Advanced bank reconciliation, we get this error message

Unreconciled statements exists. These must be resolved before advanced reconciliation can be activated.

How to reconcile the history of transactions before activating the advanced bank reonciliation and importing bank statements?

Thank you in advance.

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Majd rami,

Sounds like; you were performing manual reconciliation with a bank account but now you are changing it to set for advanced bank reconciliation process.

Before doing that; please check first in Unreconciled transactions form in this bank and what are the transactions are still not reconciled.

After that, check in Account reconciliation form if there is any new line / lines are created for reconciliation purpose. If created; then check in Transactions form, what are the lines already marked to reconcile.

Now you can do the following.

--- In Transactions form; first remove the tick marks from the lines which are already marked to reconcile.

--- Then delete the line itself.

Point to be noted: - Make sure there should not be any transactions available in the "Unreconciled transactions" form for this bank before you are trying to enable the Advanced bank reconciliation check box. If still any posted transactions available; then please reconcile them first.

Kindly check and provide your feedback.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

delete or completely reconcile historical statements on the bank and then system, would allow to enable advanced

use bank reconciliation option from bank account

Was this reply helpful? Yes No
Majd rami 20 on at

Like (0)

Report

We have never reconciled bank accounts, we have third-party software that processes reconciliation by integrating transactions from D365.

Now we want to use the Cash and bank management and we are facing the volume of historical transactions of the 3 years to reconcile

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Majd rami,

Thanks for the update.

Now going ahead, this reconciliation you will be completely doing in D365 or in both including 3rd party application?

D365 will only allow you to set a bank account with Advanced bank reconciliation mode when there is no transactions are pending to reconcile.

Also... why need to do 3 years reconciliation? Do you mean to say that; no reconciliation happened in last 3 years in that 3rd party application?

Appreciate if you kindly share this information as highlighted so that can be convenient for the members to provide solution.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

would be another option to create a new bank account, mapped to same GL and start using it for adv bank reco and keep old as it is for historical purpose

Was this reply helpful? Yes No
Majd rami 20 on at

Like (0)

Report

Hello Sourav Dam,

Thank you for you reply.

When checkin, the list of unrecoliced transactions contains all Bank transactions from the date of D365 deployement.

as i already mentioned, during this period, reconciliation was always done on the 3rd party application.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Majd rami,

You may need to check with the developer if running a job can clear all these transactions from this page and set all these as 'Reconciled' so that you can go ahead with the same bank account in D365.

Else, as Rahul suggested; you can create a new bank account and map with the same main account and set the Advanced bank reconciliation check box enabled and keep the old one as it is carrying the historical records.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Majd rami 20 on at

Like (0)

Report

Thnak you Rahul Mohta for the proposition

Was this reply helpful? Yes No
Majd rami 20 on at

Like (0)

Report

Thank you very much Sourav Dam for your help.

We will try to create the job for editing the reconciliated status

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hello Majd rami,

Kindly keep us posted.

Will be waiting for your next update on this.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No