Title: Message Title
|
|
|
|
[~andrew] While this issue has been fixed (we no longer return invalid) , the transaction type now returned is "accrual" . Prior to 1.22 we had transaction types like Fees Applied, Interest applied etc which have since been deprecated.
The upfront accrual loan transaction transactions (on interest application and fee application) are added back for loan products using either no accounting or cash based accounting (from 1.23, please ensure that your customers are directly upgraded to 1.23 and not 1.22 which had removed this functionality)
However, we can still create reports which can show the actual type of accrual (fee applied, penalty applied, interest applied etc) with an sql query on the lines of
{code}
SELECT CASE WHEN (transaction_type_enum=10 AND interest_portion_derived=amount) THEN "Interest Applied" WHEN (transaction_type_enum=10 AND fee_charges_portion_derived=amount) THEN "Fee Applied" WHEN (transaction_type_enum=10 AND penalty_charges_portion_derived=amount) THEN "Penalty Applied" WHEN transaction_type_enum=10 THEN "Accruals" ELSE "others" END,l.*
FROM m_loan_transaction l
WHERE l.transaction_type_enum IN (10);
{code}
Similar logic can be used for clearly showing labels on the User interface
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
