When inserting an estimate line  to an existing estimate I am recieving the following error message:

Failure Error- [QODBC] Error: 3290 - The item "25B9-1197757379" is placed in the request in incorrect order

What is causing this error, I am not setting the sequence number. Here is the query:

Insert into EstimateLine(TxnId,EstimateLineItemRefListId,EstimateLineDesc,EstimateLineRate,EstimateLineSalesTaxCodeRefListID,FQSaveToCache) Values ('25B5-1197757379','240000-1071531214','Delivery Service Fee (free for orders over $100)',12.5,'20000-999021789',false)

It seems that the error is dependent on the order that I insert line items. When working with a brand new invoice with just a few items there is no problems.

Sorry, the statement is valid, but QuickBooks is saying here that: "The line items in the request are in a different order than the line items in the transaction". As I don't have what else happened before the error, I can't tell what you're doing wrong.

I have figured out how to reproduce the error. I believe that it is a bug. To reproduce the bug:

1. Create an Estimate using the quick books interface. Add a group item first and then add a regular item.

2. Then try add a new line item to that estimate using qodbc.

Will produce the following error :

Failure Error- [QODBC] Error: 3290 - The item "25B9-1197757379" is placed in the request in incorrect order

Thanks for the detailed information. Your bug report is hereby confirmed:

SDK Log Reports:
20060801.181618 I 4056 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3412).
20060801.181618 I 4056 SpecVersion Current version of qbXML in use: 5.0
20060801.181618 I 4056 QBSDKMsgSetHandler MODIFY: Estimate
20060801.181619 E 4056 EstimateStorage::DoModify Cannot modify the transaction line items: 5D1D-1197767424
20060801.181619 I 4056 QBSDKMsgSetHandler Request 1 failed.
20060801.181619 I 4056 MsgSetHandler Finished.
20060801.181619 I 4056 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3412), ret = 0.

2006-08-01 18:16:19 QODBC Ver:  6.00.00.182 *********************************************************************************************************************
IsAService: False
SQL Statement: INSERT INTO "EstimateLine" ("TxnID", "EstimateLineItemRefListID", "EstimateLineDesc", "EstimateLineRate", "EstimateLineAmount", "EstimateLineSalesTaxCodeRefListID") VALUES ('5D1B-1197767424', '250000-933272656', 'Building permit No 201', 100.00000, 100.00, '20000-999022286')
3290 - The item "5D1D-1197767424" is placed in the request in incorrect order.
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="5.0"?>
<QBXML>
    <QBXMLMsgsRq onError = "continueOnError" responseData = "includeNone">
        <EstimateModRq requestID = "1">
            <EstimateMod>
                <TxnID>5D1B-1197767424</TxnID>
                <EditSequence>1197767424</EditSequence>
                <EstimateLineMod>
                    <TxnLineID>5D22-1197767424</TxnLineID>
                </EstimateLineMod>
                <EstimateLineMod>
                    <TxnLineID>-1</TxnLineID>
                    <ItemRef>
                        <ListID>250000-933272656</ListID>
                    </ItemRef>
                    <Desc>Building permit No 201</Desc>
                    <Amount>100.00</Amount>
                    <SalesTaxCodeRef>
                        <ListID>20000-999022286</ListID>
                    </SalesTaxCodeRef>
                </EstimateLineMod>
                <EstimateLineGroupMod>
                    <TxnLineID>5D1D-1197767424</TxnLineID>
                    <EstimateLineMod>
                        <TxnLineID>5D1E-1197767424</TxnLineID>
                    </EstimateLineMod>
                    <EstimateLineMod>
                        <TxnLineID>5D1F-1197767424</TxnLineID>
                    </EstimateLineMod>
                    <EstimateLineMod>
                        <TxnLineID>5D20-1197767424</TxnLineID>
                    </EstimateLineMod>
                </EstimateLineGroupMod>
            </EstimateMod>
        </EstimateModRq>
    </QBXMLMsgsRq>
</QBXML>
Output XML:
<?xml version="1.0" ?>
<QBXML>
    <QBXMLMsgsRs>
        <EstimateModRs requestID="1" statusCode="3290" statusSeverity="Error" statusMessage="The item &quot;5D1D-1197767424&quot; is placed in the request in incorrect order." />
    </QBXMLMsgsRs>
</QBXML>

This has now been fixed in QODBC v6.00.00.186 (or later):

INSERT INTO "EstimateLine" ("TxnID", "EstimateLineItemRefListID",
"EstimateLineDesc", "EstimateLineRate", "EstimateLineAmount", "EstimateLineSalesTaxCodeRefListID")
VALUES ('5D1B-1197767424', '250000-933272656',
'Building permit No 201', 100.00000, 100.00, '20000-999022286')