Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - How to locate data found in QuickBooks by table and field name inside QODBC
Posted by Jack - QODBC Support on 28 August 2015 08:43 AM

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 findme 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 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 below steps to locate data found in QuickBooks by table and field name inside the QODBC system.

1) Add a sample findme 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 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 'findme'


sp_globalsearch '123321'



(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).