On 03/03/2011 05:53, Thomas Clarke wrote:

>
> > Bhavbhuti,
>
> I have used both methods:
>
> 1. Store the balances via a year end procedure.
> 2. Compute them as needed.
>
> I think it depends on the volume of data in the database. For a small
> database I would be tempted to compute opening balances and for a large
> database I would store them at year end or whenever required.
>
> Thomas Clarke
> Cyber Sea Incorporated
> web: http://cybersea.biz
>

Thanks Thomas for your views. I am torn between, I do not want to store
calculated values, yet I need to deliver efficient reporting.

Kind regards
Bhavbhuti