|
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
|
|
| Inserting Bill causes 'Error parsing complete XML return string' |
| Author |
Message |
|
|
| Posted : 2008-08-08 00:23:52 |
Hi,
Following your tutorial on how to insert bills with the tax code, I have the following statements (which I tried out in the VB Demo):
INSERT INTO billExpenseLine (RefNumber, ExpenseLineAccountRefListID, ExpenseLineAmount, ExpenseLineMemo, ExpenseLineTaxCodeRefListID, FQSaveToCache) VALUES ('December','2D0000-1014929191',128,'unit test','20000-1014853778',1)
INSERT INTO bill (VendorRefListID, APAccountRefListID, TxnDate, DueDate, RefNumber, Memo) VALUES ('680000-1015447390','130000-1014928492',{d'2008-01-01'},{d'2008-01-01'},'December','unit test')
In order to find the ExpenseLineTaxCodeRefListID, I took the ListID from this statement:
SELECT * FROM salesTaxCode
And I chose the ListID for "GST Only".
I am using the 2008 Canadian edition on Windows XP. Can you please tell me why I'm getting this error? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-08-08 13:29:44 |
|
|
|
|
|
| Posted : 2008-08-08 23:23:18 |
Hi Tom,
Thanks for the quick reply. I've read the thread, but I can't determine if the latest patch in that Updates and Fixes forum contains a patch that will help me? If not, do you have a timeline on when this will be fixed?
Thanks. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-08-09 09:40:12 |
Ok I'm going to say this once. PLEASE ONLY POST ONCE!!! All posts are held for review and then released, so when you post a topic, or reply, you will not see it until the post has been approved and released by me.
QODBC is being remapped at the moment, there's no timeframe yet, but when I have test version it will appear at the link location provided. |
|
|
|
|
|
| Posted : 2008-08-12 00:40:39 |
Sorry about the reposting. The problem is with my internet connection at work, it randomly drops the connection so I don't know if it successfully posted or not.
I would really like to recommend your product as it's going well so far, except for this little snag. Please release a fix for this as soon as you are able. |
|
|
|
|
|
| Posted : 2008-08-12 02:52:14 |
I tried inserting using the commands above, without the tax code. It works in the VB Demo but when I do it through my service I get this in my SDK Messages:
20080811.124158 I 3700 RequestProcessor ========= Started Connection =========
20080811.124158 I 3700 RequestProcessor Request Processor, QBXMLRP2 v6.0
20080811.124158 I 3700 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20080811.124158 I 3700 CertVerifier The Authenticode signature validated OK.
20080811.124158 I 3700 RequestProcessor Opening the file in the DoNotCare mode.
20080811.124158 I 620 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3700).
20080811.124158 I 620 SpecVersion Current version of qbXML in use: 6.0
20080811.124158 I 620 QBSDKMsgSetHandler QUERY: Host
20080811.124158 I 620 QBSDKMsgSetHandler Request 1 completed successfully.
20080811.124158 I 620 QBSDKMsgSetHandler QUERY: Company
20080811.124158 I 620 QBSDKMsgSetHandler Request 2 completed successfully.
20080811.124158 I 620 QBSDKMsgSetHandler QUERY: DataExtension Definition
20080811.124158 I 620 QBSDKMsgSetHandler Request 3 completed successfully.
20080811.124158 I 620 MsgSetHandler Finished.
20080811.124158 I 620 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3700), ret = 0.
20080811.124202 I 3700 RequestProcessor Connection closed by app named 'FLEXquarters QODBC'
20080811.124202 I 3700 RequestProcessor ========== Ended Connection ==========
20080811.124202 I 3700 RequestProcessor ========= Started Connection =========
20080811.124202 I 3700 RequestProcessor Request Processor, QBXMLRP2 v6.0
20080811.124202 I 3700 RequestProcessor Connection opened by app named 'FLEXquarters QODBC'
20080811.124202 I 3700 CertVerifier The Authenticode signature validated OK.
20080811.124203 E 3700 RequestProcessor Unknown QBInstanceFinder error. File Name: "ˆÈp”Èp" hr = 80070057
20080811.124203 E 3700 RequestProcessor Could not create instance of QuickBooks. hr = 80040403
Do you know what could be causing this?
Also, I cleared the QODBC Messages and the Trace Log, and now my application doesn't seem to log to those anymore. Is there any way I can fix that? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-08-12 08:08:44 |
| The error is saying it couldn't start QuickBooks in background "unattended" auto-login mode. Log files often don't get created by Windows Services. The Windows Service account being used must have full rights to the folder where the QODBC log files reside. |
|
|
|
|