[QODBC-Online] Troubleshooting - How to list InActive records on QODBC Online?

Problem Description:

When executing a basic query (such as SELECT * FROM Account) via the QODBC Test Tool or custom application code, the result set only returns records where IsActive = True. Inactive accounts do not appear in the results, even though they are visibly listed as inactive within the QuickBooks Online (QBO) Chart of Accounts interface.

Solution:

Querying Inactive Records

This behavior is not a bug.

By default, the QuickBooks Online API filters query responses to return only active records (IsActive = True) unless explicitly instructed otherwise in the SQL statement.

To retrieve inactive records or include both active and inactive records, you must explicitly declare the IsActive field in your WHERE clause:

• To return only inactive accounts:

  SQL

   

  SELECT * FROM Account WHERE IsActive = False
  

• To return both active and inactive accounts:

  SQL

   

  SELECT * FROM Account WHERE IsActive = True OR IsActive = False
  

  (Alternatively, querying WHERE IsActive IN (True, False) depending on your SQL parser setup).

You can check the status using the QODBC Setup Screen. 

Tags: QuickBooks Online, QBO, Active Records QODBC Online, Deleted records