Bank Reconciliation shows reconciled transactions

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (9)

Answers (0)

cvrlori 34 on at

Like (0)

Report

RE: Bank Reconciliation shows reconciled transactions

We are experiencing the exact same thing! Did you find a solution?

Was this reply helpful? Yes No
Paula Spinweber SBA 10 on at

Like (0)

Report

RE: Bank Reconciliation shows reconciled transactions

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.

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

Thanks for the update Jerry, I will put this in my bag of GP oddities in case this situation ever comes up for me. I'm glad it was an easy fix for you!

Best Regards,

Josh Pelkola

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

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.

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

Okay,

If you find out the problem, I would be interested in hearing what the specific bits are on it.

Thanks,

Josh Pelkola

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

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,

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

Hi,

Yes, we clicked the reconcile button and printed the reconcile reports. Table CM20500 shows it has a 'RECONUM'.

Regards,

Was this reply helpful? Yes No
Josh P 2,895 on at

Like (0)

Report

Re: Bank Reconciliation shows reconciled transactions

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

Was this reply helpful? Yes No