Skip to Content
avatar image
Former Member

Result Analysis : Calculated loss is replaced by Planned loss

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 ?

Appreciate your help.

Thanks

Nitin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 20, 2017 at 09:37 AM

    Dear Experts,

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

    Many Thanks,

    Nitin

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 18, 2017 at 07:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded