Exchange Rate fixed in PO but still difference in GRN

[vikas_sehra2]

Dear All,

We are using exchange rate indicator fixed in Purchase Order but still value for custom duty in GRN is calculated as per the exchange rate maintained in OB08 for the date of posting the GRN.

PO created 31.03.2015 with document date as 30.03.2015 so that exchange rate is picked for previous date and fixed indicator ticked.

Custom invoice posted with exchange rate as in PO.

GRN posting date - 31.03.2015

But while posting GRN, custom duties are calculated as per exchange rate on 31.03.2015 instead of exchange rate maintained in PO.

Custom duty value 333.40 USD is calculated as 307.75 in GRN.

Regards

Vikas Sehra

[vikas_sehra2]

Dear All,

Solution to the above issue and the logic is explained as per the OSS revert:-

If you want the goods or the delivery costs to be

valuated according to the values in the Purchase Order, then, you need

to post first the Goods Receipt and only then the invoice.

This is the standard logic and it cannot be changed:

This is based on the assumption that the invoice is a more

"uptodate"

document than the purchase order.

For example: You create a purchase order of 10 EA with a price of 5

INR/EA.

Case 1) If you receive now the 10 EA, they will be valuated with the

price set in the Purchase Order, 50 INR.

Case 2) If you post first an invoice for the 10 EA with a different

price than the one in the Purchase Order, let's say, 6 INR/EA, and

then you enter the reception, then, the system "understands" that this

price is more updated than the one in the Purchase Order and it

valuates the reception according to this new price.

In this second case the reception of 10 EA would be valuated at 60 INR.

This is the standard valuation logic and it cannot be changed.

There is not any user exit or BAdI that can be used to change this

standard logic.

Regards,

Vikas

[Prasoon]

Hi,

   The "fixed exchange rate" indicator does not work for planned delivery cost option in MIRO. The system design is well explained with the KBA: 1909734 - MIRO/MIR7: Planned delivery cost with fix exchange rate

   Also refer the note: 1387559 - Fixed exchange rate ignored when goods receipts are posted

Regards,

AKPT

[vikas_sehra2]

Hi AKPT,

Note - 1909734 provides solution for delivery cost invoice and note 1387559 provides solution for exchange rate in goods receipt for below 6.0.

We also have issue in goods receipt but we are already having 6.7 version.

Still, delivery costs are calculated as per exchange rate in OB08 instead of fixed exchange rate in the purchase order.

Screen shot also provided for purchase order history in my first comment.

Regards

Vikas

[vikas_sehra2]

Dear All,

I have also raised OSS for the issue for which I got below reply -

if you want your freight condition JCDB to be valuated as

per the fixed rate set in the purchase order, then, you need to post

the reception before than the invoice.

But I am not able to understand what and how to post reception.

Kindly suggest.

Regards

Vikas

[former_member183424]

I hope the reception does mean the goods receipt. You can write them again for more details about the reception.

[former_member183424]

Refer to the KBA 1686557 - Unexpected exchange rate difference during goods receipt

It explains the system design about the fixed exchange rate.

[vikas_sehra2]

Hi Dibyendu Patra,

Note 1686557 is useful in different scenario as it explains about unexpected difference due to rounding off which leads to posting 0.01 as exchange rate difference.

My issue is that although exchange rate is fixed in the purchase order but custom duties value in Goods Receipt are calculated as per the exchange rate maintained in OB08.

Kindly suggest.

Regards

Vikas

[former_member183424]

Are you sure that exchange rate type M is considered at the time of GR ? Check the OSS note 459945 - Exchange rate type not equal to 'M' not considered in GR

Check also KBA 1605490 - The exchange rate in the Accounting Document (BKPF-KURSF) does not correspond to EKKO-KUFI...

OSS notes 191927 - Posting logic: GR for foreign currency PO