This statement in VBDemo32 gives the AmountDue column as blank:

SELECT * from bill where vendorreffullname like 'L%' and ispaid = false

Whereas this statement shows the amount correctly:

SELECT vendorreffullname, amountdue from bill where vendorreffullname like 'L%' and ispaid = false

And this statement always reports a blank amount due, even if the bill table optimizer is up to date:

SELECT vendorreffullname, amountdue NOSYNC from bill where vendorreffullname like 'L%' and ispaid = false

Please help me understand what is going on here.  When does the processor report a blank field in the query result?

Thanks.

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? 

The setting you need to configure is: 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 in QODBC v6).