ONLINE DATA LAYOUTS SOURCE   We have provided the tools to help you determine where field information comes from in QuickBooks Online, which tables contain the information you want, how tables can be related, and sample SQL statements. Please click here...

TROUBLESHOOTING - HOW TO SELECT A RECORD WHEN THE VALUE IS NULL PROBLEM DESCRIPTION: I am trying to run a report that returns ItemInventory where LastReceived is NULL. I have tried in vain to accomplish this. What syntax do you use to select a blank/nu...