|
[QODBC-Online] - General Ledger (and Other) Reports Return Blank/Empty Results
Posted by William - QODBC Support on 13 October 2026 11:32 AM
|
|||||||
[QODBC-Online] - General Ledger (and Other) Reports Return Blank/Empty ResultsProblem Description:In certain versions of QODBC Online, running report queries such as This issue has been confirmed on a per-company-file basis and is tracked as bug B01667 on the QODBC internal bug list. It affects specific QuickBooks Online company files that may have certain configurations (e.g., missing custom fields) that trigger this behavior. Affected products: QODBC Online, QuickBooks Online Symptoms:
Cause:A bug in QODBC Online's report processing causes it to return empty results for certain company files when the QuickBooks Online file has specific configurations. The root cause is related to missing custom fields in the QuickBooks Online company file setup. The issue is tracked as B01667 on the QODBC internal bug list. Environment:
Solution:
SQL Examples:Affected query (returns empty in affected versions): sp_report GeneralLedger In affected versions, this query returns zero rows. After applying the workaround (creating a custom field in QBO) or upgrading to a fixed version, it returns the correct data. Alternative query with explicit date range: sp_report GeneralLedger Example Scenarios:Scenario 1 - Testing QODBC with a new QBO company file: A user installs QODBC Online, connects to their QuickBooks Online company file, and runs the General Ledger report. The connection succeeds, but results are empty. After adding a custom field in QBO (Settings → Account and Settings → Sales → Custom fields), the same query returns correct data. Scenario 2 - Existing customer reports appear blank after an update: A long-time QODBC customer finds that reports they have used for months now return empty. The root cause is traced to bug B01667 affecting certain company file configurations. Upgrading to a fixed version of QODBC Online resolves the issue permanently. Additional Notes:
Related Articles:QODBC Online SUBSTRING Function Troubleshooting: Reports Return No Data in QODBC Online How to Access Payroll Data in QODBC (SP_reports) Keywords:Bug B01667 General Ledger sp_report Blank Report Empty Result Set Custom Field Workaround QODBC Online QuickBooks Online No Data Returned Report Troubleshooting
| |||||||
|
|
|||||||


