Process Direct Debits; may fail to commit with "Record in table 'AccountTransaction' was not updated" error

The Process Direct Debits wizard may fail to commit with the error "Failed to commit Account Direct Debit Payments. Record in table 'AccountTransaction' was not updated. This record may have been deleted or edited by another User.".

This occurs if an underlying Account Transaction has changed between the time the Direct Debit was refreshed and committed. This can occur if the Account's Payment Method is changed from Direct Debit or the Direct Debit value of a transaction is changed/ cleared.

This issue should no longer occur, instead the Direct Debit line will be flagged as not exportable with the message "Transactions have changed.".

The wizard will report "Processing of Direct Debits was completed successfully. WARNING: [number] Transaction(s) have changed and could not be exported. Do you want to export these payments now?".

Note, there is a new property in the Business Layer, finAccountDirectDebits.TransactionsChanged, which returns the number of lines that failed to commit because of this issue. This could be used by a script to detect this issue.