We have two cash transactions that are released and posted in GL but these transactions are not shown on the Bank Reconciliation screen.
Both of these transaction are not cleared on the Cash Transaction screen.
The transactions appear on the Daily Cash Balances screen and report.
Any ideas on why is this happening and how can I solve this problema?
*This post is locked for comments
Hello JLivingston
The field rcnclstatus is blank on both of these transactions. So I guess that is the problem. I'll check with Support to see what tehy tell me.
Thank you very much for your help
[quote user="MMaafs"]
We have two cash transactions that are released and posted in GL but these transactions are not shown on the Bank Reconciliation screen.
Both of these transaction are not cleared on the Cash Transaction screen.
The transactions appear on the Daily Cash Balances screen and report.
Any ideas on why is this happening and how can I solve this problema?
[/quote]
We have experienced this same issue and there were two different causes. The most common is the in the Bank Reconciliation screen, the third column titled Reconciliation Date, was not updated to today's date, therefore transactions with a date subsequent to the reconciliation date do not appear in the outstanding check list. Hopefully this solves your issue because the second cause is far more difficult. In the second scenario, the cash transaction was posted to the database with the cleared field empty rather than an O or a C. The O or C will determine if it shows up as a cleared item in the bank rec or an outstanding item. If it is null, it does not show up in either. You cannot fix this, you will need intervention form Microsoft SL support. They are aware of this issue and supposedly fixed it a few years ago.
We did find that by not selecting the "post by batch", the problem has not reoccurred.
Hello Mubiru
Yes I did check the dates and both of them are from march, 2016. And they do show on the daily balances screen and report.
Have you looked at the dates of the transactions you are trying to reconcile.
Share
Report
All responses (
Answers (
35