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
|
|
Quickbooks Crashes when Inserting Linked Invoice |
Author |
Message |
|
Posted : 2007-09-11 06:21:18 |
Hi,
I'm working on a project to invoice sales orders using a shipping file we receive from our warehouse. Originally I was planning to do this with MS Access and was able to do a test append query sucessfully once. However now when trying the query through Access or even through the VB Demo Quickbooks crashes with a message that Quickbooks must terminate.
I have tried a new copy of the Quickbooks test file, ran a rebuild, cleared the Optimizer files and update QODBC to the current version and the crash still happens. Quickbooks version is Premier Manufacturing 2007 Release R8P
Here's the query:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineLinkToTxnTxnID", "InvoiceLineLinkToTxnTxnLineID", "FQSaveToCache") Select "CustomerRefListID", {fn CONCAT('SOLink', "RefNumber")}, "TxnID", "SalesOrderLineTxnLineID", 0 as "FQSaveToCache" from SalesOrderLine where "CustomerRefFullName" ='Eclat' and "RefNumber"='4587' and "SalesOrderLineSeqNo"=1
Here the QODBC message:
2007-09-10 12:55:21 QODBC Ver: 7.10.00.231 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineLinkToTxnTxnID", "InvoiceLineLinkToTxnTxnLineID", "FQSaveToCache") Select "CustomerRefListID", {fn CONCAT('SOLink', "RefNumber")}, "TxnID", "SalesOrderLineTxnLineID", 0 as "FQSa veToCache" from SalesOrderLine where "CustomerRefFullName" ='Eclat' and "RefNumber"='4587' and "SalesOrderLineSeqNo"=1 Error parsing complete XML return string (8) Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="6.0"?> <QBXML> <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll"> <InvoiceAddRq requestID = "1"> <InvoiceAdd defMacro = "TxnID:98EF8E74-A683-4411-8EDD-6785A719AB71"> <CustomerRef> <ListID>80000D34-1187038585</ListID> </CustomerRef> <RefNumber>SOLink4587</RefNumber> <InvoiceLineAdd> <LinkToTxn> <TxnID>1EA7C-1187029883</TxnID> <TxnLineID>1EA7E-1187029883</TxnLineID> </LinkToTxn> </InvoiceLineAdd> </InvoiceAdd> </InvoiceAddRq> </QBXMLMsgsRq> </QBXML> |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-09-11 10:13:46 |
Sorry, I just retested my example shown at: How do I convert a Sales Order into an Invoice? using 2201 as my reference number instead of 201:-
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineLinkToTxnTxnID", "InvoiceLineLinkToTxnTxnLineID", "FQSaveToCache") Select "CustomerRefListID", {fn CONCAT('SOLink', "RefNumber")}, "TxnID", "SalesOrderLineTxnLineID", 0 as "FQSaveToCache" from SalesOrderLine where "CustomerRefFullName" ='Lamb, Brad:Room Addition' and "RefNumber"='2201' and "SalesOrderLineSeqNo"=1
and the insert executed without error using QODBC v7.10.00.231 and QuickBooks Premier Edition 2007 Release R8P. I can't see anything obviously wrong in your statement. I assume you created the Sales Order as per my example too? Check what the actual QuickBooks error is in the SDK Message log for further possible clues. |
|
|
|
|
Posted : 2007-09-12 08:40:42 |
Ok, I've done some additional trouble shooting and found out the following:
1) The problem only occurs when using our company file. The sample QB file works fine. 2) I have tried multiple version of our file going back 9 months with the same result 3) Just doing a regular insert of an invoice line works fine (ie. without the Sales Order link) 4) Creating a linked SO through the QB GUI works fine 5) I get the same result on a different computer 6) It makes no difference what customer or Sales Order I use
I'm stumped at this point and might just create unlinked invoices and manually close the sales orders (not the idea solution).
Here are the QB logs, SDK log and a trace:
----- Trace Log ---- SetParameterValue Char Parameter Id: 1 Value: [800008BB-1168566047] SetParameterValue Char Parameter Id: 2 Value: [SOLink4661] SetParameterValue Char Parameter Id: 3 Value: [1F301-1188104822] SetParameterValue Char Parameter Id: 4 Value: [1F303-1188104822] ISAMInsertRecord 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] NO_ISAM_ERR 00000 00000 ISAMPutData 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] COLUMN: 5 [CustomerRefListID] SQL_C_CHAR 800008BB-1168566047 NO_ISAM_ERR 00000 00000 ISAMPutData 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] COLUMN: 15 [RefNumber] SQL_C_CHAR SOLink4661 NO_ISAM_ERR 00000 00000 ISAMPutData 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] COLUMN: 106 [InvoiceLineLinkToTxnTxnID] SQL_C_CHAR 1F301-1188104822 NO_ISAM_ERR 00000 00000 ISAMPutData 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] COLUMN: 107 [InvoiceLineLinkToTxnTxnLineID] SQL_C_CHAR 1F303-1188104822 NO_ISAM_ERR 00000 00000 ISAMUpdateRecord 0x001B3108 [ISAM] 0x0900ACD0 [InvoiceLine] QBXMLProcessXMLWithStringPointer5 Error: Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.
2007-09-11 15:28:13 QODBC Ver: 7.10.00.231 ********************************************************************************************************************* IsAService: False SQL Statement: INSERT INTO "InvoiceLine" ("CustomerRefListID","RefNumber","InvoiceLineLinkToTxnTxnID","InvoiceLineLinkToTxnTxnLineID") VALUES (?,?,?,?) Error parsing complete XML return string (8) Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <?qbxml version="6.0"?> <QBXML> <QBXMLMsgsRq onError = "continueOnError" responseData = "includeAll"> <InvoiceAddRq requestID = "1"> <InvoiceAdd defMacro = "TxnID:AE993983-2346-4944-987F-754DB1FD3C0D"> <CustomerRef> <ListID>800008BB-1168566047</ListID> </CustomerRef> <RefNumber>SOLink4661</RefNumber> <InvoiceLineAdd> <LinkToTxn> <TxnID>1F301-1188104822</TxnID> <TxnLineID>1F303-1188104822</TxnLineID> </LinkToTxn> </InvoiceLineAdd> </InvoiceAdd> </InvoiceAddRq> </QBXMLMsgsRq> </QBXML> ISAM_ERR_IN_COMP_SQL S0000 00000 [QODBC] Error parsing complete XML return string.
-------------- QB SDK Log ----------------- 20070911.152757 I 2672 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3936), ret = 0. 20070911.152757 I 2672 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3936). 20070911.152757 I 2672 SpecVersion Current version of qbXML in use: 6.0 20070911.152757 I 2672 QBSDKMsgSetHandler ADD: Invoice 20070911.152757 E 2672 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE ADD REQUEST ***. This is an indication of a possible internal QuickBooks error. 20070911.152803 E 2672 QBSDKProcessRequest *** INTERNAL ERROR WHEN PROCESSING THE QBXML REQUEST ***. 20070911.152813 E 3936 RequestProcessor Process Request error = 80010105
|
|
|
|
|