Skip to Content
avatar image
Former Member

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

Movement M Type Doc No. Date Qty Value Currency Vendor Acc GR/IR Acc Stk Acc GR/IR Clearing Value RE-L 5105691963 2/13/2015 1 12,190.00 USD -12190 12190 -- 12,190.00 RE-L 5105694556 2/25/2015 1 305 USD -305 305 -- 305 WE 101 5000121357 2/25/2015 305 12,798.00 USD -- -12798 12798 0 RE-L 5105699338 3/26/2015 305 305 USD -305 305 -- 305 WE 101 5000130263 4/10/2015 12,190 12,190.00 USD -- -12190 12190 0 WE 101 5000130264 4/10/2015 305 305 USD -- -305 305 0 RE-L 5105601454 4/10/2015 305- 305.00- USD 305 -602.68 297.68 602.68 RE-L 5105601457 4/10/2015 1- 12,190.00- USD 12190 -1.98 12188.02 1.98 RE-L 5105601458 4/10/2015 1- 305.00- USD 305 -1.98 303.02 1.98 WE 102 5000130227 4/10/2015 305- 312.14- USD -- 312.14 -312.14 0 WE 101 5000130228 4/10/2015 305 305 USD -- -305 305 0 RE-L 5105604778 5/1/2015 305 305 USD -305 311.97 -6.97 311.97 RE-L 5105604779 5/1/2015 12,190 12,190.00 USD -12190 12468.56 -278.56 12468.56 RE-L 5105604780 5/1/2015 305 305 USD -305 311.97 -6.97 311.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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 30, 2015 at 11:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 05:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 07:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 03:30 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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