...
- 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.
...
- 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
...