SavingsTrxnDetailEntity("ACCOUNT_TRXN JOIN SAVINGS_TRXN_DETAIL") has unexpected/unknown entries/ordering

Description

There are some entries where the ordering is not correct for same date (may be an unordered set is being used in the code of building accounting entries), these entries can result in wrong interest calculation as SavingsTrxnDetailsEntity is used for interest calculation. In case of Average balance calculation the balance of last transaction(by id) on same day is considered for average balance calculation, it was found that there can be zero balance entires in some places resulting the zero balance for that day due to mis-ordering of entries (see the image account_trxn.png)

There are some places where there are zero deposit amount and zero balance which seems unnecessary information as compared to SAVINGS_ACTIVITY_DETAILS

Environment

None

Attachments

Assignee

UdaiU

Reporter

UdaiU

Labels

None

URL

None

Story Points

1

Team

Core

Scheduled For

Product

Epic

Notify

None

productboard URL

None

Man Day Estimate

None

Fix versions

Affects versions

Priority

Major
Configure