Article Details
Id:13073
Product:finPOWER Connect
Type:FIX
Version:2.03.00
Opened:07/07/2015
Closed:07/07/2015
Released:09/07/2015
Job: J015863

AccountFunctions, StatusDeclinedToQuote and StatusUnwantedToQuote; not handling Accounts that aren't Declined or Unwanted

The finPOWER Connect Business Layer functions StatusDeclinedToQuote and StatusUnwantedToQuote in finAccountFunctions aren't handling Accounts that aren't Declined or Unwanted respectively.

Instead of returning an error that the Account Status is invalid, the script is left with a database transaction open and that error is returned.

The following code snippet demonstrates the issue:

  ' Account L10000 is Open
  If Not finBL.AccountFunctions.StatusDeclinedToQuote("L10000") Then
    Main = False
  End If

This produces the error "The script left an uncommitted Database Transaction open. This Transaction was rolled back. The Script has been forced into a failed state.".