Wiki

CREDITCARD

None Defined

Credit Card Information not saved

Client enters Credit Card information in BP clicks OK but the information is not saved

Credit Card name in BP is longer then 20 Characters

Client can shorten the credit card name or run the following query in the database

Truncate Credit Card Names: UPDATE [@TWBS_CC_BPCC] SET U_CardName = Left(U_CardName,20) WHERE LEN(U_CardName) > 20

SELECT * FROM [@TWBS_CC_BPCC] (NOLOCK) ORDER BY U_CardName, U_BPCode

the second select statement is to run after. Need to make sure that there aren`t two cards names the same for the same BP Code

Solution

06 Sep 2012