How many records do they have in the BKTRAN* tables? That will affect how long it takes.

We have the exact same issue with the bank rec module taking a long time to open and very slow clearing transactions and filtering o/s or reconciled.  Did you get this resolved?  Thanks

How many records are in your BKTRAN tables?

That question seems to scare them away :)

how do I see the BKTRAN table?  thanks

SQL Management Studio

Thanks - once you find the number of records what do you need to do?  Can you purge them?

Post a bank rec.

I'm not sure what you mean by that?  Do we need to delete old records in the transtable?  then try to post a bank rec as usual?

When you post bank recs, the records go away.  But you haven't answered the question yet - how many do you have?

In my case there are 33,000ish in the headers and 45,000ish in the details.  BKTRAN doesn't clear the records when you post a reconciliation.  You need to keep 7 years of records.  She posts reconciliations all the time.  

Are you suggesting we clear history?

Absolutely!  You can get all the bank history you need from APPYM and ARRRH.

I show 36000 and 23000.  Do either of you know how to clear the history?  That scares me!

Bank Services

Bank Periodic Processing

Clear History

Don't be afraid.

thanks for all your help!

in clear history do I check off bank trans, bank entries, and all posting journals?  Also how far back should I go?

Just trans and entries.  You should clear from the beginning of time through a reasonable time period wherein you might need to reverse a transaction, like 6 months ago.

worked like a charm!  Now I just need to figure out why I can't clear a deposit - comes up with an error of modified by another user and won't let me save after marked cleared

You have an invalid character in the BKTRAND.IDREMIT field. Special characters are not allowed: - ? ' " / \ ! @ # $ % ^ & * ( ) etc.

you are right - we do have a ' in the receipt No field - the ar batch is already posted.  how do we fix?

Edit the record and remove the '

how can I edit the record after it has been posted in A/R and G/L?

SQL management studio

in A/R or the bank?  what is the 5 digit identifier in sql mgmt. studio?

?