Exchange rate according to document date

[Former Member]

Hello all,

I need to change exchange rate according to document date while creating GR. We have done few customizing changes for this. Translation date has been updated with the document date but exchange rate is still derived from posting date. My new translation date is ignored for exchange rate derivation. If Where should be a problem?

I looked into note 619330 for this issue. If someone has already implemented this note for this issue, could you please let me know whether this note will solve this issue?

Thanks,

Priya

[Former Member]

hi priya,

BUDAT – Posting Date

If the information in this field relates to an event in the purchase order, the field is filled with the posting date of the purchase order. If the information relates to a goods receipt or an invoice, the field is filled with the posting date of the corresponding document.

WKURS – Exchange Rate

For purchasing documents that were created in a currency other than the local currency, or to which documents such as invoices were posted in a different currency; The contents of this field specifies the conversion factor with which you can convert the foreign currency to the local currency.

:

We had a problem like this and found that it only happened when the Pricing Date on the Order was different from the Pricing Date on the Invoice (and the Exchange Rate had changed between these dates).

I'm assuming in your Copy control from delivery (or order) to billing for the item category has settings:

- "Pricing type = G", meaning: Copy pricing elements unchanged and redetermine taxes

- "PricingExchRate type = C", meaning: Exchange rate determination according to billing date

NOTE: The "C" in "PricingExchRate type" [field V_TVCPFAP-PFKUR], only controls the that the LOCAL currency is translated into DOCUMENT currency on the basis of the billing date.

In our case the Document Currency and Local currency are the same but the Item COST conditions were in our VENDOR's currency - and THIS conversion was causing the problem.

This exchange rate is not controlled by the "C" in field V_TVCPFAP-PFKUR.

_______________

OSS Note 130339 Suggests that you create a new data transport routine and include code to manipulate the Pricing Date:

In the Copy control from Order to Billing document (at the Item Level)...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

• Get the Pricing Date from the Sales Order

if not vbkd-prsdt is initial.

VBRP-PRSDT = VBKD-PRSDT.

endif.

see this url

http://64.233.167.104/search?q=cache:Fi13c0YH0IYJ:help.sap.com/bp_blv1500/BL_US/documentation/Scenar...Exchangerateaccordingtodocumentdate%2Bsap&hl=en&ct=clnk&cd=2&gl=in

www.sap-topjobs.com/SpecialPP/FIconfiguration.pdf

THANKS

KARTHIK

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 23, 2008 5:15 PM

[Former Member]

Hi Karthik,

Thanks for the reply. But in our case, it is not suitable. We only create the PO and then the Goods receipt. We do not have the Pricing date issue. While creating the Goods receipt, the exchange rate is derived from posting date but not from the document date. Could you please tell me whether the note I mentioned(619330) will solve this problem?

Thanks..

Priya

[Former Member]

Hi Priya,

Did you find any solution for your problem? We are facing similar situation.