[
http://mifosforge.jira.com/browse/MIFOS-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Udai Gupta updated MIFOS-2804:
------------------------------
Attachment: mysqldump_MIFOS-2804_DBv225_mifos14.zip
I wasn't able to reproduce this behavior using example 1. Tried on 1.5.x and
1.4.x branch, Its always 38.
Database stores 37.500 (not rounded amount) in account_fee table.
I am attaching the mysql dump of the test database for example 1. It has
database version 225 (Mifos 1.4.x), it can also be used for 1.5.x. One Client,
One Group, One Center, One Branch, One Loan officer, One Loan Product, One Loan
%age Fee.
Can someone confirm that the dump contains the right scenario.
> digitsAfterDecimal=0 does not properly round percentage fees
> ------------------------------------------------------------
>
> Key: MIFOS-2804
> URL: http://mifosforge.jira.com/browse/MIFOS-2804
> Project: mifos
> Issue Type: Bug
> Affects Versions: Release 1.4
> Reporter: Sam Birney
> Assignee: mifosdeveloperqueue
> Priority: Major
> Fix For: Gazelle C
>
> Attachments: mysqldump_MIFOS-2804_DBv225_mifos14.zip
>
>
> Configure AccountingRules.DigitsAfterDecimal=0
> REPRO (example 1):
> 1. create a fee that is a % of the loan principal
> 2. issue a loan for 1500 using this fee with a value of 2.5%
> 3. notice that the fee amount displays as 38 on the preview screen
> 4. submit the loan
> 5. view the repayment schedule
> 6. notice that the same fee amount now displays as 37
> 7. check the account_fees table and see the amount is stored as 37.50
> EXPECTED RESULTS:
> The fee should be rounded according to the rounding mode, for example if it
> is HALF_UP or CEILING it should be stored in the account_fees table and
> displayed in both screens as 38. Or, if the rounding mode is FLOOR, it
> should be stored and displayed as 37.
> It is a bug to inconsistently show a rounded version of what is in the
> account_fees table, but the bigger bug is that the number in that table is
> not rounded to 0 decimal places. There is no point in showing 37 or 38 if
> Mifos will expect a payment of 37.50 (which is impossible to apply when
> DigitsAfterDecimal=0).
> REPRO (example 2):
> 1. create a fee that is a % of the loan principal
> 2. issue a loan for 1225 using this fee with a value of 2%
> 3. notice that the fee amount displays as 24 on the preview screen
> 4. submit the loan
> 5. view the repayment schedule
> 6. notice that the same fee amount now displays as 25
> 7. check the account_fees table and see the amount is stored as 24.5
> This is the same issue, but interesting to note that the two pages now
> display rounded amounts in the opposite direction as in the first repro
> example.
> Anyway, we are not sure what to do when percentage fees result in numbers
> that are not rounded off according to DigitsAfterDecimal=0 because there are
> no US coins here, only dollars...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
