Exchange Rate Problem

[Former Member]

Dear Gurus,

My client has business with over seas customers where they agree to execute a deal on a fixed exchange rate. Since the exchange rate differs from the time of getting an order to raising an Invoice to the time of realization of payment, hence they agree on a fixed exchange rate.

So, I have to raise a Sales Order with that exchange rate (which is different from what is maintained at OB08). So I click on Header icon in Overview screen and maintain the neccessary rate against 'Document Currency'. When I raise a Billing Document after Delivery, the system is calculating at OB08 rate while posting to Accounts and not at the 'Document Currency' value.

I went through the forum bank and some Gurus have given Table names, but I could not follow them properly.

I request you to suggest how to make the Billing Document take the Sales Order level 'Document Currency' value ONLY for posting to Accounts, what ever the OB08 value might be.

Thanks and regards.

Venkat - Hyd

Edited by: yajee venkat on Oct 29, 2008 1:53 PM

[Former Member · Accepted solution]

Hi,

In copy control sales order--billing select your sales doc and billing doc type and then select item,here you can find one field called "pricing exchange rate type",choose option A and then try now...

Hope you will get result....

Regards,

Chandra

[Former Member]

closing since no more answers, but if still some one gives a good solution will give points.

Regards

[Former Member]

Dear Venkat,

Good Day,

for your issue please UseTransaction VTFL and Field PricingExchRate maintain as Empty.

also check Pricing type field what you have maintained,

All the best

Best Regards,

KSK

[Former Member]

Goto Header>Accounting of sale order while creating.

There ias a field 'Exch.rate-acct.' system will take this value as exchange rate while doing accountings if some value is there.

So maintain the required exchange rate manually there.

Sam

[Lakshmipathi]

Dear Venkat

Go to VTFL, select the item category for the combination of your delivery type and billing type and check for the field "PricingExchRate type". There maintain "A", so that your requirement can be met.

Incidentally, exchange rates are used for internal purpose and I dont think here where customer has come into picture. As you would agree export orders would be executed on a agreed unit price which would be in foreign currency and irrespective of exchange rate, you have to honour the export order. This is the standard rule. For information purpose, I am asking you, why you want then the exchange rate of sale order to flow in billing also which seems to be wrong.

thanks

G. Lakshmipathi

[Former Member]

hi

Venkat

In the billing document there are 3 exchange rates, please review:

VBRP-KURSK

Exchange Rate for the conversion Loc.currency <-> Doc.currency.

for Price Determination

The determination of this exchange rate depends on the setting

of TVCPFLP-PFKUR in customizing copy-control

VBRK-KURRF.

Exchange Rate for the conversion Loc.currency <-> Doc.currency.

for FI postings

If there is a manual entry in the sales order field VBKD-KURRF

(Goto -> Header -> Accounting), then it is copied into VBRK-KURRF.

Otherwise VBRK-KURRF is determined during invoice creation.

It is supposed that manual entry has higher priority.

See the note 36070.

KOMV-KKURS

Exchange Rate for the conversion Cond.currency <-> Loc.currency

at price condition level.

It is always determined according to the Pricing date.

See the notes 92613, 97487.

Regards,

Thakkar

[Former Member]

Dear Thakkar,

Just for a clarification sake, can you tell me where we maintain exchange rates so they are stored in:

1. VBRP-KURSK / TVCPFLP-PFKUR

2. VBRK-KURRF

3. KOMV-KKURS

From what you said, I could understand that to get a value stored in the field VBKD-KURRF, I have to enter a manual exchange rate in the Sales Order in

Go To - Header - Accounting - enter opposite 'Exch.rate-acct.'

Now same way, can you suggest where to enter the exchange rates to populate in the above 3 Table/Fields?

Dear Lakshmipathi ji,

I have already selected 'A' in VTFL opposite "PricingExchRate type". Based on the rate I manually maintained in the Sales Order only, system is calculating the USD and displaying in Sales Order and carrying it to the Billing Document. But my requirement as my client wants is, this USD value should be posted to Accounts, not at the OB08 value, but at the rate maintained manually at Sales Order Header level. But the problem is what ever settings are being made, system is always converting the USD value to INR value at the rate maintained at OB08 rate ONLY. Can you suggest me how achieve the following:

OB08 rate maintained: 46.69

Manually entered rate in Sales Order: 42.00

Sales Order Value: INR 4000.00 / Ex Rate 42.00 = USD 95.24

USD value taken in Billing Doc: USD 95.24

Value Posted in Accounting Doc: USD 95.24 / INR 4446.76 (95.46x46.69)

But I want it to be USD 95.24 or INR 4000.00

How can I achieve this?

Regards

Venkat - Hyd

[Former Member]

Y dont u try my suggestion.. the value enter in that field will be taken in to consideration while doing accountings irrespective of what maintained in OB08.. after saving the billing document and passing to accounting.. see the accounting document header.. u can see the exchange rate maintained in sale order picked up.

Sam

[Former Member]

Hai Sam,

Like I confirmed in my earlier reply, I have indeed implemented your suggestion and still the Accounting Document is taking the OB08 rate. If possible run this scenario and tell me under what copy controls you are able to achieve my requirement?

[Former Member]

Hi

Venkat

If I understand your problem u want the exchange rate exact in billing what you have maintain in Sales order if this is the case then you maintain yr required exchange rate in sales order --- header ---accounting --- Exch.rate-acct. the same will go to billing and accounting.

The above is VBRK-KURRF

VBRP-KURSK this is what you maintain as Doc. Currency in sales order header.

The third one I don't have clear idea but u pl explore the same.

This the answer

Hope this will help you.