Allocations in GL
Summary
Allocation in GLContent
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.
1