Article Details
Id:11700
Product:finPOWER Connect
Type:FIX
Version:2.00.03
Opened:23/01/2014
Closed:13/02/2014
Released:04/03/2014
Job: J012777

Imported Bank Batch; fails to Delete batch after Transactions have been transferred to Suspense

An Imported Bank Batch fails to Delete after some (but not all) Transactions have been transferred to Suspense.

To recreate:

1. Import Bank Transactions.
2. Open the imported Batch.
3. Allocate one or more Transactions to an Account.
4. Click on the "To Suspense" button.
5. Click on the "Delete" button.
6. Click Yes when asked "Are you sure you want to PERMANENTLY delete this Batch?".

The following message appears "Failed to delete Bank Batch. Failed to execute SQL. The record cannot be deleted or changed because table 'BankAccountSuspense' includes related records.".