I am seeing quite a number of posts wondering about “Un reconciled field” shows a non-zero value and then how the system allowed to reconcile the statement.
As discussed in the previous post, unless the “Unreconciled” field shows “0”, AX will not allow to reconcile the statement. I’ve seen a number of posts wondering about “Un reconciled field” shows a non-zero value and then how the system allowed to reconcile the statement.
I saw a quite number of users who do the Reconciliation in an un procedural way i.e., Reconciling the back dated statements.
Elaborating my above statement, suppose a Reconciliation is done for the statement 30-June-12 , after doing June statement user enters the May month statement into the AX System. Also, sometimes, having both May and June statements in the grid and completing the June Reconciliation first and editing the May month Statement.
Above are the main reasons to Bank and GL not match as per the Bank reconciliation report. In this case, the Bank total balance and the control account total balances may match but the closing balance according to the “Bank reconciliation” report will not match with the Control account balance for the particular period.
Let me explain the problem clearly by taking our previous post’s reconciliation. we did a Reconciliation for the statement “30-Jun-12”.
Let us enter another statement dated 29-June-12 with ending balance -2000 USD( Just create a statement with the specific date and leave the record in the grid). Now, go to the 30-June-12’s reconciled statement and click the Transaction button and observe the change. The screen will appear as below.
when the user entered and ending balance of -2000 USD dated 29-June-12, system considers this as opening balance for the 30-June-12 statement which is reconciled. I’m really surprised why it is designed in such a way. Surely this will mess up the Reconciliation. That is the reason, sometimes you will see the “Un reconciled” field shows a non-zero value for “Reconciled” statements.
Hope this post may help you when you find problems in Bank Reconciliation. I had to do a lot of research on Bank reconciliation to solve one of My clients’s Issues. I have some more problems hidden in my brain which i wanted to put in this space but dont know how usefuld they are for you. By the way, this bank reconciliation procedure and problems remain same in AX2009 aswell ;).
If you are facing any problems in Bank Reconciliation, I invite your queries on the same. I hope i can help you. Please feel free to contact me for any clarifications. Your feedback on the posts is most welcome :).