Hi, Based on the backup sent, the job to populate the data warehouse didn't work due to an account being created before a client. The problem with the reports is that although there is a note that shows "Data for this report last updated on ERROR" you can still run the report against the partially populated data warehouse and get crazy results.
If you run the following sql against the mifos database the data warehouse job will run fully. update customer set created_date = '2011-12-09' where customer_id = 31; After than when I checked the principal outstanding for the 2 branches you highlight it seemed to be the same as on the Active Loan Summary per Branch (mostly, there might be a loan missing in NELLUTLA due to reasons listed later on in the email) It could well be that the issues Ramesh fixed are different to the ones highlighted in this issue. Also, I don't think you can rely too much on the data warehouse reports because its a small amount of data and there were a couple of warning messages to do with not finding loan officer and branch names in the job output. Must admit often mifos dev data doesn't seem to work well with the data warehouse because of moving system dates about and renaming loan officers and branches. But the takeaway point is I think the reports aren't ignoring loans in bad standing (I did notice that the "BalancesOutstanding" report lists all loans as being in good standing). John On Fri, Dec 16, 2011 at 6:10 PM, Ramesh Nayak <[email protected]> wrote: > Hi, > > We have also encounter similar issues. > > We have fixed the same I shall be raising the bugs in jira and attach the > patches by Wednesday. > > Thanks and Regards, > Ramesh > > > On Thu, Dec 15, 2011 at 9:25 PM, John Woodlock <[email protected]> > wrote: >> >> Its not default behaviour, all the reports you mentioned are datawarehouse >> reports (except the Active Loan Summary Per Branch). The couple I looked at >> all had criteria including bad standing loans (doesn't mean it runs right >> though). >> >> I would probably need a specific example and a copy of the mifos database >> (john dot woodlock at gmail.com) to check out any inconsistencies. >> >> John >> >> On Fri, Dec 16, 2011 at 2:21 AM, info <[email protected]> wrote: >>> >>> Hi Team >>> >>> I compared the report output with couple of reports and found there is a >>> mismatch of Loan disbursed and principal outstanding for the following >>> reports. On detail analysis we found that loans which are in Active in-Bad >>> standing state are not considered in Balance outstanding, Loan officer >>> detail, Loan officer performance summary & Funds movement . Is this default >>> behavior? Please advise. >>> >>> Base report Compared >>> with >>> >>> Active Loan Summary Per Branch Balance Outstanding By source >>> of Fund & Balance outstanding >>> Active Loan Summary Per Branch Loan Officer Detailed >>> Active Loan Summary Per Branch Loan Officer performance >>> summary >>> Active Loan Summary Per Branch Funds Movement Report >>> >>> -- >>> Regard, >>> HT Team >>> www.hugotechnologies.com >>> Phone : +91 40-65141823 | Skype: hugo.technologies >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> 10 Tips for Better Server Consolidation >>> Server virtualization is being driven by many needs. >>> But none more important than the need to reduce IT complexity >>> while improving strategic productivity. Learn More! >>> http://www.accelacomm.com/jaw/sdnl/114/51507609/ >>> _______________________________________________ >>> Mifos-users mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>> >> >> >> >> ------------------------------------------------------------------------------ >> 10 Tips for Better Server Consolidation >> Server virtualization is being driven by many needs. >> But none more important than the need to reduce IT complexity >> while improving strategic productivity. Learn More! >> http://www.accelacomm.com/jaw/sdnl/114/51507609/ >> _______________________________________________ >> Mifos-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> > > > > -- > Thanks and Regards, > Ramesh.A.Nayak| Software Engineer @ ConfluxTechnologies | Address :#412, > 20th Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | > Email :[email protected] | website: > www.Confluxtechnologies.com | > Contact Number - Mob : +919739317276. > > > > ------------------------------------------------------------------------------ > Learn Windows Azure Live! Tuesday, Dec 13, 2011 > Microsoft is holding a special Learn Windows Azure training event for > developers. It will provide a great way to learn Windows Azure and what it > provides. You can attend the event by watching it streamed LIVE online. > Learn more at http://p.sf.net/sfu/ms-windowsazure > _______________________________________________ > Mifos-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/mifos-users > ------------------------------------------------------------------------------ Learn Windows Azure Live! Tuesday, Dec 13, 2011 Microsoft is holding a special Learn Windows Azure training event for developers. It will provide a great way to learn Windows Azure and what it provides. You can attend the event by watching it streamed LIVE online. Learn more at http://p.sf.net/sfu/ms-windowsazure _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
