Knowledgebase
[QODBC-Online] - SalesReceipt Missing BillEmail Field
Posted by William - QODBC Support on 13 October 2026 12:42 PM

[QODBC-Online] - SalesReceipt Missing BillEmail Field

Problem Description:

In certain versions of QODBC Online, the SalesReceipt table did not include the BillEmail field in its data structure. Queries selecting BillEmail from SalesReceipt returned an empty column or error, even though the field is present in the QuickBooks Online SalesReceipt record via the Intuit API.

This issue has been confirmed and tracked as bug B01711 on the QODBC internal bug list. The issue was fixed and released in the QODBC Online v358.

Affected products: QODBC Online, QuickBooks Online
Expected outcome: The BillEmail field is returned correctly when querying the SalesReceipt table. Upgrade to a fixed version of QODBC Online.

Symptoms:

  • Querying Select * from SalesReceipt returns an empty or missing BillEmail column.
  • The BillEmail data is visible in the QuickBooks Online interface and via the Intuit API, but not accessible through QODBC Online.
  • No error message - the query succeeds, but the BillEmail field simply does not appear in the result set.

Cause:

A bug in QODBC Online's SalesReceipt table mapping prevented the BillEmail field from being exposed through the ODBC layer. The underlying QuickBooks Online API does provide this data, but the QODBC Online driver failed to include it in the SalesReceipt result set.

Environment:

ProductVersion / Detail
QODBC Online Affected in versions prior to the B01711 fix; check your build version against QODBC release notes
QuickBooks Online All plans (the issue is on the QODBC side, not the QuickBooks side)

Solution:

    1. Upgrade to a version of QODBC Online that contains the fix for B01711.  QODBC Online Downloads.

Before installing, back up SocketReceiver.exe from C:\Program Files (x86)\QODBC Driver for QuickBooks Online\QBO\. Close all applications using QODBC Online and kill SocketReceiver.exe from Task Manager before overwriting.

Test by running Select BillEmail from SalesReceipt

Verify the fix.

    The BillEmail field should now appear in the result set of SalesReceipt queries, matching the data shown in QuickBooks Online.

SQL Examples:

Affected query (returns empty BillEmail in affected versions):

SELECT * FROM SalesReceipt

After the fix, BillEmail is included in the result set alongside other SalesReceipt fields:

SELECT TxnId, CustomerRefFullName, TxnDate,  BillEmailAddress, TotalAmount FROM SalesReceipt

Example Scenarios:

Scenario 1 - Email automation integration:

A user built an automated invoicing workflow using QODBC Online to read SalesReceipt data and send confirmation emails. The BillEmail field was missing, so customers were not receiving automated emails. After upgrading to the fixed version, the workflow began retrieving email addresses correctly.

Scenario 2 - Data migration to another system:

A customer migrating sales data from QuickBooks Online to a CRM system noticed that customer email addresses (BillEmail) were blank in the exported data. The issue was traced to bug B01711. Upgrading QODBC Online resolved the missing field.

Additional Notes:

  • Bug B01711 status: The fix was included in hotfix build B01711-13-beta_2024-06-28. Check the latest QODBC release notes to confirm whether the fix is included in your installed version.
  • This is an ODBC-side issue: The BillEmail data exists in QuickBooks Online and is accessible via the Intuit API. The limitation was solely in QODBC Online's field mapping, not in QuickBooks itself.

General Ledger Reports Return Blank/Empty Results QODBC Online SUBSTRING Function

Keywords:

Bug B01711 BillEmail SalesReceipt Missing Field QODBC Online QuickBooks Online Email Address Field Mapping
(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).