Re: [Mifos-users] Master table for CLient Activties

2010-09-27 Thread Ryan Whitney
Jofel, Welcome to the community! By client activities, I believe you mean Business Activities? Either way, for most items like that they link to the lookup tables (See the Mifos database to see more), the primary one being the lookup_value tables. You can do joins to get the activities properl

[Mifos-users] Master table for CLient Activties

2010-09-27 Thread Jofel Gandeza
Hi guys! What table can I find the master list of Client's activities? Or the tables linking to customer_details table since it just contain CODES for the customer details? Any help from you guys is highly appreciated! Thank you. Jofel --

Re: [Mifos-users] [Mifos-developer] FW: Managing installment amounts when migrating fromExcel to MIFOS

2010-09-27 Thread Keith Woodlock
Kay, There are times when schedules are 'regenerated' but only future schedules e.g. a new holiday or moratorium is added I am not too sure what happens in the 'redo loan' case. if this is just a case where you want to represent old data from another system where all the schedules exist in the

Re: [Mifos-users] FW: [Mifos-developer] Managing installment amounts when migrating fromExcel to MIFOS

2010-09-27 Thread Kay Chau
Thanks Nayan, I've decided to cc the dev list as this deals with the code. Keith, and those who have looked at our code for schedules, is there anything we do to regenerate schedules? I would be careful though Nayan as some unexpected behavior might occur. For example, if you tried to

Re: [Mifos-users] Bulk loan creation v manual loan creation difference noted

2010-09-27 Thread Ryan Whitney
Gayl, Ok, that was a little difficult to follow but I think I got it. Essentially, you were getting different behavior between the individual loan creation process and bulk loan creation process. I would tend to think its a "Bug", as I believe both of those are distinct workflows in Mifos. At so

Re: [Mifos-users] GL report issue

2010-09-27 Thread Jeff Brewster
Gayl, Try this query against your database to see if it returns results. This will tell you if there is a problem specific to the BIRT report or whether there is data issue. Note the office_id below is "2", but in your query you need to match the office id for " Fantsuam Foundation Head Office":

[Mifos-users] Bulk loan creation v manual loan creation difference noted

2010-09-27 Thread Gayl Kennedy
Hi, not sure if this is a bug or by design but thought it worth sharing as a warning at least. I had to recreate some existing loans in a hurry as it was almost their meeting date. the clients are half way through their loan cycle so I created a 3 month remaining loan. We have LSIM turned on. I d

[Mifos-users] GL report issue

2010-09-27 Thread Gayl Kennedy
The initial issue logged re the report 4 weeks ago was that we could not select the branch name from the menu. This is now working but no results are being returned when the report is run. See attached example to see what we are getting. We are running v1.6 (clean install) Thanks Gayl GL Report

Re: [Mifos-users] Branch progress report and GL report problems

2010-09-27 Thread Gayl Kennedy
Thank you so much Jeff, we have loan data! I have validated it for the "test branch" data and all appears to be in order. On the live branch data it is showing a centre in arrears but I think it is just that I changed their meeting date but that won't take effect till after the next meeting date.