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

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) / Cash Manager Detail Ba...
Microsoft Dynamics SL (Archived)

Cash Manager Detail Bank Rec Report

(0) ShareShare
ReportReport
Posted on by Community Member

I have a customer on SL 2011 FP1 with an issue with the Cash Manager Bank Reconciliation Report - Detail Format.  This report is reflecting an out of balance situation when the Reconciliation and the Summary format both are Balanced.  The out of Balance is specific to 1 check contained in a batch of AP checks.  I can't find anything unusual related to the APDOC, APTRAN, or GLTRAN records for this specific check.  Does anyone have any suggestions?

Thanks!

Michelle

*This post is locked for comments

I have the same question (0)
  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    Is the date the check was written in a different period from the period to post in the GL? That is one possible issue.

    Specifically relating to the detail report, the field definitions are these:

    Create Date: generally identifies the release date of a transaction and the update date of a daily cash balance. General Ledger posting could occur on or after this date.

    Tran Date: identifies the date of the transaction record and equates to the transaction date of a daily cash balance

    Pd to Post: is the financial period to post of the transaction record and equates to the period number of a daily cash balance.

  • Community Member Profile Picture
    Community Member on at

    Butch - Thanks for responding!  The Period to Post is correct for the Period that is being reconciled in Cash Manager and also equates to the dates on the transactions for all of the checks in the batch.  What is odd is that there are approximately 30 check transactions in the batch and only 1 is causing an issue on the report.

    Thanks!

    Michelle

  • Community Member Profile Picture
    Community Member on at

    Bug 23910 says:

    Bank reconciliation detail report drops detail and shows an incorrect adjusted balance when the detail  happens to fall at a page break

    This was first reported in ver 8 and is fixed in our next 8 release.  Here is the workaround:

    1.  Select the Detail format

    2.  Click on the Sort tab

    3.  Put a page break on wrkcadetail.rcptdisbflg

    4.  Print the report with this modification on the sort tab

    An alternative would be to:

    In Crystal reports for 2063d, choose Report>Section Expert. Select each line on the left and see if the box is checked to Suppress Blank Section. If it is, remove it. Not it is not likely that you would need to remove this from all lines but I can't be more specific about exactly which lines should be removed so remove them all.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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