Sorry the SONumber is missing in both our Invoice and InvoiceLine tables.

The SONumber is normally obtained from the SalesOrderLinkedTxn table linked transactions for the Invoice.

I have QODBC v7 BUT quickbook premier retail 2006 version. Is it possible with this combination. Please Let me know how can i do than.

Thanks for your help.

The quick book i m using it is not UK version. It is US version and i have QODBC v7. My question was will it work for quickbook Premier retail 2006 US version with QODBC v7 OR NOT. If not what is the solution than for this.

Thanks for your quick reply with thanks.

If you are using QuickBooks 2007 (USA version) you can now create linked Sales Order invoices. To create the Invoice we can read the SalesOrderLine table and insert it into the InvoiceLine table. The S.O. Number from the linked Sales Order will be shown in the Invoice when you view it in QuickBooks.

This query will show the SONumbers for you:

SELECT Invoice.TxnId, SalesOrderLinkedTxn.TxnId, Invoice.RefNumber, SalesOrderLinkedTxn.RefNumber AS SONumber FROM Invoice LEFT OUTER JOIN SalesOrderLinkedTxn ON SalesOrderLinkedTxn.LinkedTxnTxnID = Invoice.TxnID

See: How do I convert a Sales Order into an Invoice? for more.

We enter S. O. No.  manually in invoices in Quick Books. What query can I use to retrieve it?

BTW we do not create any Sales Orders in QB - just invoices.

Sorry the SONumber is missing in both our Invoice and InvoiceLine tables. The SONumber is normally obtained from the SalesOrderLinkedTxn table linked transactions for the Invoice.  But if you don't create invoices from sales orders, there are no SalesOrderLinkedTxn linked transactions.