Knowledgebase
[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 Results 

Problem Description:

In certain versions of QODBC Online, running report queries such as sp_report GeneralLedger returns no rows (empty result set) despite data existing in the QuickBooks Online company file. The connection succeeds without error - only the report results are blank.

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
Expected outcome: Reports return the correct rows with data. A workaround exists if the bug fix is not yet available in your version.

Symptoms:

  • A report query such as sp_report GeneralLedger runs without error but returns an empty result set.
  • The same data is visible in QuickBooks Online - the issue is specific to QODBC Online's report processing for certain company files.
  • The issue may or may not affect other reports (some reports work while others return blank).
  • No error message, no exception - just zero rows returned from a query that should produce results.

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:

ProductVersion / Detail
QODBC Online Affected in versions prior to the fix; check your build version against QODBC release notes
QuickBooks Online All plans (company files without at least one custom field may trigger the bug)

Solution:

  1. Download the latest version of QODBC Online. You can download QODBC Online from QODBC Online Downloads

  2. Workaround: Create a Custom Field in QuickBooks Online. For customers who cannot upgrade to the latest version, apply this workaround:

    1. In QuickBooks Online, go to Settings (gear icon) → Account and Settings → Sales → Sales form content → Custom fields.
    2. Add at least one custom field. It does not need to be used in any transactions - just creating the field is sufficient.
    3. Save your changes.
    4. Re-run the report query in QODBC Online - results should now return correctly.

SQL Examples:

Affected query (returns empty in affected versions):

 sp_report GeneralLedger 
  SHOW AccountNumber, Account, Amount, Date, TransactionType, DocumentNumber, Name, TextLable
  PARAMETERS DateMacro = 'ThisMonthToDate'

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 
  SHOW RowData, Date, TransactionType, Name, Memo, Split, Amount
  PARAMETERS DateFrom = {d'2026-01-01'}, DateTo = {d'2026-09-30'}

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:

  • Workaround does not affect business operations: Adding a single custom field in QuickBooks Online has no impact on existing transactions, reports (in QBO), or integrations. It is purely a structural change to the company file.
  • The bug is per-company-file: Not all QBO company files are affected. Only those with specific configurations that trigger B01667 exhibit empty report results.
  • Other reports may also be affected: While General Ledger was the primary test case, other sp_report queries (SalesReceipt, InvoiceSummary, etc.) on the same company file may also return blank.
  • Bug B01667 status: Check the latest QODBC release notes to confirm whether the fix is included in your installed version.

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