GR/IR Freight Clearing Account - GR & Invoice Verification

[Former Member]

Dear Gurus,

I have made a PO for 1200 pcs unit price 69.20$. (GR based IV). (Valuation - Moving average price)

Delivery costs - Freight (FRB1) - 1200$

I have splitted the PO quantity in to 3 different Inbound deliveries

Inbound 1 - 400 pcs

Inbound 2 - 400 pcs

Inbound 3 - 400 pcs

I have made the Goods receipt for the 1st Inbound - 400 pcs.

Goods Receipt 1 - 400 pcs. The value in the GR/IR freight clearing a/c credited by 400$

Invoice Verification1 - 400 pcs. The value in the Invoice verification is 1000$.

The value in the GR/IR freight clearing a/c debited by 1000$

Goods Receipt2 - 400 pcs. The value in the GR/IR freight clearing a/c got credited by 400$

Invoice Verification2 - 400 pcs. The value in the Invoice Verification is 2000$

The value in the GR/IR freight clearing a/c got debited by 200$ and Stock in Hand debited by 1800$

Goods Receipt3 - 400 pcs. The value in the GR/IR freight clearing a/c got credited by 200$

Invoice Verification3 - 400 pcs. The value in the Invoice Verification is 1500$

The value in the GR/IR freight clearing a/c got debited by 133.33$ and Stock in Hand debited by 1366.67$

I don't understand how the logic works for seggreating the amount to GR/IR freight clearing account and GR/IR account.

For the first 2 GR and IV I could understand that there is a balance in the PO condition but for the Invoice verification 3. The value debited to GR/IR freight account is 133.33$. Can anyone help me how the calculation is taking place and how the system has arrived to figure 133.33$ in the Invoice verification for GR/IR freight clearing a/c

Strangely when I have cancelled the Invoice Verification document 3.

The value Credited to GR/IR freight clearing account is 333.33$ instead of 133.33$

Can somebody help me to figure out the calucation for IR after the GR for planned delivery costs.

If any SAP notes or help files can be provided then it would be really helpful.

Regards

Fazal.

[Former Member]

Refer this note 311496 & 460244, 129066

Symptom
Delivery costs were planned for a purchase order item.
A goods-receipt-based invoice verification is set.
Several goods receipts are posted. For invoice entry, both in conventional invoice verification (transaction MR01/MRHR) and in logistics invoice verification (transaction MR1M/MIRO), the delivery costs for each purchase order item are displayed in total.
  This is the same as when, for example, only one of several GR documents/delivery notes is selected.
Example of a purchase order history:
Cat. Doc. no.    Itm    MvT Pstg.dt.            Qty.in BUoM       Value in local curr
GR   5200002605 0001 101 June 16, 2000      5  PC         50,00 DEM
GR   5200002606 0001 101 June 16, 2000      5  PC         50,00 DEM
Sum of goods receipts                      10  PC        100,00 DEM
DCGR 5200002605 0001     June 16, 2000       5  PC           3,33 DEM
DCGR 5200002605 0001     June 16, 2000       5  PC           5.00 DEM
DCGR 5200002606 0001     June 16, 2000       5  PC           3,33 DEM
DCGR 5200002606 0001     June 16, 2000       5  PC           5.00 DEM
Total delivery cost GR                                                 16,66 DEM
If you only select the first GR document in the selection, you get
the following default values for the delivery costs:
Amount    Quantity  BUoM Itm  Decription              Vendor
6,67         10      PC  10    Freight value        VEND01
10,00        10      PC  10    Freight/quantity     VEND01
(and not, as sometimes expected: -  3,33 DEM    5 PC
                                    -  5,00 DEM    5 PC)
Other terms
WEBRE, delivery costs, planned delivery costs, goods-receipt-based invoice verification, invoice verification
Reason and Prerequisites
A function such as the goods-receipt-based invoice verification is not available for delivery costs.
Solution
This is not an error; this is a consulting note.

[Former Member]

Hi,

Thanks for your reply.

Basically for GR value - Delivery costs. The system calculates on the formula GR value - IR value and the difference value is posted as the next GR value for the delivery costs. but how is the calculation carried out for Invoice verification.

Can you please suggest.

Regards

Fazal.

[Former Member]

Go through the above note throughly .That note only For invoice . system will not populate partial Delivery cost based on GR .It will populate the Whole value for that PO.This is std behaviour.