Bank Services error from upgrade from 5.5. to 5.6 2

[vbdbcoder]

We are trying to upgrade from 5.5 to 5.6 and we got errors from Bank Services.

The error message is:

Bank GENERAL has damaged withdrawal data. You must clear withwrawal # 16567 and post the bank reconciliation before you can upgrade Bank Services.

We checked that that check was clear.

Whatelse should we look at to get the Bank Services upgrade throught?

Thanks

 

[Jay Converse]

How do you know it's cleared?

 

[vbdbcoder]

It does not show up on Bank Reconciliation. It was clear 2 years ago.

 

[vbdbcoder]

We also looked at Payment Register Report. The status is clear.

 

[DjangMan]

Look in the BKCHK table and see if it is still in that table.

 

[vbdbcoder]

Yes, that specific record (withdrawal # 16567 ) is in that table.

 

[DjangMan]

What are the STATUS and RECSTATUS field values?

 

[vbdbcoder]

STATUS = 3 and RECSTATUS = 5

 

[Jay Converse]

Just delete it from that table.

 

[vbdbcoder]

Great! it works. Thank you tuba2007.

Just out of curiosity, what caused the transactions in BKCHK hang??? any idea?

 

[Jay Converse]

Nope, and after doing it two or three dozen times, I don't care either, it was dirty data from obsolete programs.

 

[ramam1]

The obsolete bit is probably Accpac 5.5 banking

 

[vbdbcoder]

Things are good and we have upgraded to version 6.0A. Since we removed those dirty records in BKCHK table in version 5.6A.

Now BKCHK table is gone in 6.0A.

How do I get BKCHK table back, by running what modules and transactions in Accpac? - this might be a very simple questions.

I am a developer, not an Accpac consultant, and one of the applications I have to deal with is to read from BKCHK table. Now I am getting "invalid object - 'BKCHK'" error.

Thanks

 

[DjangMan]

BKTRANH and BKTRAND.

 

[vbdbcoder]

What modules to run in Accpac to create BKCHK table?

 

[DjangMan]

BKCHK is no longer used in 6.0. You'll get those transactions that used to be in BKCHK from BKTRANH.

 

[vbdbcoder]

oh!!!

We wrote to BKCHK table records from our application as well. How do we deal with this change? Do we need to populate the BKTRANH and BKTRAND both?

As previous versions, I don't believe VBA code can provide any hints on views...

 

[DjangMan]

Macros don't record in Bank Services so you'll likely have to go the long way and turn on rvSpy and manually work through the code.