UNKNOWN and DECLINED Payflow Pro transactions

If you encounter an UNKNOWN status, check the Payflow Pro website to verify the transaction exists there. If the transaction does not exist there, delete the transaction from iMIS. If the transaction does exist there, run the following statement:

Update Trans
Set CC_STATUS=’ ‘, CC_AUTHORIZE=’ ‘,DESCRIPTION=’ ‘
Where TRANS_NUMBER = XXXX and
TRANSACTION_TYPE = ‘PAY’

To select UNKNOWN or DECLINED transactions, run the following statement:

Select BT_ID,AMOUNT,TRANSACTION_TYPE,CC_STATUS,CC_AUTHORIZE,DESCRIPTION
From Trans
Where TRANSACTION_TYPE = ‘PAY’ and CC_STATUS <> ‘’ and DESCRIPTION <> ‘ ‘ and CC_AUTHORIZE in (‘DECLINED’,’UNKNOWN’)

For additional information on Payflow Pro integration, see the Payflow Pro developer's site.