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