Hi,
We are working on Subsidiary Ledger of an MFI in the Philippines. The required
data for the report are the ff:
Payment Date
Receipt No.
Regular Loan (RL)
Payment
Principal
Interest
Balance
Principal
Interest
Total
Special Loan
same with RL
ICF Savings
Deposit
Withdrawal
Interest
Total
Special Savings
save with ICF
MMF1 & MMF2(Fees)
We can't come up with a proper script to link account_payment table (which has
the receipt no.) to loan tables.
we tried the following work around solutions:
looked for other column that we can reference the specific transaction (done)
looked for other tables that would somehow relate the two tables to each other.
we did found one, unfortunately it was not being filled/used by Mifos (done)
computing inside the script to get desired value but would require a lot of
complex queries (started but not yet done)
So far, option #1 works but it breaks the rule of referential integrity
(linking the comments or amount which are not unique keys - bad idea).
Although, the ideal solution is #2.
There might be someone in the community who can help us with this issue on SL.
I appreciate your response.
Thanks,
Garry Blanco
Office: 8960735
Mobile: +639063266986 / +639228286102 / +639178602002
Yahoo: [EMAIL PROTECTED]
Get your new Email address!
Grab the Email name you've always wanted before someone else does!
http://mail.promotions.yahoo.com/newdomains/aa/-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Mifos-functional mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-functional
