cancel
Showing results for 
Search instead for 
Did you mean: 

Exchange rate condition type

Former Member
0 Kudos

Hi All,

I have requirement for pricing. Global Client location uses exchange rates from a local bank website and uses it to determine a rate factor applied to all base prices during billing to determine new base price. eg.,

Exchange rate : Factor

10.00 - 10.15 : 0.91

10.16 - 10.25 : 0.92

and so on.

Lets say today exchange rate is 10.10, and the base price is maintained for 100 units. New base price to be used will be:

Base price = 100 units.

Factor = 0.91

New base = 91 units

We are going to have the exchange rate (TCURR) table mapped with local bank website to load exchange rates. But how do automatically determine the factor during order processing. I am thinking of having userexit to change the scale base to exchange rate. But hoping to get few suggestions before I get into this option.

Naren

Edited by: Naren Ginagam on Sep 3, 2008 8:42 PM

Edited by: Naren Ginagam on Sep 3, 2008 8:45 PM

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Did it using routine for scales maintained at condition type.

Former Member
0 Kudos

I think you are complicating the pricing. Upload the exchange rates on a daily basis and maintain in FiGlobal settings.

In your pricing the system will determine your pricing in local currency or foreign currency and pick up the exchange rate from that which is maintained automatically. Why do yo want to have an algorithm to check for equivalent quantities and factors?

regds

Jude

Former Member
0 Kudos

Hi,

I don't need the exchange rate but I use the exchange rate to calculate a factor (called exchange rate factor). In this case, like in the example given I need to determine factor based on a table:

From to Factor

9.96 9.99 90%

10.00 10.12 93%

10.13 10.25 98%

10.26 10.55 102%

I need the factor to be returned back on the condition value back in pricing. So, I have a condition created called ZEXC and maintained all these values at scale level. But now the issue is how to change the scale base value. It is presently taking the sales order line item net price. I want it to pick scale base value from TCURR table (exchange rate table).

Technical team is unable to change the scale base value in sales order userexit (PRICING_TKOMP).

HOW CAN I CHANGE THE SCALE BASE VALUE?

Former Member
0 Kudos

I still have not got a clear solution on this. Suggestions are appreciated.

thanks.

Naren