Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
VKR_23
Participant
6,152

Split Valuation: Material can be valuated based on different types of procurement, it is known as Split valuation.

Split valuation helps in valuating the stocks of a material in the same valuation area (company or plant) differently.

 Some of the examples where split valuation is required are as follows:

  • Stock that is procured externally from a vendor has a different valuation price than the stock of an in-house production.
  • Stock obtained from one vendor is valuated at a different price than the stock obtained from another vendor.
  • Same material having different batch may have different valuation prices.

Introduction:

  • IF you have a material (Raw Material) and this material you procure it from multi supplier’s domestic and foreign (from different countries).Purchasing a raw material from suppliers in Spain, China and Egypt So, the value of this raw material will be different from one country and another So, this will lead to differentiate in value of stock of this material and create one valuation category here and 3 valuation type according to these 3 countries.

Another case: if you have spare part material and this material has different category (NEW-DAMAGED-Refurbished)

  • So, the material is the same material but has different values according to its category which means that the material has one valuation category and 3 valuation types (NEW-DAMAGED-Refurbished)

Example:

  • You act as spare parts Company and has an oil filter (material) & you have different categories of this filter you purchase this oil filter (new, damaged or refurbished)
  • So, you have one material has valuation category and this valuation category has valuation types in it.

VKR_23_34-1711025203035.pngSettings for Split valuation in Customizing:

VKR_23_35-1711025277399.png

1) Valuation category could be according to

  • Procurement type
  • Country of origin
  • Quality

2) Valuation type according to valuation category

3) Assign valuation category to Plant

Activate Split Valuation:

SPRO –> IMG –> Material Management –> Valuation and Account Assignment –> Split Valuation –> Activate Split Valuation

Transaction Code: OMWO

VKR_23_5-1711025026917.png

VKR_23_6-1711025026918.png

Configure Split Valuation:

SPRO –> IMG –> Material Management –> Valuation and Account Assignment –> Split Valuation –> Configure Split Valuation

Transaction Code: OMWC

VKR_23_7-1711025026923.png

Click on the Cancel button field as shown below.

VKR_23_8-1711025026925.png

The Initial Screen will appear  then click on the Global Types (Valuation Type)

VKR_23_9-1711025026926.png

Click on the Create button if you want to create a new Valuation type or if you want to use existing one by changing to our related data.

VKR_23_36-1711025477278.png

Here I am creating 3 valuation types for Spare Parts

  • New
  • Damaged
  • Refurbished

After maintaining the data click on the create button and then click on the save button as shown below.

 VKR_23_11-1711025026942.png

 

VKR_23_12-1711025026945.png

VKR_23_13-1711025026948.png

VKR_23_14-1711025026950.png

VKR_23_15-1711025026958.png

Choose the Global Categories to define Valuation Category

VKR_23_16-1711025026960.png

By clicking on the Global Categories, the initial screen will appear and Click on the Create field as shown below.

VKR_23_17-1711025026966.png

After Maintaining the required click on the Create button and then click on the save button as shown.

VKR_23_18-1711025026971.png

Place the Cursor on our Valuation Category  and click on the Types –> Categories field as shown ( It is nothing but activating the Valuation Types for the Valuation Category)

VKR_23_19-1711025026977.png

Place the cursor on the Valuation type and click on the activate button as shown.

VKR_23_20-1711025026985.png

VKR_23_21-1711025026991.png

Next click on the Valuation Categories to organizational Unit field as shown (It is nothing but activating the Plant to Valuation Category.

VKR_23_22-1711025026999.png

The initial screen will appear and place the cursor on the Plant and click on the activate button as shown.

VKR_23_23-1711025027004.png

VKR_23_24-1711025027010.png

These are the Configuration Settings for the Inventory Split valuation that to be maintained before going into the Process flow.

Now create the Material in MM01 Transaction

Assign the Valuation Category in the Accounting 1 View

Assign valuation category to material on accounting view 1& make sure from this material it should be moving average material.

VKR_23_25-1711025027016.png

Next, we can assign the valuation Type in the Material Master to assign its price in the accounting View 1 for the different Valuation Types.

VKR_23_26-1711025027021.png

Maintain the Moving Average Price 100 USD for Valuation Type (V_NEW)

VKR_23_27-1711025027027.png

Manual change the MAP to Standard Price I am maintaining the 10 USD for valuation type (V_Damaged)

VKR_23_28-1711025027033.png

Maintain the Moving price 50 USD for valuation type (V_Refurbished)

VKR_23_29-1711025027039.png

Next, Create the Purchase order with material category types New and refurbished.

VKR_23_37-1711025954876.png

PO Material created under - 2000057.

Check the Stock Overview in MMBE for the material 90001.

VKR_23_31-1711025027056.png

Next step Goods Receipt w.r.t Purchase Order in MIGO Transaction

VKR_23_32-1711025027065.png

Material document 16 posted.

Check the Stock Overview in MMBE

VKR_23_33-1711025027070.png

10 Qty of our refurbished material were damaged. So, we need to move the quantity from Refurbished to damaged.

VKR_23_38-1711026096133.png

Material document 400000023 posted.

VKR_23_39-1711026127434.png

 

 

 

Labels in this area