Skip to site navigation (Press enter)

[Mifos-functional] CoA customization question

Jeff Brewster Fri, 18 Apr 2008 10:41:40 -0700

I have a question based on the behavior Chandi and I encounter with the
Chart of Accounts customization.  It appears that the default values for
GL account codes still get loaded in the database whether or not they
are listed in the custom configuration file.  Is the custom file meant
to update the default settings or modify and supplement the default CoA
settings?


For example, in the attached modifications, the 11101 and 11102 values
from the default configuration
(http://fisheye4.cenqua.com/browse/~raw,r=HEAD/mifos/trunk/mifos/src/org
/mifos/config/resources/mifosChartOfAccounts.xml) have been removed.
However, when a clean db build is created as Chandi notes below, the
default properties are already loaded in the DB.  When the custom file
is used, it appears a merge of the two files takes place to result as
shown in the file coaList.html.  So for the 11000 section:

Default config:
- <GLAssetsAccount code="10000" name="ASSETS">
- <GLAccount code="11000" name="Cash and bank balances">
- <GLAccount code="11100" name="Petty Cash Accounts">
  <GLAccount code="11101" name="Cash 1" /> 
  <GLAccount code="11102" name="Cash 2" />

Custom config:
- <ChartOfAccounts>
- <GLAssetsAccount code="10000" name="ASSETS">
- <GLAccount code="11000" name="Cash and bank balances">
- <GLAccount code="11100" name="Petty Cash Accounts">
  <GLAccount code="11103" name="cash in hand" /> 
  <GLAccount code="11104" name="cash not in hand" />

Database:
GLCODE_ID GLCODE_VALUE COA_ID COA_Name GLCODE_ID
1 10000 1 ASSETS 1 ASSET 
2 11000 2 Cash and bank balances 2  
3 11100 3 Petty Cash Accounts 3  
4 11101 4 Cash 1 4  
5 11102 5 Cash 2 5  
58 11103 58 cash in hand 58  
59 11104 59 cash not in hand 59

Or maybe there is an operational step that we are not following
properly?

Thanks,
Jeff



-----Original Message-----
From: Chandi Datta [mailto:[EMAIL PROTECTED] 
Sent: Friday, April 18, 2008 12:07 AM
To: Jeff Brewster
Subject: steps for coa



Hi Jeff,
        Please find below the details step I did:

1. Clean the mifos db..(command : ant build_db) [note:I found all GL
code already there in the db after this command also] 2. Created two
custom XML file..
and place it in the application server class path.

OR:
Created one folder and place both custom xml file there.
Add that path to the catalina.properties file under TOMCAT conf folder.
Following I added:

shared.loader=${catalina.home}/shared/classes,${catalina.home}/shared/li
b/*.jar,C:/ant/mifosconfig

Here "mifosconfig" folder I created to place custom xml file.
3. Deploy the new war file.
4. Restart the server.


(See attached file: mifosChartOfAccounts.custom.xml)(See attached file:
mifosBeanConfig.custom.xml)
Thanks and regards,
Chandi

mifosChartOfAccounts.custom.xml
Description: mifosChartOfAccounts.custom.xml

mifosBeanConfig.custom.xml
Description: mifosBeanConfig.custom.xml

Title: Query SELECT * FROM GL_CODE G,COA M WHERE G.GLCODE_ID=M.GLCODE_ID, Fri Apr 18 10:12:05 2008

Query SELECT * FROM GL_CODE G,COA M WHERE G.GLCODE_ID=M.GLCODE_ID, Fri Apr 18 10:12:05 2008

GLCODE_ID	GLCODE_VALUE	COA_ID	COA_Name	GLCODE_ID	CATEGORY_TYPE
1	10000	1	ASSETS	1	ASSET
2	11000	2	Cash and bank balances	2
3	11100	3	Petty Cash Accounts	3
4	11101	4	Cash 1	4
5	11102	5	Cash 2	5
58	11103	58	cash in hand	58
59	11104	59	cash not in hand	59
6	11200	6	Bank Balances	6
7	11201	7	Indian bank	7
8	11202	8	International bank	8
60	11203	60	others bank	60
9	13000	9	Loan Portfolio	9
10	13100	10	Loans and Advances	10
11	13101	11	Loans to clients	11
64	13104	64	Loans to INTERNAL CLIENTS	64
65	13105	65	Loans to big clients	65
12	13200	12	Loan Loss Provisions	12
13	13201	13	Write-offs	13
66	13209	66	test Write-offs	66
32	1501	32	IGLoan	32
33	1502	33	ManagedICICI-IGLoan	33
34	1503	34	SPLoan	34
35	1504	35	ManagedICICI-SPLoan	35
36	1505	36	ManagedICICI-IGLoan	36
37	1506	37	SPLoan	37
38	1507	38	ManagedICICI-SPLoan	38
39	1508	39	WFLoan	39
40	1509	40	Managed WFLoan	40
61	1510	61	Emergency Loans	61
62	1511	62	Special Loans	62
63	1512	63	Micro Enterprises Loans	63
14	20000	14	LIABILITIES	14	LIABILITY
15	22000	15	Interest Payable	15
16	22100	16	Interest payable on clients savings	16
17	22101	17	Interest on mandatory savings	17
26	23000	26	Clients Deposits	26
27	23100	27	Clients Deposits	27
28	23101	28	Savings accounts	28
67	23104	67	Savings accounts	67
68	23105	68	New Savings accounts for test	68
29	24000	29	Mandatory Savings	29
30	24100	30	Mandatory Savings	30
31	24101	31	Mandatory Savings Accounts	31
69	24200	69	Mandatory Savings	69
70	24203	70	Mandatory Savings Accounts	70
71	24204	71	test Mandatory Savings Accounts	71
18	30000	18	INCOME	18	INCOME
19	31000	19	Direct Income	19
20	31100	20	Interest income from loans	20
21	31101	21	Interest on loans	21
22	31102	22	Penalty	22
72	31106	72	Interest on loans	72
73	31107	73	Penalty	73
23	31300	23	Income from micro credit & lending activities	23
24	31301	24	Fees	24
74	31302	74	News Fees	74
25	31401	25	Income from 999 Account	25
53	40000	53	EXPENDITURE	53	EXPENDITURE
54	41000	54	Direct Expenditure	54
55	41100	55	Cost of Funds	55
56	41101	56	Interest on clients voluntary savings	56
57	41102	57	Interest on clients mandatory savings	57
75	41200	75	Cost of Funds	75
76	41205	76	Interest on clients voluntary savings	76
77	41206	77	Interest on clients mandatory savings	77
41	4601	41	Emergency Fund	41
42	4602	42	Margin Money-1	42
43	4603	43	Margin Money-2	43
44	4606	44	Village Development Fund	44
45	5001	45	Interest	45
46	5201	46	Processing Fees	46
47	5202	47	Annual Subscription Fee	47
48	5203	48	Emergency Loan Documentation Fee	48
49	5204	49	Sale of Publication	49
50	5205	50	Fines & Penalties	50
51	6201	51	Miscelleneous Income	51

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone

_______________________________________________
Mifos-functional mailing list
Mifos-functional@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-functional