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:
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).
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:
I am creating orders, invoices and payments through QODBC. The first two parts are working fine, orders and invoices for those orders are created successfully. However, I am having difficulties with payments...
Here are the queries I am running:
INSERT INTO ReceivePaymentLine (AppliedToTxnTxnID,AppliedToTxnPaymentAmount,FQSaveToCache) Values ('1CB13-1221433494',5,True)
INSERT INTO ReceivePayment (CustomerRefListID,CustomerRefFullName,ARAccountRefListID,TxnDate,RefNumber,TotalAmount,PaymentMethodRefListID,Memo,DepositToAccountRefListID,IsAutoApply) Values ('8000046C-1220841945','ZealdWebFlo2Cash0809','80000-1154528786',{d'2008-09-04'},'ORD0011971',5,'50000-1154528844','Zeald order ORD0011971 QB order 1CB02-1221179209 QB invoice','800000DB-1221444859',True)
(Invoice with TxnID 1CB13-1221433494 exists – I am checking that right before the query. )
Here’s the SDK messages:
20080916.093807E8180XercesSAXErrorHandlerElement 'AppliedToTxnAdd' is not valid for content model: '(CustomerRef,ARAccountRef?,TxnDate?,RefNumber?,TotalAmount?,PaymentMethodRef?,Memo?,DepositToAccountRef?,CreditCardTxnInfo?,(IsAutoApply|AppliedToTxnAdd+))' -- error at line 7, column 597 in XML data.
SQL Statement: INSERT INTO ReceivePayment (CustomerRefListID,CustomerRefFullName,ARAccountRefListID,TxnDate,RefNumber,TotalAmount,PaymentMethodRefListID,Memo,DepositToAccountRefListID,IsAutoApply) Values ('8000046C-1220841945','ZealdWebFlo2Cash0809','80000-11545287
86',{d'2008-09-04'},'ORD0011971',5.63,'50000-1154528844','Zeald order ORD0011971 QB order 1CB02-1221179209 QB invoice','800000DB-1221444859',True)Error parsing complete XML return string (8)
Sorry, but you will need to use the QODBC v9.00.00.250 Beta with QuickBooks QBi series 2008/09 (see: Release 9.0.0.250 Fixes ). Your trace shows QODBC v8.00.00.243.
TO RECEIVE A PAYMENT, THE SQL STATEMENT FORMAT IS:-
I have upgraded to QODBC v9.00.00.250 Beta and restructured the query. But I'm still getting nowhere... here's the SDK messages and the trace:
20080918.105627 I 8032 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 1296). 20080918.105627 I 8032 SpecVersion Current version of qbXML in use: 6.1 20080918.105627 I 8032 QBSDKMsgSetHandler ADD: Receive Payment 20080918.105628 E 8032 ReceivePaymentStorage::VerifyInvoiceTxnID The TxnID doesn't match an invoice to pay for the specified customer:job and AR account or the invoice is already paid.: 1CC28-1221627374 HRESULT=0x80070057 20080918.105628 I 8032 QBSDKMsgSetHandler Request 1 failed. 20080918.105628 I 8032 MsgSetHandler Finished.
The problem is that the invoice 1CC28-1221627374 does exist and it is not paid. The AR accounts used for the invoice and for the payment are the same. Any suggestions?
Try using just DepositToAccountRefListID, without ARAccountRefListID. The QuickBooks error is saying: "The TxnID doesn't match an invoice to pay for the specified customer:job and AR account or the invoice is already paid."
Absolutely positive. I am running a chain of actions that create Order, Invoice (for that order) and then the Payment (for the invoice). I have tried the sequence many times from scratch so there is definitely no payment for that invoice and 100% sure I am using the same CustomerRefListID.
