Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.
I assume that you are performing a query directly against the accnt table? As you found, this table is simply a list of the accounts.
The actual transactions are found in the gltrans table. The trialbal table might be even more helpful as it provides the summarized data.
Please visit: http://www.xtuple.org/phpBB3/viewtopic.php?f=&t=3501&p=0 for the changed document