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

Instructions:

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