Hi Vishwas. I appreciate your input. As you observed, the system I'm building is to aggregated several LMS' in order to present a consolidated view of all loans. I'm still considering building a simplified data warehouse. I was just seeking reasons to choose one option over the other.
Thanks, Vinayak On Fri, Apr 17, 2020 at 5:41 AM Vishwas Babu A J <vishwasbab...@gmail.com> wrote: > Vinayak, > > Can you please elaborate on the business use case you are trying to > support ? > > While the approach you describe is certainly feasible, you would likely > run into a number of issues with reconciliation depending on how the other > loan management systems are used. > > Based on the kind of financial institutions whose data is tracked in the > other LMS and the process they follow you might run into issues ranging > from exotic products whose calculations you might not be able to match a > 100% in Mifos to cascading effects around editing/ adding backdated > transactions causing mismatches around appropriation of payments across > different systems. IMO, if all you are trying to do is to get a > consolidated view of loan portfolios across different systems and running > an accounting process on top of them, skipping the need to reprocesses all > transactions again in what is effectively a “Data warehouse” should > simplify the process. > > Regards, > Vishwas > > > > On Apr 16, 2020, at 4:01 PM, Vinayak Javaly <vina...@urgent.vc> wrote: > > Hello all. I hope this email finds you all well. > > I'm looking for general advice. > > I'm building a new system that will aggregate loan information from > several different Loan Management Systems. Some of these systems may be > from other LMS vendors (e.g. Mambu, LendFoundry). I'm planning to use > Fineract as the core LMS in my new system. Here's my planned workflow: > > 1. Each LMS will periodically send loan product, loan, repayment, etc. > info in a standardized format > 2. Our system will receive each LMS' data and input it into Fineract > 3. We're planning on performing the loan accounting for these loans in > Fineract, AND have a periodic reconciliation process with the source LMS' > > My questions: > > 1. Is this a good idea? Does this seem feasible? > 2. Do you see any major or minor issues with this plan? > > Thank you in advance. > > Stay safe. > > Vinayak > > >