Skip to Content
avatar image
Former Member

Exchange rate condition type

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 06, 2008 at 11:31 PM

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

    thanks.

    Naren

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2008 at 05:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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?

  • avatar image
    Former Member
    Nov 05, 2008 at 01:15 AM

    Did it using routine for scales maintained at condition type.

    Add comment
    10|10000 characters needed characters exceeded