Skip to Content
Author's profile photo Piyush Gupta

Settlement Options in Refurbishment Order !

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

Assigned tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jogeswara Rao K
      Jogeswara Rao K

      Good information. Will be useful to Refurbishment users. Thank you for sharing.

      Regards

      KJogeswaraRao

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog Post Author

      Thanks Jogeswara Sir.

      Author's profile photo Maria Terence
      Maria Terence

      Hi Piyush,

      Good document on refurbishment i have read so far. 🙂

      Regards

      Terence

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog Post Author

      Thanks Terence for appreciating !!

      Author's profile photo rakesh kushwaha
      rakesh kushwaha

      nice document..

      Clear the costing in Refurbishment order.

      thanks

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog Post Author

      Thank you Rakesh.

      Author's profile photo Kiran Ambi
      Kiran Ambi

      Good document on Settlement of Refurbishment orders.

      Thanks for Sharing.

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog Post Author

      Thanks for your kind words Kiran.

      Author's profile photo Former Member
      Former Member

      Dear Piyush,

      Good document very informative,

      REgards

      Anand

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog Post Author

      Thank you Anand for your appreciation.

      Regards,

      Piyush

      Author's profile photo vijaya M
      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?

      Author's profile photo Piyush Gupta
      Piyush Gupta
      Blog 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

      Author's profile photo vijaya M
      vijaya M

      Thanks Piyush...

      Author's profile photo Former Member
      Former Member

      excellent doc

      Author's profile photo Hakim M
      Hakim M

      Hi Piyush,

      Thanks this is excellent information.