|
Sander van der Heyden A heads up on the changes Pramod is making for this issue
Modification to gl_journal_entry_table (since each journal entry is already linked to a branch, running balances are also derived at a branch level)
1) Add a flag to determine if running balance is calculated for a journal entry
2) Add a field to store the derived running balance
All newly added journal entries would not have running balances calculated
We have a batch job for doing the same at the end of day or after being triggered by the user before seeing any reports that use this field (we might want to add a "cash book" report showing the running bank balance etc to illustrate the usage of this field).
The job should be quite fast since it would run on daily basis (unless backdated transactions are made regularly rendering future running balances dirty...hence requiring all future running balances be re-calculated)
|
