web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / CA BANK RECONCILIATION
Microsoft Dynamics SL (Archived)

CA BANK RECONCILIATION

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Have you looked at the dates of the transactions you are trying to reconcile.

  • Community Member Profile Picture
    Community Member on at

    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.

  • Verified answer
    JLivingston Profile Picture
    JLivingston 39 on at

    [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.

  • Community Member Profile Picture
    Community Member on at

    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

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans