How to Find S.O Number Information of Sales Orders in QODBC

Instructions:

Sometimes QODBC may have the field name the same as in QuickBooks. You cannot find S.O Number or 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 the field RefNumber to store this information. You can find the RefNumber field in many tables, which store different records in different tables. In the SalesOrder table, it stores S.O Number:

And in other tables:

In the PurchaseOrder table, RefNumber stores P.O Number information

In the 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 to the screenshot to see where it stores in QuickBooks:

Keywords: sonumber