[
https://issues.apache.org/jira/browse/FINERACT-241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16106840#comment-16106840
]
ASF GitHub Bot commented on FINERACT-241:
-----------------------------------------
Github user Ippezrobert commented on the issue:
https://github.com/apache/fineract/pull/380
@nazeer1100126 , am working on the changes you requested for FINERACT-241.
But i have a challenge of relating m_note table with either
m_savings_account_transaction or m_savings_account for getting this note to
show it in the UI. Any clue here?
It would be better to match each notes with its transactions so that we
know how each transaction has be narrated. So we must relate m_note table with
m_savings_account_transaction tr 'left join m_note mn on tr.id =
mn.savings_account_transaction_id' . But duplicates each transaction row in the
result-set.
This query would have worked but i realized savings_account_transaction_id
is not getting inserted into m_note when a transaction occurs.
select tr.id as transactionId, sa.account_no as Account,
tr.transaction_date as transactionDate, tr.amount as transactionAmount,
tr.running_balance_derived as runningBalance,
au.username as submittedByUsername,
mn.note as note
from m_savings_account sa
join m_savings_account_transaction tr on tr.savings_account_id = sa.id
left join m_appuser au on au.id=tr.appuser_id
left join m_note mn on tr.id = mn.savings_account_transaction_id
> Include "Add Note" to Deposit and Withdrawal screen in savings account
> ----------------------------------------------------------------------
>
> Key: FINERACT-241
> URL: https://issues.apache.org/jira/browse/FINERACT-241
> Project: Apache Fineract
> Issue Type: Improvement
> Reporter: Dayna Harp
> Assignee: Markus Geiss
> Labels: beginner, p3
>
> https://mifosforge.jira.com/browse/MIFOSX-2620
> Refer to MIFOSX for images
> Include "Add Note" to Deposit and Withdrawal screen in savings account so
> that narration can be added especially name of the person who has deposited
> which may not be necessarily the account holder. Its good for controls and
> follow ups.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
