Hello Brahiman,
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)
and other
account type (credit - Debit).
*2.Closing Balance*
- 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
Total)]
other Accounts
[(Opening balance) - (debit Total) - (Credit
Total)]
Regards,
Sangamesh.Nadagoudar
On Fri, Sep 14, 2018 at 6:09 PM brahiman yogo <[email protected]> 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
> [email protected]
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
