[QODBC-Desktop] How to Find S.O Number Information of Sales Order in QODBC
Posted by Rajendra Dewani (QODBC Support) on 11 January 2013 12:23 PM
|
|
How to Find S.O Number Information of Sales Order in QODBCInstructions:Sometimes QODBC may have the field name exactly the same as it is in QuickBooks. You cannot find S.O Number, P.O Number in QODBC, but QODBC does have a field in these tables to store the information. Find them using QODBC :In QODBC, we use field RefNumber to store this information. You can find RefNumber field in many tables, and in different tables, it stores different records. In SalesOrder table, it stores S.O Number: And in other tables: In PurchaseOrder table, RefNumber stores P.O Number information In Invoice table, RefNumber stores Invoice # information In Bill and Vendor Credit tables, RefNumber stores Ref. No. information In Check and BillPaymentCheck tables, RefNumber stores Check Number information, please refer the screenshot to see where it stores in QuickBooks:
Keywords: sonumber | |
|
I would like to inform you that SONumber in the Invoice table is not available through the Intuit SDK so they are not available through QODBC.
QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn’t expose one feature to application in SDK, QODBC could not do it either.
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.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