Re: [Mifos-developer] Trial balance request
Below is the logic for trail balance - Opening and Closing report. Using
this logic you need write SQL query and design it using Pentaho report.Hope
this might help you.
*1. Opening Balance Calculation*
Based On the Account Types (Asset,Liability,Equity,Income,Expense).
For Asset and Expense Opening Balance calculation (Debit - Credit)
account type (credit - Debit).
- Day Closing Balance - (Opening Balance + running balance)
- Running Sum = cumulative_sum (it is generated in SQL)
- Calculating Closing Balance
Asset and Expense
[(Opening balance) + (debit Total) - (Credit
[(Opening balance) - (debit Total) - (Credit
On Fri, Sep 14, 2018 at 6:09 PM brahiman yogo <bragolight@xxxxxxxxx> wrote:
> Hello, I would like to do a trial balance with for each GL account there
> is the opening balance, movements (debit / credit) and closing balance.
> Does somebody have an idea?
> Mifos-developer mailing list
> Unsubscribe or change settings at: