cancel
Showing results for 
Search instead for 
Did you mean: 

GR/IR Price Difference in a PO, want to know how the amount of 312.14 came during GR Reversal

Former Member
0 Kudos

Hi Experts,

Have an issue in the Non Inventory purchase order, where i am facing issue with respect to the difference in GRIR amount while reversal in GR and IR doucment.

Shown below are the Purchase order history in sequence along with accounting entries.

To give brief about the PO, its a Non inventory PO

Qty - 12,800 ea

Net Price - 1 USD / Ea

MovementM TypeDoc No.DateQtyValueCurrencyVendor AccGR/IR AccStk AccGR/IR Clearing Value
RE-L51056919632/13/2015112,190.00USD-1219012190--12,190.00
RE-L51056945562/25/20151305USD-305305--305
WE10150001213572/25/201530512,798.00USD---12798127980
RE-L51056993383/26/2015305305USD-305305--305
WE10150001302634/10/201512,19012,190.00USD---12190121900
WE10150001302644/10/2015305305USD---3053050
RE-L51056014544/10/2015305-305.00-USD305-602.68297.68602.68
RE-L51056014574/10/20151-12,190.00-USD12190-1.9812188.021.98
RE-L51056014584/10/20151-305.00-USD305-1.98303.021.98
WE10250001302274/10/2015305-312.14-USD--312.14-312.140
WE10150001302284/10/2015305305USD---3053050
RE-L51056047785/1/2015305305USD-305311.97-6.97311.97
RE-L51056047795/1/201512,19012,190.00USD-1219012468.56-278.5612468.56
RE-L51056047805/1/2015305305USD-305311.97-6.97311.97

In this case the end user has followed incorrect process of doing the invoicing first with such a amount, however i need to find out why the system is calculating the incorrect Value for GRIR while reversal of Invoice and GR documents.

I have all the possible ways of calculating the values taking total invoice value and GR value etc but still cant understand the reason why 312.14 is appeared during GR reversal (Document No: 5000130227). Also tried below mention logic in calculating the value but still unsuccesful.

Require your help on urgent basis. Thanks in Advance.

Regards,

Suchit Kurry

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI All,

Got the answer for the value 312.13

For the GR
Document 5000130227 (Reversal), the GR Value are calculated as per the standard
calculation shared by SAP as shown below

GR Amount = Quantity in
the cancellation x (Clearing Value of the Invoices - Goods Receipt Value) /
(Invoiced Quantity - Goods Receipt Quantity).

Quantity in the
cancellation = 305

Clearing Value of the
Invoices (GRIR Clearing Value) = 12190+305+305-602.68-1.98-1.98 = 12193.36

Goods Receipt value =
12798+12190+305 = 25293

Invoiced Quantity =
1+1+305-305-1-1 = 0

Goods Receipt Quantity =
12190+305+305 = 12800

If we put the above
values in the Formula

GR Amount = 305 x (12193.36 - 25293) / (0 -
12800) = USD 312.13

Thanks all for your inputs

Answers (3)

Answers (3)

JL23
Active Contributor
0 Kudos

Looking at your document numbers does not convince my that your shown values have been  posted in this sequence.

Former Member
0 Kudos

HI Jurgen

shown below are the screen shot of sequence

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

What is your PO currency and what is your company code currency?

May be exchange rate difference adding extra value in local currency(company code currency) in reversal of goods receipt document with 102 movement type against the material document with 101 movement type.

Regards,

Biju K

Former Member
0 Kudos

Hi,

Kindly check your invoice total amount and Quantity is divided then it should result to actual material price.

And if doesn't match then its standard SAP behavior that GR amount will fluctuate.

Below example for your reference.

Exchange rate is 1 USD

Invoice amount 2375.23 USD divided by 2374.460 = 1.000324284258316

Now 60 EA multiplied by 1.000324284258316 = 60.01945705549893 USD

Which is rounded to 2 decimal and it will result to 60.02 USD, but user was expecting 60 USD

thanks and Regards

Irfan A B

Former Member
0 Kudos

Good day,

Could you provide more details?

Particularly around the type of none-inventory line item, account assignment category and so on. If the non-inventory line has related master data check for pricing changes. Also did you perform a goods receipt against purchase order with movement type 102 or did you trigger the reversal by cancellation-material document. I suspect the issue could have been avoided by using the material document -cancellation.