Re: need to speed up query

it worked it had couple missing parts but it worked and ran in 3.3
seconds. *Thanks for this *
i need to review the result and balance it to my results as the
Accountant already went through and balanced some accounts by hand to
verify my results

<<begin quote>>

You might want to consider a
denormalized summary table that contains this information (and maybe
more) maintained by a trigger or regularly invoked stored-procedure and
then you can select from *that* with much less agony.

<<end quote>>

I just dumped the summary table because it kept getting out of balance
all the time and was missing accounts that did not have transaction in
them for given period. Again i did not lay out the table nor the old
code which was terrible and did not work correctly. I tried several
times to fix the summary table but to many things allowed it to get
out of sync. Keeping the Ending and Beginning Balance correct was to
much trouble and i needed to get numbers we can trust to the accountant.

The developers of the code got credits and debits backwards so instead
of fixing the code they just added code to flip the values on the front
end. Its really annoying. At this point if i could go back 7 months
ago i would not purchased this software if i had known what i know now.

I've had to make all kinds of changes i never intended to make in order
to get the stuff to balance and agree. I've spent the last 3 months in
code review fixing things that allow accounts to get out of balance and
stop stupid things from happening, like posting GL Transactions into
non-existing accounting periods. the list of things i have to fix is
getting dam long.