I have a work order program in SQL server 2000, and I would like to avoid duplicate data entry. What is the minimal information I need to input new invoices into QuickBooks I saw several examples on how to input invoices, however there is a lot of additional data in the sql statements that my work order program does not have.

 Also can I simply create a column with the Qbooks customer ID, or do I also need the customer name.

On the Invoice detail do we need listID or can we just create inv line data on the fly that is not added to any list.  It would only be saved to that invoice; this would avoid duplicate list items.

Thanks Alfonso

The minimum information to create an invoice is:

INSERT INTO "InvoiceLine" ("CustomerRefListID", "InvoiceLineItemRefListID",
"InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount")
VALUES ('470001-1071525403', '250000-933272656',
'Building permit Additional Room', 100.00000, 100.00)

See: Using ClassRefListID when inserting invoice lines for the two methods of creating invoice lines. Plan B shows how to add lines afterwards.

Tom,

Thank you for your prompt reply. I see you sent info for the invoice line table; do I need to address the Invoice table?  Also is the best way to get the id values from QuickBooks by doing a select statement prior to my insert statement?

No, you don't need to use the Invoice table to create a invoice because a "CustomerRefListID" is used in the InvoiceLine insert above.

For all the lookups and where they come from see: How do I create Invoices?