[
http://mifosforge.jira.com/browse/MIFOS-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59778#action_59778
]
Adam Monsen commented on MIFOS-3600:
------------------------------------
I followed the repro steps on my machine, but I got different results.
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
{code}
+-------------------+----------+-----------+-------------+---------------------+
| ACCOUNT_ACTION_ID | BALANCE | AMOUNT | ACTION_DATE | CREATED_DATE |
+-------------------+----------+-----------+-------------+---------------------+
| 6 | 500.0000 | 500.0000 | 2010-08-27 | 2010-08-27 16:05:52 |
| 6 | 400.0000 | 400.0000 | 2010-08-27 | 2010-08-27 16:06:07 |
| 14 | 0.0000 | -500.0000 | 2010-08-27 | 2010-08-27 16:06:07 |
+-------------------+----------+-----------+-------------+---------------------+
3 rows in set (0.00 sec)
{code}
Looks like I ended up with a balance of 0!
> 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
