If you don't specify the RefNumber in the insert operation, QuickBooks will automatically assign the next invoice number for you.
INSERT INTO "InvoiceLine" ("CustomerRefListID", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache") VALUES ('470001-1071525403', '250000-933272656', 'Council Planning Permit', 50.00000, 50.00, '20000-999022286', 0) |