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: 293
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!
Previous Versions:
ClickCartPro 8
ClickCartPro 7
ClickCartPro 6
ClickCartPro 5.1
Offline
#2 01-08-2020 09:22:14
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