Incorrect Delivery Cost Valuation at GR

[former_member4887]

Dear Experts,

We have an import procurement scenario where we post invoice before good receipt.There's a purchase Order with multiple Custom Conditions on it following are the IR & GR Documents posted for it's Conditions.

Purchase Order ( 2 April 2019 )

Material ABC Quantity 300 Unit Price 2 USD Net Amount 600 USD

Conditions on PO

Custom Duty 46.46% Amount 282.26 USD

Condition Invoice 1 ( 9 May 2019)

Custom Duty Quantity 60 Amount 11284.1 PKR

Condition Invoice 2 ( 16 May 2019)

Custom Duty Quantity 60 Amount 11128.4 PKR

Condition Invoice 3 ( 16 May 2019) - Reversed on same day

Custom Duty Quantity 60 Amount 403,601.31 USD Exchange Rate 141.7

Good Receipt (17 May 2019)

Custom Duty Quantity 60 Amount 134586.52 USD Exchange Rate 141.6

Please help me understand what could be reason of this incorrect Condition Amount at GR ?

[ajitkumar]

it appears so. but normally system will not consider when a document is canceled. in your case per piece value should have been derived from first 2 documents. If you are sure that the cancellation happened before GR raise a note to SAP.

[ajitkumar]

Are you sure that the 3rd customs document is chronologically reversed before the GR? Pl check time and entry and date for corresponding accounting documents to see the actual posting times.

from the values it appear that you have paid Customs duty for 180 ( 60 + 60 + 60 ) and did a GR for 60. So one third of what you paid is reflecting on the GR.

[former_member4887]

Dear Ajit,

Thank you for your support. I have checked the chronological order & entry dates of all the invoices & reversal invoice document as well. Invoice was reversed before GR as per the entry date.

Is there any chances of GR value picked from Reversed invoice ?

I have calculated the GR value based on 1/3 of all 3 invoice & it's somewhere around 134681.53. ( almost equals to the GR value)

Thanks,

Nida Anwaar

[Prasoon]

Hi,

Could you please check how the exchange rate was determined as 141.6 during 3rd invoice - was there a wrong exchange rate in OB08?

If invoice is posted before GRN, system will be taking the value from the corresponding invoice during GRN. - this is standard system behavior.

Also check the note: 1454088 - MIRO: Currency conversion of freight costs

Regards,

Prasoon

[former_member4887]

Dear Prasoon,

The exchange rate in the third invoice in entered manually by the user , Conditions invoices in our scenario usually get posted at local currency as we pay custom clearance charges to our local vendors. Third invoice was supposed to be in PKR but the user input wrong currency, exchange rate & amount by mistake. This invoice was reversed on the same day.

The actual issue is GR document as it's not taking values from the good receipt.