[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_ReportProblem Description 1: Is there a way to see the SQL QuickBooks uses to generate their 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. | |
|