Skip to Content
0
Former Member
Oct 30, 2012 at 03:57 PM

2nd GR value is lesser

74 Views

Hi Everyone,

This inquiry is regarding GR valuation. I have read from forums and SAP notes that when an invoice is posted first valuation will be based on invoice price. In case a partial GR is made system computes the GR Qty - IR Qty and valuate based on invoice price then the balance based on PO price.

In the sample below Total PO Qty Ordered is 50,000 EA at a Unit Price of .99 EA


Qty Amount Time of Entry Entry Date Unit Price ir 15,000 14,850.00 16:36:03 05.10.2012
ir 250 247.50 16:35:11 05.10.2012
ir 9,750 9,652.50 16:32:43 05.10.2012
gr 24,750 24,007.50 7:00:21 29.09.2012 0.97 ? gr 250 242.50 4:00:33 26.09.2012 0.97 ?
ir 25,000 24,750.00 16:18:13 18.09.2012 0.99 gr 25,000 24,750.00 7:01:29 17.09.2012 0.99

In this sample GR was done first so it is correct that valuation was based on PO price .99.

Then an Invoice was posted equal s GR Qty and Value. Still fine.

Then posted 2nd GR for 250 Qty, if to based on the Invoice Price shall be .99 Value at 247.50

However system calculated at .97 gives GR value at 242.50. Lower than expected.

If we were to compute Total GR - Total Inv (25250 - 25000) difference is 250.

The 25000 is valuated based on Invoice price .99

2nd GR of 250 - difference of 250 gives 0.

Therefore the 2nd GR 250 is suppose to be valuated base on PO price .99 however system calculates based on .97

The 3rd GR was also valuated at .97.

Additional info Material use price control V (MAP) It is the first PO created to the Material so initially MAP = .99

Please help me understand why .97 was used as unit price to valuate the 2nd and 3rd GR.