[
http://mifosforge.jira.com/browse/MIFOS-2829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ryan Whitney reassigned MIFOS-2829:
-----------------------------------
Assignee: Kay Chau (was: Ryan Whitney)
I suspect this is a pretty bad issue, but SECDEP has been working around it.
If you run "select * from account_fees WHERE LAST_APPLIED_DATE IS NULL;" you
find this case for a lot of accounts.
When I looked at Virginia's account, I see a bunch of charges applied to the
account for client charges but nothing actually CHARGED to the account until
this week when they removed the charges and re-added them. This is not ideal,
because it looks like they missed the charge that should of been paid on
Monday.
It also looks like maybe even though there is an issue with charging the
account, they can still make the expected payment (maybe through the collection
sheet entry?)
This is odd and it appears SECDEP is handling it but we should fix this.
I also suspect this is related to Bug MIFOS-2793: Client Fee charges aren't
always appearing in table customer_account_activity
> Client fee charges missing for some clients on 4/5/2010
> -------------------------------------------------------
>
> Key: MIFOS-2829
> URL: http://mifosforge.jira.com/browse/MIFOS-2829
> Project: mifos
> Issue Type: Bug
> Components: Fee
> Affects Versions: Release 1.3.1
> Environment: SECDEP production server and database
> Reporter: Keith Pierce
> Assignee: Kay Chau
> Fix For: Gazelle Backlog
>
> Attachments: null last_applied_date
>
>
> I noticed an apparent anomaly with a SECDEP client's fees when investigating
> issue 2793. The client is Alcazar Virginia, customer number 0002-000011670,
> and she meets on Mondays. According to database entries, customer fees have
> been charged through 3/22, but no fees were charged on 4/5. Fees should have
> been charged by the batch job ApplyCustomerFee when it ran on Tuesday 3/23
> (charged to the 3/29 meeting date, which was shifted forward out of Holy
> Week, to 4/5).
> I looked at the database status of her account fees, and found that the value
> of ACCOUNT_FEES.LAST_APPLIED_DATE is NULL. A null value will cause the batch
> job to skip the account and not apply fees.
> However, I am puzzled by the null value. It could not have been null prior to
> 3/16, otherwise prior fees would not have been applied, but they do show up
> in the table customer_fee_schedule for dates 3/22 and earlier. It appears
> that some time between 3/16 and 3/23 the value was nulled out. There are no
> entries in fee activities to indicate that something changed about her fees.
> I've attached sql outputs showing (a) that charges were applied 3/22 and
> earlier (b) that table ACCOUNT_FEES has fee entries for this client but
> nearly all values are NULL, and (c) No entries in account_activity show
> modification of fees.
--
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
