Wrong OFX File imported - easy way to clear those transactions out?

[WalterHeisenberg]

Hello,

We have a user who accidentally loaded an invalid OFX file. Is there an easy way to clear out this bad batch without going to the database doing doing a T-SQL delete? We are on Accpac 5.6 PU2. Thanks for your help in advance.

 

[Jay Converse]

Assuming the bank rec hasn't been posted yet, go to Bank Transactions/Reconcile Statements, and manually undo what the OFX import did.

 

[ettienne]

You can delete individual records from the Reconcile OFX screen or zap them in the SQL database.

 

[WalterHeisenberg]

Thanks! The table appears to be BKUNMAT if anyone should find themselves in a similar situation.