Knowledgebase: Tutorials
[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 VB Demo connected to this QuickBooks 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 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 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 SP_GLOBALSEARCH command to search data from 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).