Hi Garry,
In order for us to help you on this issue, it would be really helpful to have a
few pieces of information:
1. A sample of the report so that people can see visually what the report
needs to contain. This is easier than just putting in a list of the fields.
2. Which fields you are having trouble generating and why. Specific
details of which tables/fields you are trying to link, which fields are in the
schema but not populated, etc. The snapshot of the schema which references
your examples would be helpful for illustrating to the community where you are
finding challenges.
With this information, I think members of the community will be better poised
to understand your question and help you out.
Thanks,
Aliya
From: Garry Blanco [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 7:53 PM
To: [EMAIL PROTECTED]; [email protected]
Cc: Sherwin Urbina; Jevers M Esteban
Subject: [Mifos-functional] Subsidiary Ledger Issue
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:
1. looked for other column that we can reference the specific transaction
(done)
2. 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)
3. 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]
________________________________
New Email addresses available on Yahoo!
<http://sg.rd.yahoo.com/aa/mail/domainchoice/mail/signature/*http:/mail.promotions.yahoo.com/newdomains/aa/>
Get the Email name you've always wanted on the new @ymail and @rocketmail.
Hurry before someone else does!
-------------------------------------------------------------------------
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
