Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 01-07-2020 17:58:39

polarize
Member
Registered: 11-15-2004
Posts: 265

eBay Order Cancel Refund Posting to QuickBooks Error

Hello,

We had to cancel an eBay order because the customer didn't use the correct shipping address and wanted us to change it.  Per eBay policy we asked the customer to request cancellation and reorder the product with the corrected shipping address which they did.

In K9 we cancelled the order and refunded.

Upon executing QBWC we received the following email error...

The following errors were encountered while processing requests for the QBWC accounting system. Reported errors will persist until resolved.

QBWC.addpayment.NUMBER-IDENTIFIERI:

There is an invalid reference to QuickBooks PaymentMethod "eBay" in the ARRefundCreditCard. QuickBooks error message: The payment method must be of credit card type.

We have seen this happen before nut I can't remember what we did in Raw Admin to fix it.  Is there something we can change in the PaymentMethod that would correct this and prevent it from happening anytime we have an eBay cancel and refund?

Thanks


Using Kryptronic K9! smile
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1

Offline

 

#2 01-08-2020 09:22:14

webmaster
Administrator
From: York, PA
Registered: 04-20-2001
Posts: 19386
Website

Re: eBay Order Cancel Refund Posting to QuickBooks Error

You should cancel the order next time instead of marking it as shipped and refunding it.  To resolve the QBWC error, execute this SQL Statement in Raw DB Admin using the Submit Raw SQL Statement function:

Code:

UPDATE ecom_payments SET acctsyspri='RECORDED', acctsysalt='RECORDED' WHERE id='NUMBER-IDENTIFIER'

Where NUMBER-IDENTIFIER is in QBWC.addpayment.NUMBER-IDENTIFIER.


Nick Hendler

Offline

 

Board footer