|
[QODBC-Online] - SalesReceipt Missing BillEmail Field
Posted by William - QODBC Support on 13 October 2026 12:42 PM
|
|||||||
[QODBC-Online] - SalesReceipt Missing BillEmail FieldProblem Description:In certain versions of QODBC Online, the 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 Symptoms:
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:
Solution:
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.
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:
Related Articles: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
| |||||||
|
|
|||||||


