I was looking at the example in one of the posts on how to create a customer, and invoice them, I noticed that here was an insert only into the invoiceLine table and not the invoice table. Will an insert into invoice line automatically add the invoice?
TO CREATE THE INVOICE
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache") VALUES ('AC0000-1197757899', 'QODBCcip', '250000-933272656', 'Bin Permit Renovations', 200.00000, 200.00, '20000-999022286', 0) |