GR valuation on PO

[massimiliano_riva]

Hi guys,

please see the image in attachment and give me your response: how the GR value in evidence has been calculated?In according to OSS Note 518368 point 4 and 5 : '...If an invoice is already posted, the system use the price of invoice but if a partial invoice is received the partial qty related to invoice is valuated with invoice price, the rest is valuated with PO price.'..but in this case a first GR has done, then two invoices for a qty >PO qty and then another GR....I have thought that the valuation of this GR should have been in according with the average price of the two previous invoices with the product of of this GR qty that is:

price invoice 1: 7156,8/0,9= 7952,8 Eur

price invoice 2: 3578,4/0,3 = 11928 Eur

the average is (7952,8+11928)/2= 9940 Eur but 9440*0,6 = 5664 Eur and not 5566,4 Eur....

Note that before that GR those two invoices have posted a qty of 1,2 > PO qty...

Thanks in advance

BR

Massimiliano

[former_member183424 · Accepted solution]

You have posted only the amount in LC for all these activities. Look into the GR/IR clearance account , it can clear your doubt.

Check your accounting entry of first invoice (.9 qty with amount 7156.8), it should be like below:

Vendor account 7156.8 Cr

GR/IR account 8,349.60 Dr.

G/L account (AAC) 1,192.80 Cr.

The logic of 8349.60 is " 3 quantity will be valuated with GR price (.3 X 11928 = 3578.40) and .6 quantity will be valuated invoice price (.6 X {7156.8/.9 = 7952} = 4771.20). then 3578.40+4771.20 = 8349.60 ".

Then next GR was valuated with price (8349.60/.9 = 9277.33).

[JL23]

See if this wiki is of any help for your case: http://wiki.scn.sap.com/wiki/display/ERPSCM/Report+MBEXPLAINWRX

It explains a new report that allows to recalculate the value of a material document.

see also the referenced OSS notes