Do you mean: How do I apply PriceLevel Profile to Invoice Line Items? 

QuickBooks will use the default date if no date is specified in transaction inserts, but the Online Edition requires a date! So you must include a transaction date like this :-

INSERT INTO "InvoiceLine" ("CustomerRefListID", "TxnDate", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineQuantity", "InvoiceLineRate",
"InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache")
VALUES ('800000AA-1197768105', {d '2007-11-28'} , 'Discount10',
'10000-933272655', 'Picture Framing North Wall', 5.00, 49.50,
'20000-999022286', 0)

and all the ListIDs will be shorter in QBOE.

but how do I get that information into QBOE so that it subtracts the discount.

I thought I could insert one invoiceline for the purchase, then insert a second invoiceline for the discount with a negative amount.  That's how I interpreted the examples..

How can I do that for QBOE.. I don't care if it's a "discount", a "pricelevel" or "donuts".. as long as i can programmitically account for the discounts the same way you can in the webui..?.. n'est-ce pas?  :)

For a detailed example I would fly to australia and deliver to you my mother's home-backed cookies..

Regards..

Thanks,

How would I account for the differences in price then.  When I use the QBOE website I can apply a discount (promo code) to a purchase.  The discount amount and a description are available?  I tried manually inputing that data, then looking to see what changes.   Is there are way to do that via SQL QODBC?  I just need to know what tables use for the insert and what fields are required if you already know.  Or if this is one of those things that is available only through the UI then that's fine.. I just need to know..

QODBC is primary built for the desktop version of QuickBooks. QBOE has had a lot of revisions done to it and now has some features not in the current desktop version. Try running the query:

Select * from invoiceline where RefNumber='invoiceno'

for the invoice you created to see what lines were generated.