0

Result Analysis : Calculated loss is replaced by Planned loss

Jul 18, 2017 at 03:29 PM

328

Former Member

Dear Experts,

We are performing result analysis on Loss Project where

Planned Revenue - 1,200,000 Planned Costs - 1,800,000 Planned Loss - 600,000

and

Actual Revenue - 340,000 Actual Costs - 485,040

POC = Actual Cost / Plan Costs = 26.95

Revenue Affecting Net Income = POC * Planned Revenue = 323,360

Calculated Loss = Revenue Affecting Net Income - Actual Cost = 161,680

System Calculates Planned Loss of 600,000 accordingly as in screen shot but

But Calculated Loss is also 600,000 as shown in screenshot. whereas it should be 161,680 as calculated above.

Is there any setting , by which the Calculated Profit is getting replaced by Plan Loss ?

Thanks

Nitin

Former Member Jul 20, 2017 at 09:37 AM
0

Dear Experts,

Please update me if you have faced similar case or any possible solution to resolve this issue

Many Thanks,

Nitin

Share
Former Member Jul 18, 2017 at 07:31 PM
0

Hi Nitin,

This is the formula used to calculate realized loss and reserve

Planned Loss = Planned Revenue of Valuation - Planned Cost of Valuation

Realized Loss = POC * Planned Loss

Reserve for Imminent Loss = Planned Loss - Realized Loss

check your OKG8 configuration for account determination for RA category

POCL
POCR

Based on project plan revenue and plan cost ,imminent loss reverse is created for 600,000.now actuals are booked, so loss should be realized.

check your GL postings initial loss and reverse postings, both these should net to your realized loss.

Thanks,

Rau

Show 2 Share
Former Member

Hi Rau,

GL Postings are correct for Initial loss of 600,000 and Realized loss is also netting off

But when I am running the result analysis in KKA2 , the sreen shows Calculated Loss of 600,000 as equivalent to Planned Loss, by right it should be Revenue Affecting Net Income - Actual Cost = 161,680

Why the Calculated Loss still shows 600,000 ?

Former Member

Hi Nitin

this is same for me also.i think this is standard.

Thanks,

Rau

n65t4.png (24.2 kB)