running-total of fiscal balances...

[rhythmz]

I am currently creating a fiscal accounting report that requires me to start a fiscal year\period with a ZERO beginning balance and record the total debits & credits for each fiscal period. The sum of the debits & credits will then create an ending balance which in turn will become the next fiscal period's beginning balance. This pattern is re-created for each fiscal period until the end of a prompted fiscal year and\or fiscal period.

Can anyone attach an xml file using GO Sales or point me to a website or possibly explain here how I accomplish this task on an Orcale 10g RDBMS? I approached this thinking it would be easy but I am quickly finding that it is a bit more complex than I initially imagined. :o

Thanks,
Dennis