Hi
Objective is to allocate operational indirect cost like facilities cost (rent) to the different Line of Business.
We have around 30 chart of account codes relating to Indirect Cost of Operations. As the basis of allocation for all these codes will be same, I tried to achieve this by doing the following
- I grouped these codes into a new Dimension for Department called COGS Indirect.
- In Source Tab, I added COGS Indirect so that I could avoid adding 30 line items for each of these account codes
- In Destination Tab, I added COGS Indirect as the Department and the LOBs with the different percentage, but here it is mandatory to provide the account code. This will mean that for Destination Tab, I will have to enter all the 30 accounting codes one by one.
So my question is
Question 1 Is there a simple method for allocating the cost in these codes?
Question 2 If not, do I have to enter 30 account codes in Source Tab and 30 account codes in Destination Tab to achieve my objective

Report
All responses (
Answers (