|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| XML error applying Credit Card payment |
| Author |
Message |
|
|
| Posted : 2006-08-03 03:30:39 |
I have succeeded in creating an invoice and automatically applying a payment to it, but when I try to populate the credit card number field (ReceivePaymentLine.CreditCardTxnInfoInputCreditCardNumber) I receive the following error:
Error parsing complete XML return string.
I found a related post addressing this error message, but it is not relevant to this situation since, as you can verify below, my columns are in the order specified by "sp_columns ReceivePaymentLine"
Here is the SQL that pukes. It works a dream if I simply remove the column CreditCardTxnInfoInputCreditCardNumber.
INSERT INTO ReceivePaymentLine ( CustomerRefListID, TxnDate, RefNumber, TotalAmount, PaymentMethodRefListID, Memo, DepositToAccountRefListID, CreditCardTxnInfoInputCreditCardNumber, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, FQSaveToCache) Values ( '4C30000-1151698106', {d'2006-07-23'}, '1152620275', 33.35, '50000-1151531136', 'Approval 007382', '410000-1151594272', '************2015', '2EB-1154539373', 33.35, 0)
Thanks for any help.
Paul |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-08-03 10:50:40 |
Sorry, this is a QODBC bug.
20060802.170655 I 2440 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3540).
20060802.170655 E 2440 XercesSAXErrorHandler Not enough elements to match content model : '(CreditCardNumber,ExpirationMonth,ExpirationYear,NameOnCard,CreditCardAddress?,CreditCardPostalCode?,CommercialCardCode?)' -- error at line 7, column 491 in XML data.
20060802.170655 I 2440 MsgSetHandler Parser error, finishing.
20060802.170655 I 2440 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3540), ret = 1.
You need to leave CreditCardTxnInfoInputCreditCardNumber off your payment insert for now. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-08-09 13:53:20 |
Ok, apparently the deal on Credit Card information is that if you list any field that starts with CreditCardTxnInfoInput or CreditCardTxnInfoResult then you must include all the following fields:
CreditCardTxnInfoInputCreditCardNumber, CreditCardTxnInfoInputExpirationMonth, CreditCardTxnInfoInputExpirationYear, CreditCardTxnInfoInputNameOnCard, CreditCardTxnInfoResultResultCode, CreditCardTxnInfoResultResultMessage, CreditCardTxnInfoResultCreditCardTransID, CreditCardTxnInfoResultMerchantAccountNumber, CreditCardTxnInfoResultReconBatchID, CreditCardTxnInfoResultPaymentGroupingCode, CreditCardTxnInfoResultPaymentStatus, CreditCardTxnInfoResultTxnAuthorizationTime, and
CreditCardTxnInfoResultTxnAuthorizationStamp
So I thought I give it a go by doing:
INSERT INTO ReceivePaymentLine ( CustomerRefListID, TxnDate, RefNumber,
TotalAmount, PaymentMethodRefListID, Memo, DepositToAccountRefListID,
CreditCardTxnInfoInputCreditCardNumber,
CreditCardTxnInfoInputExpirationMonth,
CreditCardTxnInfoInputExpirationYear,
CreditCardTxnInfoInputNameOnCard,
CreditCardTxnInfoResultResultCode,
CreditCardTxnInfoResultResultMessage,
CreditCardTxnInfoResultCreditCardTransID,
CreditCardTxnInfoResultMerchantAccountNumber,
CreditCardTxnInfoResultReconBatchID,
CreditCardTxnInfoResultPaymentGroupingCode,
CreditCardTxnInfoResultPaymentStatus,
CreditCardTxnInfoResultTxnAuthorizationTime,
CreditCardTxnInfoResultTxnAuthorizationStamp,
AppliedToTxnTxnID)
Values ( 'AE0000-1197765289', {d'2007-12-23'}, '1152620275', 20,
'50000-933272660', 'Approval 007382', '80000-933270541',
'5123512451245124', 1, 2007, 'Tom Aczel', 1, 'Manual Authorization',
'1111104', '1111105', '1111106', 1, 'Completed',
{ts '2007-12-23 14:00:00.000'}, 123, '5C68-1197762228')
But I can't see if it works:
Let me know how you go! In the meantime, I will try to find a method of doing the insert without processing the Master Card payment.
|
|
|
|
|
|
| Posted : 2007-02-01 09:19:42 |
| Is it known yet if it is possible to apply a credit card payment to an invoice without processing the credit card? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-02-01 09:43:24 |
| Yes, do the payment as if it were a check (cheque) using the card number as the check number. |
|
|
|
|