Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question