Question Re: Hierachy - Unit price - Node level in Financial Management Q&A

Hierachy - Unit price - Node level

Former Member — Sun, 03 May 2015 10:53:34 GMT

Hi Team ,

Requirement :
Responsibility Center ABC has two Level Upstream and Down stream.
The Revenue and UnitSold is at Responsibility Center at respective RC level ( Upstream and Downstream will have RC's )

Unit Price @ Upstream = Revenue @ Upstream / Volume Upstream

Unit Price @ Downstream = Revenue @ Downstream / Volume Downstream

so far so good - Issue is for calculation of Unit cost @ ABC node level .

System calculation Unit Price @ ABC = (Revenue @ Upstream + Revnue @ Downstream) /(Volume of Upstream+ Volume of Downstream)

Requirement is as below :

Unit Price @ ABC= (Revenue @ Upstream + Revnue @ Downstream) /(Volume of Upstream) - Downstream volume not to be considered in calculation .

Please let me know is it possible if yes how.

Regards,

Mandar

Re: Hierachy - Unit price - Node level

Former Member — Tue, 12 May 2015 19:40:00 GMT

Hi Mandar,

Unit Price @ ABC level is a consolidation type not a formula, therefore what you trying to accomplish will not work as you have it setup.

Regards,

Athir

Re: Hierachy - Unit price - Node level

I051505 — Mon, 18 May 2015 09:51:56 GMT

Hello,

You have to create a new revenu type item to calculate your Unitprice @ ABC requirement.

Its revenue value should be equal to Revenue @ Upstream + Revnue @ Downstream and its volumes data should be equal to Volume of Upstream.

Take care,

thierrY