Current Owner: |
Jeff Brewster |
(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.
make sure the GL interface report matches spec.
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 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