on 07-18-2017 4:29 PM
Dear Experts,
We are performing result analysis on Loss Project where
Planned Revenue - 1,200,000 Planned Costs - 1,800,000 Planned Loss - 600,000and
Actual Revenue - 340,000 Actual Costs - 485,040POC = 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 ?
Appreciate your help.
Thanks
Nitin
Dear Experts,
Please update me if you have faced similar case or any possible solution to resolve this issue
Many Thanks,
Nitin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
User | Count |
---|---|
99 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.