Troubleshooting - Refunding Credit Cards - There was an error when parsing the provided XML file.

Problem Description:

Hello, I am trying to refund CC payments in QuickBooks. I can create the credit memo. However, when attempting to add the refund using the following, it fails:

Insert into ARRefundCreditCardRefundAppliedTo (CustomerRefListID, CustomerRefFullName, RefundAppliedToTxnTxnID) values('80001E51-1445438531', 'Dude, Aaron - Homes Financial,' 'C5B2E-1479513412 ')

According to the following: http://doc.qodbc.com/qodbc/usa/TableDetails.php?tableName=ARRefundCreditCardRefundAppliedTo

The only fields required on the insert are CustomerRefListID, CustomerRefFullName, and RefundAppliedToTxnTxnID.

And yet the insert above fails. I ensured that the three fields exist where RefundAppliedToTxnTxnID is the txnID of an existing credit memo. 

What am I doing wrong? 

Solution:

You need to include RefundAppliedToTxnRefRefundAmount in your query & test again.

Please refer to the sample query & test again.

Insert into ARRefundCreditCardRefundAppliedTo (CustomerRefListID, CustomerRefFullName, RefundAppliedToTxnTxnID, RefundAppliedToTxnRefRefundAmount) values('800000D0-1182061376', 'Allard, Robert,' '1B3D0-1513329686',123321)

To process a credit card refund, you must include CreditCard related information.

For Example:

Insert into ARRefundCreditCardRefundAppliedTo (CustomerRefListID, CustomerRefFullName, RefundAppliedToTxnTxnID,RefundAppliedToTxnRefRefundAmount, CreditCardTxnInfoInputCreditCardNumber,CreditCardTxnInfoInputExpirationMonth,CreditCardTxnInfoInputExpirationYear,CreditCardTxnInfoInputNameOnCard,CreditCardTxnInfoResultResultCode,CreditCardTxnInfoResultResultMessage,CreditCardTxnInfoResultCreditCardTransID,CreditCardTxnInfoResultMerchantAccountNumber,CreditCardTxnInfoResultTxnAuthorizationTime,CreditCardTxnInfoResultTxnAuthorizationStamp,CreditCardTxnInfoResultAVSStreet,CreditCardTxnInfoResultAVSZip,CreditCardTxnInfoResultCardSecurityCodeMatch,CreditCardTxnInfoResultReconBatchID,CreditCardTxnInfoResultPaymentGroupingCode,CreditCardTxnInfoResultPaymentStatus,CreditCardTxnInfoResultClientTransID) values('800000D0-1182061376', 'Allard, Robert', '1B3D0-1513329686',123321, '1234567890123456',5,18,'Test',1,'Success','a-436432','45522522',{ts '2016-05-05 00:00:00.000'},1,'Pass','Pass','NotAvailable','ss,1,'Completed','S-12347')

Note: Execution of the above requires the Company file to be subscribed to QuickBooks Merchant Account Services.