[ 
http://mifosforge.jira.com/browse/MIFOS-3874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Udai Gupta updated MIFOS-3874:
------------------------------

    Attachment:     (was: Dec 31 interest issue.ppt)

> Interest posting batch job failure cause interest postings with wrong 
> (future) dates
> ------------------------------------------------------------------------------------
>
>                 Key: MIFOS-3874
>                 URL: http://mifosforge.jira.com/browse/MIFOS-3874
>             Project: mifos
>          Issue Type: Bug
>          Components: Savings Account
>    Affects Versions: Release 1.6.1
>         Environment: version 1.6
>            Reporter: Gayl Kennedy
>            Assignee: Udai Gupta
>            Priority: Major
>             Fix For: Release E - Iteration 9, Release E
>
>         Attachments: Gayl-sceernshot.jpg
>
>
> Our interest on saving accounts is set up to post quarterly so the first 
> quarter end was Sept 30th.
> This week we noted that some accounts had an interest posting for Sept 30th 
> but some also had it for Dec 31, 2010 which is incorrect.
> Note the 31 Dec posting had zero value.
> What will happen to those accounts on 31 Dec when they should get interest?  
> I don't understand the inconsistency
> example 1 - 3% interest - see Sept & Dec date
> Date    Description                     Amount
> 31/12/2010      Interest_Posting        0.00
> 30/09/2010      Interest_Posting        42.84
> example 2 - 3% interest - just see Sept date
> Date    Description                    Amount
> 30/09/2010      Interest_Posting        551.52
> we ran 2 queries provided by Uday - both of which returned no results.
> # 1: to see interest posting batch job was ran twice on any day.
> select * from (select count(*) as a from scheduled_tasks where
> taskname="SavingsIntPostingTask" group by date(starttime)) d where a >1
>  
> The 2nd query to see if batch job ran for any future date.
> SELECT * FROM scheduled_tasks WHERE taskname="SavingsIntPostingTask"
> AND DATE(starttime) > '2010-10-30'

-- 
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

        

------------------------------------------------------------------------------
What happens now with your Lotus Notes apps - do you make another costly 
upgrade, or settle for being marooned without product support? Time to move
off Lotus Notes and onto the cloud with Force.com, apps are easier to build,
use, and manage than apps on traditional platforms. Sign up for the Lotus 
Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues

Reply via email to