I'm creating multi-line invoices with seperate commands for Invoice Lines and a final Insert for the Invoice Header.

Everthing is working except for one thing and that is getting a class on each item.  I'm including the Class on the Invoice Line Insert and if I use the VB Demo prgram I can see that The ClassRefListID and ClassRefFullName have been Polulated with the correct information in the InvoiceLine Table.  The problem is when I Look at the Invoice in QuickBooks the Class is not filled in on each Item Line but is correct at the Invoice Header Level.

Any Ideas on what I'm doing wrong ?

The SQL Command I'm using to insert Invoice Lines is:

    stSQL = "INSERT INTO InvoiceLine(InvoiceLineItemRefListID,ClassRefListID,ClassRefFullName," & _
            "InvoiceLineDesc,InvoiceLineQuantity,InvoiceLineRate," & _
            "InvoiceLineAmount,InvoiceLineSalesTaxCodeRefListID,FQSaveToCache) " & _
            "VALUES('" & stItemRefID & "','" & m_stClassRefListID & "','" & m_stClassRefFullName & _
            "','" & m_stProductCodeDescription & _
            "'," & m_iQty & "," & m_dUnitPrice & "," & (m_iQty * m_dUnitPrice) & _
            ",'" & m_stSalesTaxCodeRefListID & "',1)"

Tom

That is the example I followed and again the invoice is created and if I use vbDemo to look at the records in the invoiceline table I can see that

the ClassRefListID and ClassRefFullName fields have been populated with the correct information.  But if I look at the invoice in Quickbooks the

class on the Line Items is blank.  How can the class be in the invoiceline record but not be shown when looking at the invoice in quickbooks.

Also any company reports that are run do not reflect the class.

Sorry, but my Plan B Using ClassRefListID when inserting invoice lines example clearly displays in the invoice lines in QuickBooks:-

Tom

One question I have on your plan B using SP_LASTINSERTID to get the last ID Inserted into the invoice

file, is how does that work if we have more than one invoicing station working at once.  Will there be

a potenial of getting the ID of a different invoice, Or does sp_LastInsertID only get the last ID you did.