Test plan for Tally Account Integration

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

Current Owner:

Jeff Brewster

Test Plan: MIFOS Interface to Tally

Pre-test setup

  1. Install Tally 9, version 1.82 on test server "testgreen.mifos.org".
  2. Create branches, groups, and ledgers in Tally to match attached Light chart of accounts.
  3. Set up automatic numbering of vouchers in Tally

Todo:

  1. Data set with "Light MF" data
  2. Pentaho server - create testing area on Pentaho
  3. Report (test artifact)
  4. 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)

Steps for generating Tally GL interface report

(steps are intended for test server)

1. Connect to Pentaho User Console (PUC):  https://testing-reporting-light-microfinance.mifos.org
2. Login as user:  "Joe", password: 
3. View Mifos/MifosTallyInterface folder on upper left of PUC.
4. Double click MifosTallyInterface folder, view two files on lower left:
    Mifos - Tally GL Interface    (This generates PDF report and must be run 1st)
    Tally Output - Latest        (this generates the XML for Tally and must be run 2nd)
5. In Pentaho Double click Mifos - Tally GL Interface, see form with From Date, To Date.
6. Enter date range and click ok
7. View and or print generated PDF report.
8. Double click "Tally Output - Latest" in Pentaho
9. Click Run... button to generate XML.  User is prompted to Save file locally.  
10. In Save dialog, Enter name for tally xml import file - e.g. MifosAccountingExport-2010-04-01.xml and save.
11. Go to Tally, in Gateway Tally page, select "Import of Data".
12. Pick Voucher
13. enter path and name of XML file saved in step 10.
14. Check tally.imp file for import results.  Review imported vouchers on Reports/Display/Day Book for day that has one or more vouchers imported.

Test Cases - 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
    • 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