Knowledgebase: Data & Table
[QODBC-Desktop] Troubleshooting - How do I get company business number
Posted by Jack - QODBC Support on 02 March 2017 11:51 AM

Troubleshooting - How do I get company business number

Problem Description:

In QuickBooks enterprise, the company information form shows me the company's business#.

In a custom report, the field is displayed as blank.

In VBDEMO, the field shows as blank.

I double checked my odbc setup and it IS allowing personal data to be accessed.

Solution:

The company information is on the Company table, i.e.

Select * from Company

The information that you see is what is allowed by Intuit's qbXML SDK. Certain columns are only available in their respective country versions of QuickBooks, while "specialized to country" company information may not appear at all. '

 

(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).