Due vs collected by Branch and by Loan Officer

Owned by Jeff Brewster (Unlicensed)
Last updated: Jan 24, 2011Version comment
1 min read

Data

Use dataset - mifos1.6_demo_backup24Aug10_DWH.sql.zip

Parameters

Loan Officer: Sally Magalang
Office: Pasay Branch
From: 2009-01-17
To: 2011-01-07

checks

verified last paid payments on 2009-03-02

total principal due - 102,916.50

expected result

See attached report