We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Allocations in GL

Received Response
33
Views
2
Comments
edited Sep 8, 2020 11:49AM in General Ledger & Intercompany 2 comments

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!