In bank recon, we have cheque which status is Printed generated by payroll module but not posted long time ago and we cannot post it but want delete this line. How to clear it in Bank Reconciation?

Because it's Printed, I cannot change the status to whatever outstanding, cleared, reversed at all. When I tried to delete this line, showing error: Bank Reconciliation  Incorrect procedure. You cannot delete a Withdrawals which has not been entered through bank.

Accpac 54A (SP3).

Any tips? Thanks in advance.

They are supposed to clear automatically when you post the bank rec, but not always.  Just edit BKCHK with a database editor and delete the records with a "9" status.

 Right, not automatically cleared for us. What's database editor? How to do that? Could you please explain more details? Thanks, NICE Jay!

Pervasive: Pervasive Control Center

SQL2000: Enterprise Manager

SQL2005: SQL Server Management Studio

If you don't know what those are, contact your local geek.

 My field is accounting and I tried to fix it by myself. But it seems I have to ask some IT guy. Anyway, thank you very much, Jay!

 It worked. I have it done by myself just now. Great thanks to Jay and the forum!