Hi Community!
I need your help in a bank statement reconciliation scenario. A company uses wire transfers (funds transfer from company bank account to vendor bank account via banking portal) to pay its vendors. They follow a business process where a vendor payment journal is posted in AX 2012 for example on 07/04/2020 however the actual funds transfer happens after a couple of days i.e. on 09/04/2020 via banking portal. Now when they match bank statement transaction dates with payment journal voucher posting date in GL, they find discrepancies because of the difference between posting date and funds release date.
Please suggest how can we mitigate this discrepancy in Dynamics AX 2012.
Hi,
Do you use the ordinary or the advanced bank reconciliation functionality?
Have you checked the bank parameter 'validate difference' where you can specify an allowed date difference?
Best regards,
Ludwig
Hi Ludwig,
The client uses ordinary bank reconciliation. No I am not aware of this parameter. Can you please elaborate the purpose and use of this parameter?
Its in the bank parameters form in the 'bank reconciliation' tab. Just check the date difference parameter and enter a number for the days that represents your difference. Based on the data shared above, this should be 2.
Can you try whether this parameter setting makes a difference?
Thanks Ludwig!
Your suggestion was really helpful!
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,100
André Arnaud de Cal... 890 Super User 2025 Season 2
Sohaib Cheema 633 User Group Leader
