Problem Description

Fields related to Balances and QuantityOnHand show a Null or Missing Value, whereas QuickBooks shows the correct information.

e.g., When using the below query with Optimizer On, it does not show the detail, but when Optimizer is turned OFF, it can show the correct value

SELECT QuantityOnHand FROM ItemInventory where Name = 'MY PRODUCT.'

Is there a way to get QuantityOnHand Keeping Optimizer On

Solutions

Please enable the "Dirty Reads" or "Real Time" option via Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source.

Go To the "System DSN" Tab, select "QuickBooks Data" DSN & click "Configure."

Change the following value on the Optimizer tab and try again. Under "For balances and stock quantities," select Either "Dirty Reads"/"Real Time."

For balances and stock quantities: the option Nulls - will return NULLs for all fields that cannot be kept in sync, Dirty Reads - means return the most current value that was loaded into the optimizer cache, and Real-Time uses the slower method to get the data directly out of QuickBooks making sure you get the most current value for the requested fields. (Real Time is the previous method used).

For More Details, Please Refer: to QODBC Setup Options

QODBC Online

QODBC Online

Keywords: Quantity on hand, Current Balance, quantity null,  onhandquantity is on blank, quantity is blank, quantity is empty, blank quantity, empty balance