Dave, I do not really understand your answer. Something is definitely wrong here.
The “Transactions” tab is located INSIDE the customer’s window – but that is beside the point. The total balance in QuickBooks for the customer in question is $761.28 – as shown on the screen shot.
When I trigger the query on the same Customer table through Method – I only get the $150. I ran the query right after I synced with QuickBooks. You can also see all the transactions were “posted”.
The “Total Balance” field is simply displaying an incorrect value. Even If I would trigger it without Syncing QuickBooks it should still show the $761.28 and not the $150.00.