Exchange Rate Issue ( Ditect & Indirect Quotation )

[Former Member]

Dear,

Alll Experts.

I am stuck up at one level , that is Exchange Rate issue.

User is creating shopping cart in SRM, Local Currency is USD and the goods is ordering from Canada ( CAD ).

While doing this amount is getting calculated in - ( Negative ), And it is going to wrong approval for shopping cart approval.

When I see the TCURR table I am seeing there as negative sign in exchange rate because it is maintained in Indirect Quotation.

I want to calculate the same amount in postive figure.

How this can be achieve? If I maintain the same in direct quotation it will calculate positive but final amount will be bigger which is not proper one.

Experts guidance will be helpful.

Regards,

Sharvari Joshi.

[Former Member · Accepted solution]

Please try maintaining this way and let me know what happens.

M 10/01/2010 1.02920 X 1 USD = 0.00000 X 1 CAD

M 10/01/2010 0.00000 X 1 CAD = 1.02920 X 1 USD

Local currency - USD

Document currency - CAD

Regards,

Ganesh

[Former Member · Accepted solution]

Dear,

Ganesh.

Appreciating your quick reply. Thanks.

Could you please tell me the same in OB08 way ?

Your help will be appreciated.

Regards,

Sharvari Joshi.

[Former Member · Accepted solution]

Hi,

I gave the OB08 entries, not sure if you wanted me to explain the logic. Here it is..

Maintain 'Indirect quotation' from Local currency(USD) to Transaction currency(CAD) and 'Direct quotation' from Transaction currency(CAD) to Local currency(USD).

Direct quotation is where the cost of one unit of foreign currency is given in units of local currency, whereas indirect quotation is where the cost of one unit of local currency is given in units of foreign currency.

Your local currency is USD:

- Direct exchange rate: 1CAD = 0.92819 USD

- Indirect exchange rate: 1USD = 1.08238 CAD

The following settings have been made in the standard system:

- Direct quotation: ' '

- Indirect quotation: ' / '

Direct exchange rates do not have a prefix.

Your local currency is USD. You enter a business transaction in the transaction currency CAD. Until now, you had to use direct quotation to enter the exchange rate (1CAD =0.92819 USD). If you have defined '/' as the prefix for indirect quotation, you can also enter the exchange rate with indirect quotation (1 USD = 1.08238 CAD) by entering '/1.08238' in the exchange rate field.

-

---

Direct or indirect quotation can be maintained as the standard form of quotation for a certain currency pair. You use:

- '1' for direct quotation

- '2' for indirect quotation

If a standard form of quotation has not been specified for a currency pair, the system automatically uses direct quotation.

You make the settings in the IMG: General Settings -- Currencies -- Set Standard for Direct/Indirect Quotation per Currency Pair.

-

---

Thanks

Ganesh