Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

CA BANK RECONCILIATION

Posted on by Microsoft Employee

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?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CA BANK RECONCILIATION

    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

  • Verified answer
    JLivingston Profile Picture
    JLivingston 35 on at
    RE: CA BANK RECONCILIATION

    [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 Microsoft Employee on at
    RE: CA BANK RECONCILIATION

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CA BANK RECONCILIATION

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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans