You’re offline. This is a read only version of the page.
I have a bank rec report that shows a cash manager balance of approx. -17 Million. I cannot figure out where this number is coming from...I do see where it calculates that amount in the wrkcablances table, but I don't see any data to support that calculation.
I ran the queries from TechKnowledge Document ID: 125448 titled:
How is the CA Balance field calculated in Cash Manager Bank Reconciliation?
Queries and Results:
select CuryStmtbal - CuryOutstandingChk + CuryDepInTransit
from bankrec where bankacct = '1040' and GLPeriod = '201306'
--result 26044.45
select SUM(curyreceipts)-SUM(curydisbursements) from CashSumD
where CpnyId like 'USESCORP'
and BankAcct like '1040'
and BankSub like '100000000'
and TranDate > '2013-06-30'
and TranDate <= '2013-07-31'
--result 3399.12
These amounts sum to 29,443.57 and this is also what the bank rec screen shows.
Please help me understand how the report calculation can come up with -17 million and how I can fix this.
*This post is locked for comments
Elaine,
Thanks, this solved my problem. I had some records with a reconcile status of "O", but should have been blank. Once I updated these, the bank rec report looks great.
Kim
I will check.
Kim,
Are any of these transactions in the current date range?
Select rcnclstatus,* from gltran where batnbr = 'xxxxx'
Either one transaction or all but one transaction should have rcnclstatus of either C or O.
If reconciling by batch, then only one will have a C/O value. If reconciling in detail, then all but one will have a C or O.
Elaine,
I don't get any results for the first script, but I get 204 records for the second one.
Thanks, Kim
KC,
I wonder if you get anything returned when you run these scripts against the application database in management studio.
-- find catrans where ZZ records don't have rcnclstatus AND at least one non-ZZ has a blank rcnclstatus
select * from catran c where entryid<>'ZZ' and rcnclstatus=''
and batnbr in (select batnbr from catran where entryid='ZZ' and rcnclstatus='')
-- find catrans where ZZ records do have rcnclstatus AND at least one non-ZZ also has a rcnclstatus
select * from catran c where entryid<>'ZZ' and rcnclstatus<>''
and batnbr in (select batnbr from catran where entryid='ZZ' and rcnclstatus<>'')
Elaine,
The summary and detail reports do match.
The adjusted balance does match the bank rec screen.
A new bank rec is created every month, but the date gets changed throughout the month because the client is reconciling daily. In practice, it may really be every few days, but the thought is still the same in that the date is being changed throughout the month.
The detail report is only one page because this particular bank account has no items outstanding. It is an account that is used to fund several disbursement accounts, so the activity is 99.9% cash transactions and transfers that are entered and cleared within a day.
KC,
When you print the Summary report, now does that compare to the Detailed report?
Is the adjusted balance the same as on the Bank Rec screen?
Is there a single bank rec whose date gets changed every month or is there a new bank rec created for each month?
We do have bug23910 which says:
When a batch of transactions with the same reference number and amount cross a page, some of the items are dropped and the adjusted balance on the detail report is incorrect.
This has been corrected in the next release of SL. Here are the workarounds suggested:
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.
Ok, a few other things. The hotfix for Bug 25256 is installed. I've also looked at accthist vs. curyacct and they are in sync (although the GL balance isn't the issue here anyway).
And the report is pulling the amount directly from wrkcabalances, so it's not a report formula issue either.
The report is using the standard SL pre- and post-processes.
Should also mention, this is SL 2011 SP1
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (