Hi,
I have reconciled the September Bank Statement. When I start October, all the September Reconciled transactions still show. I didn't see any help for this in KB.
Has anyone ever ran into this?
Thanks
*This post is locked for comments
Have you experienced the issue you described ever again? I have this happen every month in some GP companies, but not all GP companies and not the same GP companies (we have 92 production companies). So if we don't clear out the contents of the CM00002 table each month after the bank recs are done, the check-marked items will show again on next month's screen. We are running GP2016 R2.
Hi,
My issue was that the Reconciliation Process was interupted before the Transactions in Temp Table CM00002 were cleared out. Therefore, they were still showing in hte next month's reconciliation. Deleted the transactions in the table and all was fine.
Hi,
Yes. There are transactions in CM20200 associated with the 'RECONUM'. I believe it is a GP issue, I was just wondering if anyone has ever seen this.
Thanks for your help,
Hi Jerry,
Have you tried checking whether there are transaction associated to that reconciliation id?
SELECT * FROM CM20200 c
WHERE c.RECONUM = <your recon number>
If there are no transactions here, there could be data corruption, or the reconcile button was selected without marking the transactions in the bank reconciliation module.
If there are transactions present, you may consider consulting with your GP partner since it seems there might a problem with GP instead. I've not come across any configurations in the bank rec module that would allow you to view previously reconciled transactions that have been properly recorded in GP.
Regards,
Josh Pelkola
Hi,
Yes, we clicked the reconcile button and printed the reconcile reports. Table CM20500 shows it has a 'RECONUM'.
Regards,
Hi Jerry,
I assume you clicked the "Reconcile" button on the reconcile bank statements in GP when finished with September? Are you using different dates for the bank statement ending and cutoff?
Regards,
Josh Pelkola
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
