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
|
|
Update to Invoice Table Fails |
Author |
Message |
|
Posted : 2007-01-04 04:19:47 |
I have an application that adds invoice information to QuickBooks. With QuickBooks 6 and QODBC 6, the process usually worked fine. We recently upgraded to QuickBooks 7 and QODBC v7, and one part of the import no longer works.
The following is the update string used in VB 2005 that fails:
Dim UpdateDateSQL As String = "Update Invoice Set TxnDate = " & BillDateString & ", DueDate = " & DueDateString & ", ARAccountRefFullName = 'Accounts Receivable', ARAccountRefListID = 'XXXXXXXXXX' where CustomerRefListID = '" & Customer_List_ID & "' and RefNumber = '" & Invoice_To_Bill.Invoice_Number & "'"
The error received is: ERROR [00000] [QODBC] Error parsing complete XML return string.
What could be causing this issue? Thanks for any help. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-04 09:57:13 |
|
|
|
|
Posted : 2007-01-05 01:44:31 |
Thanks, that information helped me solve my problem.
I solved my problem by only updating TxnDate and DueDate, and leaving out ARAccountRefListID and CustomerRefListID. Then the update statement works. As for ARAccountRefListID and CustomerRefListID, I don't think updating these makes a difference anyway, because the invoices automatically seem to go to the correct, default account anyway in my case. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-04-04 09:46:58 |
|
|
|
|