You’re offline. This is a read only version of the page.
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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (