how to post actual COGS to PA

[Former Member]

Dear all,

When we create billing document, revenue and COGS(cost of goods sold) will be posted to PA. This COGS is standard cost which got from condition type VPRS, however, it is not actual cost now. After we run material ledger, actual cost is calculated, my question is how to adjust COGS according to the actual cost in the system? this means we should post a variance to COPA.

Would anyone help me ?

Rgds,

Ben

[Former Member · Accepted solution]

You have standard programs to post the values of the Cost Components, but you may have to force the transfer of the VPRS value (maybe assign a different Value Field to the Pt of Val 02).

For Cost Components, run transaction KE27 to update COPA with the Actual Cost. This will revalue your Sales and depending on the VFs assigned, will update the COGS.

If you use the same VFs for both PVs 01 and 02, it will post a Delta. Else it will post the whole new amount for the Cost Component.

Cheers.

[Former Member · Accepted solution]

Dear Ram,

Thanks for your help. It seems I did not got it, would you pls clarify more clearly? My case such as follows:

1. Create a standard cost estimation first, the cost is $100 per 1 unit, mark and release is OK.

2. Create a production order, release, GI, confirm, GR, etc, everything is fine.

3. Create a sales order, the standard cost $100 will be displayed in condition VPRS. then I do delivery and billing. after billing document is created, revenue and COGS($100) is recorded in COPA.

4. CKMLCP, after closing entry, we find the actual cost is $120 per 1 unit.

5. KE27. If system will generate a new item in COPA with COGS $20 should be perfect( this called delta posting), however, I did not find any posting after revaluation.

I have completed configuration with:

1. KE4U(Define and Assign Valuation Strategy)

2. Define Access to Actual Costing/Material Ledger

3. Assign Costing Keys to Material Types

4. Assign Value Fields

5. Define and Assign Valuation Strategy

Am I missing some settings or there are some problems?

Rgds,

Ben

[Former Member · Accepted solution]

Would anyone help me?

thanks.

Ben

[Former Member · Accepted solution]

Hi Ben,

Like I said, you'll have to force the posting of the Actual Costs to COPA.

For this, create a Costing Key for the transfer of Actual Cost using the following menu path:

SPRO --> ... --> Profitability Analysis --> Master Data --> Valuation --> Setup Valuation using Material Cost Estimate --> Define Access to Actual Costing / Material Ledger.

In this screen, you need to select the Val View "Legal" and the Type of Valuation as option 2 or 3 (the option should include transfer of Total Cost).

Leave the Time reference as Period according to line item and set the radio button "Leave line item plant as cost est plant" for the plant value.

Once done, click "Val Field allocation ... MAP" in the lefthand window and key the VF you wish to post the MAP value to.

Now assign this Costing Key to any combination of values for which you wish to transfer actual costs. Make sure the Point of Val is 02 for Actual Costs transfer.

Save and run KE27 now. The system should post the value(s) to the mentioned value field(s).

Cheers.

[Former Member · Accepted solution]

Dear Ram,

Very appreciate for your help. it is OK now.

Rgds,

Ben

[Former Member · Accepted solution]

Hi Ram,

As mention above I have done all the settings for actual coat valuation. After executing the KE27 I can see the results but itu2019s not posting any profitability document or itu2019s not updated the value field in the same profitability document. Due to this I am not able to see the results in the report (KE30).

Could you please help me regarding above.

Thanks and Reagrds

Vinay