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 |
Author |
Message |
mark |
|
Group | : Members |
Posts | : 9 |
Joined | : 2006-05-08 |
|
Profile |
|
Posted : 2006-05-09 05:35:31 |
I execute the following statements and receive "Error parsing complete XML return string" and the Invoice is not created. I checked the table definitions and all the fields I'm inserting into are valid.
INSERT INTO "InvoiceLine" ("InvoiceLineItemRefListID","InvoiceLineDesc","InvoiceLineRate","InvoiceLineAmount","InvoiceLineQuantity","FQSaveToCache") VALUES ('1090000-1141173332', 'Cert. Welder O/T',90.00000,382.50,4.00000,1)
INSERT INTO "Invoice" ("CustomerRefListID","ARAccountRefListID","TxnDate","RefNumber","BillAddressAddr1", "BillAddressAddr2","BillAddressAddr3","BillAddressAddr4","IsPending", "TermsRefListID", "TemplateRefListID","TemplateRefFullName","FOB") VALUES ('1BE0000-1146987159','340000-1135894074', {d'2006-05-01'}, '200600776','Burlington Resources','7009 Donald Rd.','Krum, TX 76249','=================',0, '20000-1135876782','C0000-1147112120', 'PolleyCo_Auto_Gen','Rod Weatherby')
Help? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-09 09:14:04 |
The Intuit qbXML SDK requires the order of the columns in a INSERT to be in the same order as seen when you do:-
sp_columns invoice
and you use either the ListID or the FullName of a reference (not both). So the TemplateRefListID needs to moved to look like this:
INSERT INTO "Invoice" ("CustomerRefListID","ARAccountRefListID","TemplateRefListID","TxnDate","RefNumber","BillAddressAddr1", "BillAddressAddr2","BillAddressAddr3","BillAddressAddr4","IsPending", "TermsRefListID", "FOB") VALUES ('1BE0000-1146987159',' 340000-1135894074', 'C0000-1147112120', {d'2006-05-01'}, '200600776','Burlington Resources','7009 Donald Rd.','Krum, TX 76249','=================',0, '20000-1135876782','Rod Weatherby') |
|
|
|
|