[
http://mifosforge.jira.com/browse/MIFOS-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59773#action_59773
]
Udai Gupta edited comment on MIFOS-3600 at 8/27/10 8:47 AM:
------------------------------------------------------------
I am attaching this dataset to make the repro easy (move system date to 31
March 2011)
1. Search for "Group 0"
2. Create a savings account using "Q Savings"
3. make a deposit of 500.
4. make adjustment of 400. (re-entering/correcting the deposit)
the balance will be show as 400 in Savings activity, but in ACCOUNT_TRXN table
the last transaction balance is 100.
SELECT ACCOUNT_ACTION_ID,BALANCE, AMOUNT, ACTION_DATE, CREATED_DATE FROM
SAVINGS_TRXN_DETAIL s JOIN ACCOUNT_TRXN a ON s.account_trxn_id =
a.account_trxn_id WHERE ACCOUNT_ID=21
The current interest calculation is be going to use ACCOUNT_TRXN to get the
last transaction balance of the day which in this case will be 100, but it's
wrong as per the SAVINGS_ACTIVITY it should be 400 which is the right balance.
was (Author: ugupta):
I am attaching this dataset to make the repro easy (move system data to 31
March 2011)
1. Search for "Group 0"
2. Create a savings account using "Q Savings"
3. make a deposit of 500.
4. make adjustment of 400. (re-entering/correcting the deposit)
the balance will be show as 400 in Savings activity, but in ACCOUNT_TRXN table
the last transaction balance is 100.
SELECT ACCOUNT_ACTION_ID,BALANCE, AMOUNT, ACTION_DATE, CREATED_DATE FROM
SAVINGS_TRXN_DETAIL s JOIN ACCOUNT_TRXN a ON s.account_trxn_id =
a.account_trxn_id WHERE ACCOUNT_ID=21
The current interest calculation is be going to use ACCOUNT_TRXN to get the
last transaction balance of the day which in this case will be 100, but it's
wrong as per the SAVINGS_ACTIVITY it should be 400 which is the right balance.
> create repro
> ------------
>
> Key: MIFOS-3600
> URL: http://mifosforge.jira.com/browse/MIFOS-3600
> Project: mifos
> Issue Type: Dev Task
> Components: Savings Account
> Reporter: Adam Monsen
> Assignee: Adam Monsen
> Fix For: Release E - Iteration 5, Release E
>
> Attachments: account_trxn.png, dataset1.6.x.sql.zip,
> savings_activity.png
>
>
> * make savings account w/mandatory deposits
> ** $100/mo or whatever
> * do deposits of > $100
> * make withdrawls
> * make adjustments
> * check ordering in account_trxn table, compare w/savings_activity_details
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
