[
http://mifosforge.jira.com/browse/MIFOS-2633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kay Chau resolved MIFOS-2633.
-----------------------------
Resolution: Won't Fix
I'm going to resolve this issue and open a new issue for inconsistency in
storing of dates for transactions
> Transaction date for Interest Posting is not correct
> ----------------------------------------------------
>
> Key: MIFOS-2633
> URL: http://mifosforge.jira.com/browse/MIFOS-2633
> Project: mifos
> Issue Type: Bug
> Components: Database, Savings Account
> Affects Versions: Release 1.3.1
> Environment: SECDEP Servers
> Reporter: rwhitney
> Assignee: Adam Monsen
> Priority: Major
> Fix For: Gazelle C, Iteration 6
>
> Attachments: tasks_data.txt
>
>
> This is related to issue 2199. It looks like the fix entered then just
> changed a cosmetic issue on the front end but not the actual issue..., so
> currently when interest is posted to savings account, the transaction date is
> not being set correctly (in the secdep data, it ran on 9/30/09 but the date
> for the transaction was set to 10/03/09...)
> As far as I can tell in the database, for transactions the "ACTION_DATE" is
> the date of the expected transaction and the CREATED_DATE is the date the
> entry was actually made (this would be for the table account_trxn).
> For the financial_trxn table, things get kind of confusing as you have
> ACTION_DATE and POSTED_DATE. From matching the database records to the Mifos
> UI, it looks like again, the ACTION_DATE is the transaction date and
> POSTED_DATE was the date the record was entered into the system.
> So for the SECDEP interest posting, we see the ACTION_DATE being set to
> 10/03/09 for both the account_trxn and financial_trxn, but the
> action_trxn.CREATED_DATE and financial_trxn.POSTED_DATE are set to 9/30/09,
> when the script ran. Even more interesting, is if you look at the account
> activity for the account in Mifos, the interest shows the transaction date
> being 9/30/09, but if you look at the transactional record, it shows the
> transaction date is 10/03/09.
> I think there's some issues here
> 1. It's not clear where the account activity pulls its date for the interest
> posting from and whether that's the correct place (or where are the rest of
> the transactions pulling that date for)
> 2. The use of POSTED_DATE in the financial_trxn table is causing some
> confusion and there's confusion in general about what date fields mean what
> in Mifos. As far as I can tell, the ACTION_DATE is the date of the
> transaction and CREATED_DATE and POSTED_DATE are the date the record was
> created (unclear about others). That's confusing, but not sure if we want to
> change the column title.
> Another thing to point out, 10/03/09 is a weird date for the savings posting
> but it is a Saturday. SECDEP only does transactions from Mon-Fri (according
> to its org settings), so maybe this is to be expected, that Mifos posts on
> the next non-meeting date?
--
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
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
