Current Owner: |
Jeff Brewster |
Test Plan: MIFOS Interface to Tally
Pre-test setup
- Install Tally 9, version 1.82 on test server "testgreen.mifos.org".
- Create branches, groups, and ledgers in Tally to match attached Light chart of accounts.
- Set up automatic numbering of vouchers in Tally
Todo:
- Data set with "Light MF" data
- Pentaho server - create testing area on Pentaho
- Report (test artifact)
- Finalize xml spec (Kay)
Generate data for report
- generate report for 1st day of month, a single branch transactions
- loan disbursal
- loan repayment
- generate report for 1st day of month, a two branch transactions
- generate volume report - e.g. 1000 users, 1000 transactions
- 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 - 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 specification on these proper mappings.
-
- want xml to be generated correctly - just import to tally? Review xml to see if it matches specification
-
- what if we import to a "badly configured" tally - what happens?
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
- one bad branch; two good branches
- large transaction report
- large xml file - e.g. 2 week range of dates
- transactions that are entered day late are the only ones that get reported for previous day - e.g. aug 31 txns entered on sept 1
-
- 999 rounding - goes to it's own ledger
- 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