[Mifos-issues] [JIRA] (MIFOSX-351) Allow retrieval of full journal entries using transaction_id

Mon, 13 May 2013 11:35:36 -0700

Issue Type: Improvement Improvement
Assignee: keithwoodlock
Created: 13/May/13 11:34 AM
Description:

Currently a GL Entry is created with one or more debits and credits. But when retrieving only the individual entries of the transaction can be retrieved via /api/v1/journalentries/

{entryId}

.

It would be useful if a full transaction could also be retrieved in a similar JSON format to the POST of a transaction listing all debits and credits to reconstruct the entire transaction.

This also ties in better with the Reversing of a transaction (as not just a single entry is reversed, but the entire transaction).

Example of desired output (in SQL Query):
SELECT
glj.ref_num as reference,
glj.transaction_id as transaction_id,
glj.reversed as is_reversed,
glj.reversal_id as reversed_from,
glj.account_id as account_id,
glj.office_id as `office_id`,
mo.name as office_name,
gla.name as account_name,
gla.gl_code as account_code,
entry_date as entry_date,
amount,
glj.description,
createdby_id as createdby_id,
mcu.username as createdby_name,
created_date,
mcl.username as lastmodifiedby_name,
lastmodified_date,
case when type_enum = 1 then 'debit' else 'credit' end as entry_type
FROM `acc_gl_journal_entry` as glj
LEFT JOIN acc_gl_account gla ON glj.account_id = gla.id
LEFT JOIN m_office as mo ON glj.office_id = mo.id
LEFT JOIN m_appuser as mcu ON glj.`createdby_id` = mcu.id
LEFT JOIN m_appuser as mcl ON glj.`lastmodifiedby_id` = mcl.id
WHERE transaction_id = <transactionID>
Project: Mifos X
Priority: Minor Minor
Reporter: Sander van der Heyden
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to