[
http://mifosforge.jira.com/browse/MIFOS-2622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adam Monsen updated MIFOS-2622:
-------------------------------
Story Points: 2
> Savings transactions set account_payment.payment_date to the date of the
> entry into the database and not the transaction date
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: MIFOS-2622
> URL: http://mifosforge.jira.com/browse/MIFOS-2622
> Project: mifos
> Issue Type: Bug
> Components: Database, Savings Account
> Affects Versions: Release 1.3.1
> Reporter: Ryan Whitney
> Assignee: mifosdeveloperqueue
> Fix For: Gazelle C
>
>
> For all savings deposits and withdrawals, the account_payment.payment_date is
> set to the date the record is created and not the actual date entered for the
> transaction. (ie, not equal to account_trxn.action_date). for other
> transaction types, the payment date is equal to the account_trxn.action_date
> This query can help find examples in a sample database
> SELECT account_payment.account_id,
> account.global_account_num,
> account_trxn.account_trxn_id,
> account_payment.payment_id,
> account_payment.amount AS payment_amount,
> account_trxn.amount AS trxn_amount,
> account_payment.receipt_number,
> account_payment.payment_date,
> account_trxn.action_date,
> account_trxn.created_date,
> SUBSTR(lookup_value.LOOKUP_NAME,15) AS Acct_Action
> FROM account_trxn
> INNER JOIN account_payment ON account_trxn.payment_id =
> account_payment.payment_id
> INNER JOIN account ON account_trxn.account_id = account.account_id
> INNER JOIN account_action ON account_action.account_action_id =
> account_trxn.account_action_id
> INNER JOIN lookup_value ON lookup_value.lookup_id = account_action.lookup_id
> WHERE account_trxn.customer_id = <enter customer id>
> Also, John Woodlock discovered this works correctly when entering in
> transactions with the collection sheet, but you can replicate the issue if
> you are enter in the savings transaction through the account detail page.
> (this was on Mifos 1.4).
> Not sure this affects Mifos functionality, but can affect reporting efforts.
--
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
