Hi Sarat, One other quick note about the query below that you used to modify your CoA.
If you are going to move the LPF to fall under "Direct Income from Microcredit and Lending Activities" in your CoA, you will want to update the GL_CODE table in addition to the COAHIERARCHY table. I assume you want the GL code to change from 58103 to a value that reflect that it falls under 31300 now, correct? Or is that an incorrect assumption? Aliya On Jan 2, 2008 1:48 AM, Amy Bensinger (Contractor) < [EMAIL PROTECTED]> wrote: > Hi, all. An update: > > > > > > Hi Sarat. What you are doing by changing the parent reference is changing > the chart of accounts, not just where it appears in the UI. So, the question > is whether or not IIRM wants the Chart of Account to have the Loan > Protection fund be a GL code under Income from* Micro Credit & Lending > Activities *(falls into the main category of *Direct Income*) *instead* of > a GL Code under *Cost of Funds* (falls into 58000 *Loan Loss Prevention*) > as specified in the Chart of accounts. You cannot change the hierarchy > without changing the impact of how the revenue is classified. > > > > From a code perspective, this update is probably safe, but you will need > to work with IIRM to decide if the revenue is appropriately classified. > > > > > > Thanks and happy new year! > > > > --aB > > > > > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Sarat G > *Sent:* Wednesday, January 02, 2008 2:54 PM > *To:* [EMAIL PROTECTED] > *Cc:* Noel Anil; Aliya Walji; Dev Anand P.; Narendar Yalamanchilli > *Subject:* Re: Latest Mifos IIRM database shell > > > > Amy, > > > > I have updated the PARENT_COAID = 23 for LPF in *"coahierarchy" *table. > the script as follows... > > > > "update coahierarchy set Parent_coaid = 23 where coaid= 144 and > parent_coaid = 141" > > > > Thanks and Warm Regards.. > > Sarat > > On 1/2/08, *Amy Bensinger (Contractor)* < [EMAIL PROTECTED]> > wrote: > > Sarat, can you send me the exact script you used to make the changes? > Also, are you running tests to see what the db impact is (like profiling the > DB, etc)? We can also talk about this item a bit on today's call. > > > > Thanks! > > > > --aB > > > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Amy > Bensinger (Contractor) > *Sent:* Monday, December 31, 2007 5:15 PM > *To:* Noel Anil; [email protected]; Mifos functional > discussions > *Cc:* Narendar Yalamanchilli > *Subject:* Re: [Mifos-developer] Mifos Implementation At Assam: Need > HelpRegarding Chart Of Accounts. > > > > Hi, all. > > > > To clarify the question—the configuration change can be made easily. What > is unknown is the impact on the processing of the data with respect to the > Chart of accounts. Does anyone know of and hard-coded rules with respect > to the Chart of Accounts? Can IIRM/Profound safely make these changes? > > > > > > > > > ------------------------------ > > *From:* Noel Anil [mailto:[EMAIL PROTECTED] > *Sent:* Monday, December 31, 2007 1:29 PM > *To:* [email protected] > *Cc:* Amy Bensinger (Contractor); Aliya Walji; Narendar Yalamanchilli > *Subject:* Mifos Implementation At Assam: Need Help Regarding Chart Of > Accounts. > > > > Hi, > > We are a Mifos implementation team based in Hyderabad. Currently, we > are implementing Mifos at IIRM, Assam, India. We have come across an issue > while creating new products in Mifos. IIRM had some Chart of Accounts(COA) > which were configured in the database and sent to us from Grameen > Foundation. The issue is with one of the COA, Loan Protection Fund(LPF). > > > > LPF is defined under Loan Loss Provison in COA. IIRM treats LPF also as > a fee and it has to be aplicable like any other fee while creating new loan > products. Here, when we are trying to create LPF as Fees, the GL code is not > present in the GLCode's lookup in the *Defining New Fees* screen as it is > defined under Loan Loss Provision. > > > > Is this a configuration issue? Or Is there any other way to create LPF > which is defined under Loan Loss Provision, to be reflected in creating New > Loan Products. Please find the attached COA. The LPF is found at the bottom. > > > > > We are using Mifos version 1.0 for IIRM. Any responses will really be > appreciated. > > > > Thanks & Best Regards, > Noel Anil > Profound Infotech Pvt Ltd. > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Mifos-functional mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/mifos-functional > >
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
