Knowledgebase: TroubleShooting
[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 is showing Null value or is Missing Value, wherein QuickBooks is showing the correct information.

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

SELECT QuantityOnHand FROM ItemInventory where Name = 'MYPRODUCT'

Is there a way to get QuantityOnHand Keeping Optimizer On


Please enable Either "Dirty Reads"/"Real Time" option via: Start >> All Programs >> QODBC Driver for use with QuickBooks >> Configure QODBC Data Source

Go To "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: QODBC Setup Options

Keywords: Quantity on hand, Current Balance, quantity null

(7 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).