Skip to Content
0
Oct 03, 2012 at 02:44 AM

Two-level distribution rule

15 Views

Hi all,

I have setup 2 dimension: Division and Brand. For example:

I have Division 1 and Division 2 setup as profit centers for Divison and I have Brand A, Brand B and Brand C setup as profit centers for Brand.

How can i setup two-level distribution rule for expense account. For example:

I post $1000 to telephone expense account. I want distribute $600 to Division 1 an $400 to Division 2. I have setup distribution rule as follow:

Division 1 - 60%

Division 2 - 40%

And the above works. But i will need to further distribute according to Brand. For example, from the above, i have distributed $600 to Division 1 and i need to further distribute the $600 between Brand A, Brand B and Brand C. In summary i will like to achieve:

Posted $1000 to telephone expense account:

First level distribution:

Division 1 -> $600

Second level distribution:

Brand A -.> $200

Brand B -> $300

Brand C -> $100

First level distribution:

Division 2 -> $400

Second level distribution:

Brand A -.> $100

Brand B -> $200

Brand C -> $100

When i setup disctribution rule, i can only select profit centers from 1 dimension. I cannot select from 2 dimensions. How can i achieve the above two-level distribution?

Thanks all.