It is a common understanding that Settlement of a Refurbishment Order happens on Material. This is true, but not always.

It depends upon whether the price control indicator for the Batch material in material master is Standard (S) or Moving average price (V).

Batch material refers to the material with Valuation types C1/C2/C3. So if the price control indicator of Batch material is:

  1. V: Settlement happens on the Material Master.
  2. S: Settlement doesn’t happen on Material Master, but on price difference account.

Scenario 1: Consider material 795, with Batch material’s price indicator = V

/wp-content/uploads/2015/06/2_731609.png

/wp-content/uploads/2015/06/3_731610.png

/wp-content/uploads/2015/06/4_731611.png

Have 1 unit each of batch C1, C2, C3. Therefore the material valuation = (200+80+10)/3 = 96.67

/wp-content/uploads/2015/06/5_731612.png

Created a Refurbishment Order for this material (for C3) using IW81. Done GI. Done GR using IW8W.

After GR, we have 1 unit of C1 and 2 of C2.

Therefore, Material valuation = (1*200 + 2*80)/3 = 360/3 = 120

/wp-content/uploads/2015/06/6_731613.png

Cost incurred in WO: 10 for GI of 1 unit of C3 and -80 for GR of 1 unit of C2.

So the balance amount on WO is -70.

/wp-content/uploads/2015/06/7_731614.png

Settlement: Since batch material price indicator is V, therefore settlement of balance amount happens on material./wp-content/uploads/2015/06/8_731615.png

/wp-content/uploads/2015/06/9_731616.png

So the settlement happens on GL Spare Parts, against material master.

Since the settlement happens on material, therefore material valuation also changes as:

1*200 + 2*80 = 360

360-70 (for settlement on material) = 290 /3 = 96.67

/wp-content/uploads/2015/06/10_731617.png

Scenario 2: Consider material 796, with Batch material’s price indicator = S

/wp-content/uploads/2015/06/11_731618.png

/wp-content/uploads/2015/06/12_731619.png

/wp-content/uploads/2015/06/13_731620.png

Have 1 unit each of batch C1, C2, C3. Therefore the material valuation = (200+80+10)/3 = 96.67

Followed same steps as above. Create Refurbishment Order, GI, GR. Skipped the screenshots.

Valuation of material after GR, but before settlement.

Therefore, Material valuation = (1*200 + 2*80)/3 = 360/3 = 120

/wp-content/uploads/2015/06/6_731613.png

Settlement: Since batch material price indicator is S, therefore settlement doesn’t happen on material, rather on Price diff account.



/wp-content/uploads/2015/06/14_731621.png

So the settlement happens on GL Price Diff account and not on material master.

Since the settlement doesn’t happen on material, therefore no change in material valuation:

1*200 + 2*80 = 360

360 – 0 (for settlement) = 360 /3 = 120

/wp-content/uploads/2015/06/15_731622.png

To report this post you need to login first.

14 Comments

You must be Logged on to comment or reply to a post.

  1. vijaya M

    Dear Piyush,

    Thank you for the good information.

    Could you please explain how actually the settlement rule gets defined here in this case?

    Will it be defined in the allocation to Material alone?

    (0) 
    1. Piyush Gupta Post author

      Hello Vijaya,

      Even I had the same doubt when I exploring this concept.

      In both the cases, the S Rule is defined for the material only.

      The system tries to settle the cost to material. But if the Batch material is at standard pricing, then the settlement is automatically routed to the price diff account, in place of material valuation.

      So invariably, the S Rule object is material in both the cases.

      Thanks,

      Piyush

      (0) 

Leave a Reply