Page 1 of 1
How to do with MassAllocation ?
Posted: Thu Jun 25, 2009 2:50 am
by Usman Qureshi
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[:)]
Posted: Thu Jun 25, 2009 3:41 am
by karthikeyanp1981
Please let us know the formula you were using for A,B,C and T
and the error/issue you were facing ...
Since if you have followed the steps stated in the GL user guide, the chances of ending in error are very minimal...
Posted: Fri Jun 26, 2009 11:16 am
by sanjutapadia
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.
Posted: Mon Jun 29, 2009 10:12 am
by oracleapps1983
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