Knowledgebase: Setup
[QODBC-Desktop] Balance,CurrentBalance,QuantityOnHand is missing value or showing Null value
Posted by Rajendra Dewani (QODBC Support) on 04 October 2012 06:23 AM

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


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

(8 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).