Work in Progress configuration in product costing

Introduction:

In product costing, WIP represents the production costs of incomplete assemblies at period end.

Depending on the production process there are two types of WIP Valuations

  • Target WIP: at target valuates based on a cost estimate.
  • Actual WIP: at actual is valuated based on actual debits and credits to a manufacturing order or product cost collector.

During month end activities, to reflect company assets at period end, the system moves WIP costs temporarily to WIP balance sheet and profit and loss accounts depending on the status of the production or process order.

In this blog we are going to learn how to configure WIP calculation and posting in SAP, we will show how to define the following points:

  • Result analysis key.
  • Define cost element for WIP.
  • Result analysis version.
  • WIP Valuation methods.
  • WIP line IDs.
  • WIP assignment.
  • WIP Update.
  • WIP posting rules.

WIP Configuration : 

So now let’s check how can we configure WIP in product costing:

  • Result analysis key

Result analysis key is mandatory in the process order master for which we want to create WIP.

Result analysis key can be defaulted for each order type and plant and then added for each order master data one the order is created.

RA%20Key

RA Key

You can create you own result analysis key or use the ones delivered by SAP.

  • Define cost element for WIP

 

We need to create a cost element for WIP calculation.

This account will be used as a technical account to calculate WIP.

WIP calculation is based on the costs of category K. (More information’s will be provided in chap 6: WIP Update.

In COA :

In Controlling area and company code :

We need to create also other WIP cost elements for each line ID with cost category K. (To show WIP by line ID during the calculation).

All WIP cost elements should be created with cot element category 31 (Order/ Project results analysis)

  • Result analysis version

 

The results analysis version allows us to define different methods for WIP calculation.

Like for production variance only result analysis version 0 can be settled to COPA.

If we are using different valuation methods, we can create a result analysis version for each method.

  • Legal valuation
  • Group valuation
  • Profit Center valuation

RA%20Version

RA Version

In our case we are using legal and group valuation, so we created two different RA versions.

RA%20Versions

RA Versions

You should select: Transfer to post the WIP in FI.

Technical RA cost element.

  • WIP Valuation methods.

WIP is normally calculated for orders with the following status:

  • Partially released
  • Released

The system cancels WIP postings during period-end processing following the delivery of associated assemblies or of finished products to inventory.

The WIP is canceled also if the status of the process order is TECO (Technically closed).

Valuation%20method

Valuation method

  • WIP line IDs.

WIP%20Line%20IDs

WIP Line IDs

Line IDs will be used to group costs according to the Financial Accounting requirements.

The system calculates the work in process for the period and distributes the calculated value to the line IDs in accordance with the cost element groups assigned to the line IDs with cost category K.

  • WIP assignment.

In this step we should assign source G/L Accounts for work in process capitalization.

For each cost element used in T030 for the following entries:

  • GBB-VBR (Internal good issue)
  • GBB-VBO (Stock provided to vendor in subcontracting)
  • GBB-AUF (Good receipt for orders)
  • GBB-VNG (Scrapping/ Destruction)

NB: You can select only the valuation types for materials used in the production process.

And secondary cost element for the activities used in production

For each entry or masked entry (Interval) we should assign the related line ID.

We can choose of the cost posted is required, optional or cannot be capitalized.

We can also only capitalize/ Or not capitalize   a percentage of the cost posted on the process order/ Production order based on the business requirement.

  • WIP Update.

 

For each line ID created before we need to specify the cost category

WIP%20Update

WIP Update

K: Costs we want to include in the WIP calculation.

S: Settled costs.

N: Costs not to be included.  (Cost we don’t want to include in WIP calculation)

For category K we need to select the WIP and reserve account.

WIP Reserve account is used for negative WIP.

 

  • WIP posting rules.

Once all the basic configuration is done, we can setup the posting rules for WIP settlement

Posting%20rules

Posting rules

We should put the P&L and Balance sheet account to be used for WIP Posting.

WIPR (Work in Process with Requirement to Capitalize) and RUCR (Reserves for Unrealized Costs (Group with Req. to Cap.) RA categories should be maintained.

If you have several RA versions (For example for legal and group valuation) you should maintain them also.

Please share with us your feedback, suggestions, questions  and thoughts regarding this topic in comments.

For more information and to get updated with all new SAP S/4 Hana insights I encourage you to follow the SAP S/4HANA Finance : https://blogs.sap.com/tags/67837800100800006927/

For similar content please follow my profile.