The example below inserts a new Invoice line into the InvoiceLine table. Note that a TxnID is supplied. It's that simple, just call up an existing invoice to insert a new record line.

INSERT INTO "InvoiceLine" ("TxnId", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID") VALUES ('6130-1197786604', '250000-933272656', 'Test Add a Line', 1.00000, 1.00, '20000-999022286')

The TxnID is found by searching the Invoice table for the invoice you wish to modify by doing:

select TxnID, RefNumber from Invoice where RefNumber = 'the invoice number you are looking for'

If you need to update an exisiting InvoiceLine record you can use a statement similar to the one below. The TxnID in the WHERE statement is used for speed but could be omitted.

UPDATE "InvoiceLine" SET "InvoiceLineDesc" = 'New Desc 10001' WHERE "TxnID" = '6130-1197786604' And "InvoiceLineTxnLineID" = '7133-1197736106'

See: Duplicate invoice on Insert of new InvoiceLine for an example.

Tom,

Thanks for the quick response (as everyone on here appreciates). The problem was that it was the 6.00.00.150 version. I had upgraded but it didn't take until I uninstalled and reinstalled! One I got to the latest rev it worked just as indicated.

Thanks!