[
http://mifosforge.jira.com/browse/MIFOS-2633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
rwhitney reassigned MIFOS-2633:
-------------------------------
Assignee: Adam Monsen (was: rwhitney)
This solution will not work for a couple of reasons.
1. All other transactions, from what I've been able to tell while working on
the database, use ACTION_DATE as the date the transaction is supposed to have
happened. Interest posting is the outlier here. (See account_trxn table)
2. CREATED_DATE will not work as that does not allow for post dating of
transactions (IE, I posted a monday transaction today on Thursday, then it will
show up as Thursday).
The interest posting needs to be changed to fall in line with the rest of the
transactions. This also creates issues with the general ledger as well.
As for financial_trxn.POSTED_DATE, I'm not sure what this is for. Kay and I
were discussing, maybe this will always be equal to ACTION_DATE?
BTW, I looked at the database, I do not see savings_trxn_detail.ACTION_DATE or
savings_trxn_detail.CREATED_DATE. In fact, there are no dates in the
savings_trxn_detail table at all.
Only places I see dates are as follows:
account_trxn - DUE_DATE, ACTION_DATE, CREATED_DATE (timestamp)
financial_trxn - ACTION_DATE, POSTED_DATE
account_payment - PAYMENT_DATE
> 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
