Allocations in GL

Summary

Allocation in GL

Content

HI,

We are trying to achieve an allocation requirement using Oracle GL. For the scenario, below is COA structure:

• Company
• Account
• Department
• Intercompany
• LOB
• SITE
• Future

Now below is requirement:

GL Cost of $ 2000.00 resides in below

Company	Account	Intercompany	Department	Line Of Business	Site	Future1
3001	75000	9999	1002	100	2501	9999

STAT accounts as follows:

Company	Account	Intercompany	Department	Line Of Business	Site	Future1	Period Activity (STAT)
3001	95000	9999	1002	100	2501	9999	1.00
3001	95000	9999	1015	100	2501	9999	20.00
3001	95000	9999	1022	100	2501	9999	3.00
3001	95000	9999	1023	100	2501	9999	5.00
3001	95000	9999	1027	100	2501	9999	3.00
3001	95000	9999	1046	100	2501	9999	2.00
3001	95000	9999	1052	100	2501	9999	24.00
3001	95000	9999	1061	100	2501	9999	5.00
3001	95000	9999	1064	100	2501	9999	1.00
3001	95000	9999	1079	100	2501	9999	10.00
3001	95000	9999	1084	100	2501	9999	1.00
3001	95000	9999	1090	103	2501	9999	4.00
3001	95000	9999	2000	300	2501	9999	34.00
3001	95000	9999	8010	500	2501	9999	2.00
3001	95000	9999	8018	100	2501	9999	1.00
3001	95000	9999	8022	500	2501	9999	3.00
3001	95000	9999	8025	100	2501	9999	3.00
3001	95000	9999	8028	500	2501	9999	6.00
3001	95000	9999	8060	500	2501	9999	1.00

 

The expected journal entry is:

3001.53000.9999.8025.100.2501.9999	1,162.79
3001.53000.9999.8025.103.2501.9999	62.02
3001.53000.9999.8025.300.2501.9999	527.13
3001.75900.9999.8025.100.2501.9999	186.05
3001.75900.9999.8025.500.2501.9999	46.51
3001.85500.9999.8025.100.2501.9999	15.50
3001.75901.9999.8025.100.2501.9999		2,000.0

 

 Challenges faced:

• The client wants to pick LOB value based on the STAT accounts (which is our basis). Oracle is currently picking up the LOB values based on the cost.