Knowledgebase: Tutorials
[QODBC-Desktop] How can I find source of SP_Report
Posted by Jack - QODBC Support on 05 August 2014 01:06 PM

How can I find a source of SP_Report

Problem Description 1:

Is there a way to see the SQL QuickBooks uses to generate their reports?
Also, Which tool do they use to create reports?

Problem Description 2:

I need to access information used in the QuickBooks audit trail report. Do you have the table name, the field names, and where the table is located?

Problem Description 3:

Do we have access to see the code in the QODBC Stored Procedures?

Problem Description 4:

In the future, what reference can I use to connect the QB List and Transaction tables to the standard SQL SELECT and FROM statements? How can I know the table and field names used in the report Trial Balance? For example, sp_report TrialBalance show Debit_Title, Credit_Title, Label, Debit, Credit parameters DateMacro = 'LastMonth'. I want to run my SQL in MS Access, not just sp_reports.For the future 

Solutions:

QuickBooks SDK does provide output of the report but does not provide information on how those data are derived or which tables are used in those reports.
QuickBooks SDK does not expose information regarding how the report is built, the tables used, or the logic part. Thus, it is not available in QODBC.
QODBC requests the Report information from QuickBooks SDK, and QuickBooks is the one processing it and sending the output. QODBC formats that output to data table format.

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