[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
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 More Details Please Refer: QODBC Setup Options
Keywords: Quantity on hand, Current Balance, quantity null