|
andrewDzakpasu 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 (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
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);
Similar logic can be used for clearly showing labels on the User interface
|
