Knowledgebase
[QODBC-Desktop] Troubleshooting - Refunding Credit Cards - There was an error when parsing the provided XML file.
Posted by Jack - QODBC Support on 24 November 2016 11:09 AM

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 am able to 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 insert are: CustomerRefListID, CustomerRefFullName, RefundAppliedToTxnTxnID

and yet the insert above fails. I made sure 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 below sample query & test again.

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

If you want to process Credit card refund, then you need to include CreditCard related information also.

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','ssf',1,'Completed','S-12347')

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

(0 vote(s))
Helpful
Not helpful

Comments (2)
Brandon Crowell
02 May 2017 03:23 AM
Similar issue with QuickBooks Desktop Enterprise 17.0. Able to create a CreditMemo but when attempting to create the ARRefundCreditCardRefundAppliedTo record I get a 3120 error. Object "DA..." specified in the request cannot be found. I've tried with the insert with the 4 fields noted above (CustomerRefListID, CustomerRefFullName, RefundAppliedToTxnTxnID,RefundAppliedToTxnRefRefundAmount). The RefundAppliedToTxnTxnID is equal to the CreditMemo.TxnID.

Anything additional I should be doing?
Jack
02 May 2017 07:40 AM
Hi Brandon,

I would like to share that you will receive error "Error: 3120 - Object "Object Name/ID" specified in the request cannot be found" when you are using invalid reference value in your query. In your case, I think you are passing the invalid value in the "CustomerRefFullName", So please check the value of "CustomerRefFullName" & test again. You can verify it from Customer table FullName column.

If you are still facing the issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:
http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages

Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).