[Gnukhata-users] Mr. Guru's mail

[Guru गुरु]

On 15/11/11 20:13, Krishnakant Mane wrote:
> I already replied to that email and mentioned about the way we are 
> doing it.
> Its pritty easy to efficiently get the data using views which are 
> already snapshots of pre-executed queries.
> Besides the execution is happening on the server side with 
> pre-compiled stored procedures.
thanks Krishnakant. views are best way to do this.

where there is an option of 'transaction authorisation', the view can 
include both
unauthorised dr and cr balances
authorised dr and cr balances
the second only reflects authorised transactions while the former 
includes all transactions
some applications play safe by excluding unauthorised credits to party 
accounts but always including unauthorised debits to compute current 
balance.

regards
Guru

> Happy hacking.
> Krishnakant.
>
>
>
> On 15/11/11 14:46, arun kelkar wrote:
>> To all
>>
>> I read Mr. Guru's mail. I would like KK to take a decision on how to store data. As far as I remember, KK had mentioned it at least once, that all balances will be extracted dynamically as and when required.
>>
>> > From what little I understand from Mr. Guru's mail, it seems he is suggesting that after every transaction is entered or edited a new current balance will be calculated for the concerned accounts and stored alongwith the transaction data.
>>
>> I personally cannot comment upon the comparative efficacy of these and would the decision to the team leader.
>> arun kelkar
>>
>> arun kelkar
>>
>>
>> _______________________________________________
>> Gnukhata-users mailing list
>> Gnukhata-users at cis-india.org
>> http://lists.cis-india.org/mailman/listinfo/gnukhata-users
>
>
> _______________________________________________
> Gnukhata-users mailing list
> Gnukhata-users at cis-india.org
> http://lists.cis-india.org/mailman/listinfo/gnukhata-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.cis-india.org/pipermail/gnukhata-users/attachments/20111117/fdb20fc7/attachment.html>