Spot Exchange Rate on Sales Order + Invoicing

[Former Member]

Dear SAP Gurus,

We have a scenario wherein Foreign currency sales order or subsequent invoice should be posted with the current exchange rate. System should always use the current/spot exchange rate, even if the users have entered fixed exchange rates in the sales order in the Sales Order header or Line Item.

Kindly suggest appropriate solution / customizing

Regards

Jayesh.

[Former Member]

Hi,

In the Transaction code OB08 maintain the exchange rate with the exchange rate type S which is the SPOT RATE.

And in the Copy control from Delivery to Billing in the Item maintai the PRICING EXCHANGE RATE as E which means the Rate determination based on Current date, provided if you maintained the spot rate for that particular date.

Thanks,

santosh

[Lakshmipathi]

Go to VTFL, select the item category for the combination of your delivery type and billing type where you can see a field Exchange rate. There you have the following options.

A::: Copy from sales order

B::: Price exchange rate = Accouting rate

C::: Exchange rate determination according to billing date

D::: Exchange rate determination according to pricing date

E::: Exchange rate determination according to current date

F::: Exch.rate determination accord.to date of services rendered

According to your requirement, there you maintain "E" and save.

On the other hand, you can try with any of the following user exits.

a) EXIT_SAPLV60B_001:

b) EXIT_SAPLV60B_002

thanks

G. Lakshmipathi

[Former Member]

hi

please check the exchange rate type defined in customer master , for this requirement ask the FI to create an exchange rate type which will check rate for current month.

I hope this helps

Regards

Mandar