...
- with mutliple GL's, have multiple loan products that point to two different ledgers
...
- data needs
- disbursals, loan repayments, fee repayments (loan and client), adjustments, loan writeoff, reschedule, (reschedule means adjustments)
Test Cases - report generation = GL Interface Report
- Generate reports to XML
- XML file format can be downloaded and viewable (*nix file vs. windows file?)compare to expected result. TBD - specific cases- see attached example
- Generate reports to PDF, default pentaho output.
- check the data is accurate in the import xml file. - Rollup as the right amount.; right voucher type goes with with right transactions - receipt; payment; and journal. Refer to kay's spreadsheet specification on these proper mappings.
...
make sure the GL interface report matches spec.
Test cases - import to Tally using LightMF data and configuration
- import daily report - date range 1 day
- multiple days of transactions per import date
- single branch
- two branch
...
- Criteria
- response time - less than 10 sec?
- accuracy of imported data - see below
- appropriate ledger accounts updated
- Import errors
- import twice denied?
- import invalid range - to<from
- multiple days?
Test cases
...
- scenarios created on test data
Loan activity
Bavla office 50000 loans:
000100000000009 - 1 payment of 1761.0, 1 adjustment of 1761.0
000100000000017
000100000000021
000100000000025
000100000000033
000100000000037
000100000000045 - 192 trxns -- pd amt: 1603.2; 596.4 prin, 1006.8 int
000100000000049 - 192 trxns -- pd amt: 115.2; 115.2 interest
000100000000053 - 192 trxns -- pd amt: 115.2; 115.2 interest
000100000000057 - 96 trxns -- pd amt: 57.6; 57.6 interest
2000 loan with fees:
000100000000089 - pd 364.0 principal; 2.4 interest; 10007.6 loan fees (9999.9 & 7.7)
2000 loan disbursed:
000100000000090 - disbursed 2000.0
Khada office 50000 loans:
000100000000069 - 96 trxns -- pd amt: 57.6; all interest
000100000000073 - 96 trxns -- pd amt: 57.6; all interest
000100000000077 - 96 trxns -- pd amt: 57.6; all interest
000100000000081 - 96 trxns -- pd amt: 62.4; all interest
000100000000085 - 96 trxns -- pd amt: 38.2; all interest
disbursed:
000100000000086 - 2000.0 disbursed
000100000000087
000100000000088
Client Charges
client 0005-000000051
Fee Type: Amount
MemberInsuranceFee 55.5
MemberFee 13.3
MiscFee 9999.9
Misc Fee 34.3
Misc Penalty 45.4
total: 10148.4
config notes:
defined fees
------------
LoanProcFee - 7.7
MemberFee - 13.3
MemberInsuranceFee - 55.5
MiscFee - 9999.9
EarlyRepaymentFee - 9999.9
Loan with fees:
MyLoanProduct1283666534465
-------
rev 2:
account 000100000000033
paid 1000.0 on 4/2
adjusted 1000.0 on 4/2
paid 1111.0 on 4/1
dusbursed 2432.9 on 4/3
------------------
rev 3
on 4/4/2010
write off on loan 000100000000009 amount = 51678.0
50000 prin
1678 int
paid 33.0 on loan 000100000000090
made payment and adjustment on loan 000100000000037 of 222.0