To do this you need to do one of my little tricks, like this:
INSERT INTO "InvoiceLine" ("InvoiceLineDesc", "FQSaveToCache") VALUES ('Blue Wigits', 1)
INSERT INTO "InvoiceLine" ("InvoiceLineDesc", "FQSaveToCache") VALUES ('Wigit Container', 1)
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache") VALUES ('470001-1071525403', 'Test104', '250000-933272656', 'Package SubTotal', 12.37, 12.37, '20000-999022286', 0)
When you run each of the three insert statements it looks like this in QuickBooks 2006:
|