Troubleshooting - How to locate data found in QuickBooks by table and field name inside QODBC

Problem Description:

I have a question about How to locate data found in QuickBooks by table and field name inside the QODBC system.

Solutions:

The fastest way to find data in QuickBooks via the QODBC Driver is to use the bait and sync method. Inside QuickBooks, place a unique "bait" value in the field in question, such as find me for text fields or 123321 for numeric fields, and save the data. Then start QODBC Test Tool and connect to the QuickBooks company file. Refer to Connecting QODBC Driver to QuickBooks for the First Time (Video), then do a global search for the "bait" value. The file and field name will be shown if the data is available via QODBC.

Please follow the steps below to locate QuickBooks data by table and field name inside the QODBC system.

1) Add a sample find me to Invoice or bill records (i.e., RefNumber).

For Example, We are creating an Invoice with RefNumber (i.e., Invoice#) findme.


2) Add a sample 123321 in the CreditMemo rate.

For Example, We are creating CreditMemo with Rate 123321.


3) Use the SP_GLOBALSEARCH command to search data from the QuickBooks company file. (Requires v16.0.0.317 or above)

sp_globalsearch SearchValue

For Example:

sp_globalsearch 'find me.'


sp_globalsearch '123321'