|
Buy Support
Incidents |
|
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: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
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). |
|
Click Here
|
Buy Support
Incidents |
|
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: |
|
Click Here
|
|
| Error parsing complete XML return string , inserting in BillPaymentCreditCard table |
| Author |
Message |
|
|
| Posted : 2007-10-21 05:52:07 |
HI,
I have a VB6 application where i can pay a bill with credit card. I am trying to sent that payment into Quickbook Pro edition 2006 and i get the following error message : "Error parsing complete XML return string".
This is the code :
Vgstr_sql = "INSERT INTO BillPaymentCreditCardLine (PayeeEntityRefFullName , APAccountRefFullName, " & _
"CreditCardAccountRefFullName , RefNumber , memo , FQSaveToCache)" & _
"VALUES ('" & Trans_HotelName & "','Accounts Payable', '" & TxTCardNumber & _
"','" & Txt_RefNumber & "','" & Txt_Memo & "'," & Str(1) & ")"
objCmdSupv.CommandText = Vgstr_sql
objCmdSupv.Execute
Vgstr_sql = "INSERT INTO BillPaymentCreditCard (PayeeEntityRefFullName , APAccountRefFullName, " & _
" CreditCardAccountRefFullName, RefNumber, memo) " & _
" VALUES ('" & Trans_HotelName & "','Accounts Payable','" & TxTCardNumber & _
"','" & Txt_RefNumber & "','" & TxT_Memo & "')
objCmdSupv.CommandText = Vgstr_sql
objCmdSupv.Execute
At execution, at this point receive the message. When i review the SDK message i found the following :
Not enough elements to match content model : (PayeeEntityRef,APAccountRef?,TxnDate?,CreditCardAccountRef,RefNumber?,Memo?,AppliedToTxnAdd+)' -- error at line 7, column 348 in XML data.
Please , I need help.
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-22 08:46:47 |
Sorry your insert statements are invalid. Payments must be also applied to a transaction. According to:
sp_columns BillPaymentCreditCardLine
the columns that are required on an insert are :-
PayeeEntityRefFullName, CreditCardAccountRefListID or CreditCardAccountRefFullName, RefNumber and AppliedToTxnTxnID
See: How can I apply check payments or credits to bills? for more details on how payments are applied.
|
|
|
|
|
|
| Posted : 2007-10-26 05:34:59 |
I tried adding the TxnID of the bill to be paid, but now i received a new error message : " Error 3180 : The transaction is Empty" .
Please tell me where can i find more information about that.
Thanks a lot. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-10-26 08:41:30 |
| Sounds like you're missing a Amount. It might be more helpful to show your current insert BillPaymentCreditCardLine statement. |
|
|
|
|