on 10-23-2015 4:39 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looking at your document numbers does not convince my that your shown values have been posted in this sequence.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.