I currently have the Advanced bank reconciliation set to Yes. After imported the bank statement to D365, I noticed the date in the bank statement is not matching with From date / To date in D365.
Any help is greatly appreciated.
So what's your question? You still want to reconcile those transactions?
If yes you can either manually select those transaction and reconcile or set a reconciliation rule with grace period and reconcile.
I still want to reconcile those transactions.
The date on statement ID is correct, but the From date / To date are one day behind. For example, the statement ID shows as 2022-01-10T0001:00Z while the From date 1/9/2022 7:01:00PM.
I am not sure if this have anything to do with Time Zone Setting (current set as Auto).
I was able to manually do the reconciliation without any issue. The concern is when it closes to month-end period.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,004
André Arnaud de Cal... 865 Super User 2025 Season 2
Sohaib Cheema 582 User Group Leader