Hi Kay,
The collection sheet is a vital functionality in our MFI since it cuts down
the time needed to post transactions by 70%.
This is the situation, we have one fully dedicated data entry clerk and one
part time who helps out 3 hours a day and we the data is only 2 days behind
on a bad day for 6,500 clients.
If the collection sheet does not work well, we will be forced to have 3
fully dedicated data entry clerks and 2 part time working 3 hours a day for
the same number of clients. We came to this conclusion when we upgraded to
v1.5.1 and the collection sheet was not working which created a backlog of 5
days work.
In my experience for the time I have worked with Mifos, when the batch jobs
are not running well, the collection sheet does not display cells for active
loans where payments to loan accounts are posted which means that every loan
repayment has to be posted one by one in the client's loan dashboard
(seriously tedious and time consuming).
One of the reasons we were upgrading to v1.5.1 was because the grace period
is not working well in v1.3, "grace on all repayments" still charges
interest during the grace period. But in 1.5.1 this funcionality works well.
So what we have been doing is, if a loan is disbursed on 3/8/2010, in the
system we disburse it on 17/8/2010 (3 weeks grace period). The disbursement
date in the system is calculated mentaly by the person who is booking the
loans. This is a loophole for something serious in the future. Now all this
is done assuming that no client makes payment during the grace period (which
happens ALOT!).
Polly
On 23 July 2010 16:23, Kay Chau <[email protected]> wrote:
> Hi Polly
>
>
>
> This task is actually unneeded hence why it’s commented out. We have
> removed the batch job altogether in 1.6.
>
>
>
> What missing cells are you seeing in collection sheet? Is it the report or
> collection sheet entry?
>
>
>
> Kay
>
>
>
> *From:* Polly [mailto:[email protected]]
> *Sent:* Tuesday, July 20, 2010 2:04 PM
>
> *To:* A good place to start for users or folks new to Mifos.
> *Subject:* Re: [Mifos-users] V 1.5.1
>
>
>
> Jeff,
>
> Thank you. The downgrade went well. Why is the batch job scheduler for
> collection sheet disabled in the task.xml?
>
> * <!--<scheduler>
> <task-class-name>CollectionSheetTask</task-class-name>
> <initial-time>24:00:00</initial-time>
> <delay-time>86400</delay-time>
> </scheduler>-->*
>
> I am suspecting that this might be the cause for the missing cells in the
> collection sheet. My understanding is that the batch jobs affect the
> functionality in the collection sheet. We are planning to upgrade the test
> server to v.1.6 to see if the collection sheet is working well.
>
> Polly.
>
> On 19 July 2010 23:33, Jeff Brewster <[email protected]>
> wrote:
>
> Polly,
>
> Did you delete the tomcat work directory as part of the upgrade? You can
> still give that a try if you didn’t. Stop tomcat, then delete the mifos
> folder under Tomcat/work/Catalina/localhost, and restart tomcat.
>
>
>
> Jeff
>
>
>
>
>
>
>
> *From:* Polly [mailto:[email protected]]
> *Sent:* Sunday, July 18, 2010 10:23 PM
> *To:* A good place to start for users or folks new to Mifos.
> *Subject:* Re: [Mifos-users] V 1.5.1
>
>
>
> Hi,
>
> When the you click on submit on the collection sheet you get the following
> error
>
> javax.servlet.ServletException: org.mifos.core.MifosRuntimeException: Input
> Errors Found:
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 3641 Account Id: 7845
>
>
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 7087 Account Id: 19128
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 8687 Account Id: 26880
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 9453 Account Id: 29786
>
>
>
>
>
>
> org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
>
>
> org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:233)
>
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
>
>
>
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
>
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
>
>
> org.mifos.security.util.LoginFilter.doFilter(LoginFilter.java:85)
>
>
> org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
>
> *root cause*
>
> org.mifos.core.MifosRuntimeException: Input Errors Found:
>
>
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 3641 Account Id: 7845
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 7087 Account Id: 19128
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 8687 Account Id: 26880
>
>
>
> ACCOUNT_DOESNT_BELONG_TO_CUSTOMER: Customer Id: 9453 Account Id: 29786
>
>
>
>
> org.mifos.application.servicefacade.CollectionSheetServiceFacadeWebTier.saveCollectionSheet(CollectionSheetServiceFacadeWebTier.java:237)
>
>
> org.mifos.application.collectionsheet.struts.action.CollectionSheetEntryAction.create(CollectionSheetEntryAction.java:271)
>
>
>
> sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>
>
>
> java.lang.reflect.Method.invoke(Method.java:597)
>
>
> org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:274)
>
>
> org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:194)
>
>
> org.mifos.framework.struts.action.BaseAction.execute(BaseAction.java:105)
>
>
>
>
> org.mifos.framework.struts.action.MifosRequestProcessor.processActionPerform(MifosRequestProcessor.java:204)
>
>
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
>
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
>
>
>
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>
> org.mifos.security.util.LoginFilter.doFilter(LoginFilter.java:85)
>
>
>
>
> org.mifos.framework.persistence.DatabaseInitFilter.doFilter(DatabaseInitFilter.java:51)
>
> The accounts numbers in question are ok and yet this error is generated.
> I have attached 2 pages from Mifos demo server showing a client with active
> loans but on the collection sheet page there are no cells to post
> transactions.
>
> Polly
>
> On 18 July 2010 15:06, Polly <[email protected]> wrote:
>
> Hello,
>
> The collection sheet in v 1.5.1 is not working properly. On the server we
> were still using v 1.3.
> We did not upgrade to v1.4. because it was not supporting loans with 0%
> interest. v1.5 on the test server was working well except that in the
> collection sheet it was only displaying cells for loans that had amounts
> that were due whereas in our MFI we have clients paying constantly even
> where there are no amounts due.
> So on Thursday we went ahead and did the upgrade on the server from v 1.3
> to v 1.5.1. Now the collection sheet is not working at all, not only does it
> not display cells for posting loan transactions but even when submitting
> data for savings transactions we get an error "HTTP 500".
> We had taken the risk because there's one feature we liked about v 1.5.1.
> in that it supported grace period on all installment whereas that feature in
> v1.3 still charges interest.
> We allowed batch jobs to run for 3 days uninterrupted hoping it would
> correct the collection sheet issue but this is causing a delay in posting
> data. So we are planning to do a roll back to v1.3.
>
> Has anyone else faced the same problem with the collection sheet with v1.5?
> --
> Best Regards
> Polly Najori
>
>
>
>
> --
> Best Regards
> Polly Najori
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
>
>
> --
> Best Regards
> Polly Najori
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Sprint
> What will you do first with EVO, the first 4G phone?
> Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
> _______________________________________________
> Mifos-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
>
--
Best Regards
Polly Najori
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
