How to update SONumber field in Invoice table |
Author |
Message |
|
Posted : 2006-05-13 00:52:27 |
Hi,
We are using QODBC to import salesorder data from Excel into QuikBooks to create Invoices.
The invoice template which we currently using has SONumber and when we create Invoice from QODBC it is updated as null. But when we manually create invoice from screen it is showing SONumber.
We could not see the SONulber field reference in the invoice table.
What field in INVOICE refers to SONumber in SALESORDER table and how we can update it ?
Thanks in advance.
Regards Sravan |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-13 08:57:50 |
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 |
|
|
|
|
Posted : 2006-05-13 09:01:48 |
Can we insert records into SalesOrderLinkedTxn table at the time of inserting records in to Invoice table.
Does this retain the linking between SalesOrder and Invoice and shows the SONumber in the Invoice template ?
Please advice. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-13 09:57:18 |
Linked Sales Order/Invoice transactions are only available to users using QuickBooks 2007 (USA Edtion) and QODBC v7. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-12-20 11:41:33 |
The SONumber in the Invoice table is not available in the SDK. We have asked several times. Maybe SDK 7 for QuickBooks 2008?.
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
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-01-20 22:48:25 |
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.
See: How do I convert a Sales Order into an Invoice? for more. |
|
|
|