Hi,
I am trying to allocate some expenses (e.g. Head office common expenses) to different cost centres.
i am trying to do it thru MassAllocation but i cannot comeup with the formula.
would anybody plz help me on it?
thannking u in anticipation[:)]
How to do with MassAllocation ?
-
- Posts: 5
- Joined: Thu Jun 18, 2009 11:52 pm
- Location: Pakistan
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
-
- Posts: 6
- Joined: Tue Feb 05, 2008 10:04 am
- Location: India
Hi,
to allocate head office common expenses to different cost center follow the steps below :
1. create a journal entry for the recording head office expense
2. create a parent cost center and assign child cost center to it.
3. create a stat journal for giving percentage in which you want to assign to different cost centers.
4. Do mass allocation. formula for mass allocation is A*B/C where a is cost pool account in this case head office expense, B is usage factor and C is sum of usage factor.
A : give the cost pool account where all will be constants (C-C-C)
B : Give the parent account of cost center (C-L-C)
C: Give the parent account of cost center (C-S-C)
T : is your target account
O : is offset account same as A
Note : here 3 segment is taken.
then validate the formula and run mass allocation.
Hope it helps you.
to allocate head office common expenses to different cost center follow the steps below :
1. create a journal entry for the recording head office expense
2. create a parent cost center and assign child cost center to it.
3. create a stat journal for giving percentage in which you want to assign to different cost centers.
4. Do mass allocation. formula for mass allocation is A*B/C where a is cost pool account in this case head office expense, B is usage factor and C is sum of usage factor.
A : give the cost pool account where all will be constants (C-C-C)
B : Give the parent account of cost center (C-L-C)
C: Give the parent account of cost center (C-S-C)
T : is your target account
O : is offset account same as A
Note : here 3 segment is taken.
then validate the formula and run mass allocation.
Hope it helps you.
-
- Posts: 256
- Joined: Thu Aug 07, 2008 3:48 am
- Location: USA
Dear Members
May i know what is use of Mass Allocation. If we see in Payables there is Distribution Set. Where we can do allocation and when it is transfered to GL it will update balancing , Cost and Account segments automatically.
My doubt is When Expense journal is Posted it will update GL Balances. When you do Mass Allocation again GL Balances will be updated. Balances are getting updated twice.
Regards
Oracleapps1983
May i know what is use of Mass Allocation. If we see in Payables there is Distribution Set. Where we can do allocation and when it is transfered to GL it will update balancing , Cost and Account segments automatically.
My doubt is When Expense journal is Posted it will update GL Balances. When you do Mass Allocation again GL Balances will be updated. Balances are getting updated twice.
Regards
Oracleapps1983
Who is online
Users browsing this forum: No registered users and 3 guests