Hi, 

 I'm trying to create an invoice programatically.  I'm a little confused as to how the items in the tSalOrdr table relate to the tCusTr table.  As far as I can tell Sales Orders and Sales Invoices should have nothing to with one another... yet when I look in the tSalOrdr table (and corresponding line items) it seems as if every line item in the invoice is duplicated in a sales order.

 When creating an invoice do I have to touch tSalOrdr at all?

 Thanks!

Hi there:  You do not need to do anything with Sales Order if you do not use a Sales Order system before actually generating a Sales Invoice.    Rita

If you dig a little deeper you will find that it’s not just the Sales Order that is interconnected with Sales Invoice but also the Sales Quote; in fact a Sales Quote, after generated, can be turned into a Sales Order, which can be turned into a Sales Invoice.

The tSalOrdr table (and related table) are for sales orders and quotes. You do not have to create a sales order before creating an invoice. If all you need in the end is the invoice, then forget about these table.

If you need assistance with the database, feel free to contact me off forum and we can work something out.