Title: Message Title
|
|
|
|
|
|
Mike's description:
Normal Process: a client pays a Recurring Deposit Amount of 400 NGN daily into his Recurring Deposit Account locally named as Daily Contribution Account
The account is setup as follows:
Period: 12 Months Rate of Interest: 0% Deposit Frequency: Daily
Recurring Deposit Amount: 400 NGN Account ID: 5
What MFI allows:
A client can update only is Recurring Deposit Amount (Up or Down of current value) all other settings remain the same,
A client is allowed to withdraw funds from his account
My Local solution:
I run a SQL query that updates three (3) tables:
M_DEPOSIT_ACCOUNT_RECURRING_DETAIL
M_MANDATORY_SAVINGS_SCHEDULE
M_DEPOSIT_ACCOUNT_TERM_AND_PRECLOSURE
UPDATE m_deposit_account_recurring_detail SET mandatory_recommended_deposit_amount = '500.000000' WHERE id = '1';
UPDATE m_mandatory_savings_schedule SET deposit_amount = '500.000000'
WHERE savings_account_id = '1'
AND completed_derived = b'0'
AND duedate > = '2014-12-03';
UPDATE m_deposit_account_term_and_preclosure SET maturity_amount =
(Select sum( deposit_amount) as DA from m_mandatory_savings_schedule WHERE savings_account_id='1')
WHERE savings_account_id = '1';
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
