Skip to Content
author's profile photo Former Member
Former Member

Exchange Rate at the Time of Clearing

Dear Experts,

We are facing problem with Exchange Rate at the Time of Clearing.

While partially clearing vendor Open invoices System is Calculating Clearing Document (AB) on current Exchange Rate Maintained in (OB08).

We need clearing document Exchange Rate of that maintained at the time of Invoice not at the time of clearing. Clearing is being done in foreign currency.

Regards,

Asim Raza

Add comment
10|10000 characters needed characters exceeded

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 10:35 AM

    Dear All,

    We have catered it at our own. It’s done via using a system enhancement with help of ABAPER. Its not logically right by any mean but still it fulfill our client requirements.

    Thanks

    Regards,

    Asim Raza

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2013 at 01:35 AM

    Hi Asim,

    You absolutely can enter manually exchange rate which is same as ex rate at invoice time when make payment. (The field is next to Currency field)

    About the standard system, if you don't fill exchange rate, the system will pick up the rate at the payment time, not at invoice time.

    Julie

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Julie,

      Thanks for prompt response.

      Yes we can enter manually exchange rate when make payment (The field is next to Currency field).But this not going to help our cause.

      We want it Automatic, Kindly suggest any Configuration steps for our requirements (System pick up the rate that of invoice not of payment while clearing.

      Regards,

      Asim Raza

  • author's profile photo Former Member
    Former Member
    Posted on Aug 15, 2013 at 11:48 AM

    dear asim,

    can u please share your step to step slides for clearing to sugesst solution

    Br

    sajida

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 15, 2013 at 12:13 PM

    hi Asim,

    Is it not correct to pick the exchange rate applicable at the time of clearing from OB08? You see the rate at the time of Invoice and at the time of clearing is compared and difference is calculated during clearing.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 15, 2013 at 12:33 PM

    standard procedure for clearing is to use posting date exchange rate

    it is technical possible to affect posting date (clearing date) manual with transactions F-44 F-32

    but date of clearing will be same day as an invoice date

    however

    there is a logical question why you need this funcionality

    if there are difference between invoice and payment it is excheange rate difference

    an it is exact calculation no depending on date you choose to take ex rate

    do you try to avoid exchange rate calculation and posting ?

    cheers

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi asim

      my question was intend to prove taht you have exchange rate differences on document

      if you always use invoice exchange rate you will not have any differences in local currency

      I know accountants they are afraid of that effect but it is immanent and correct

      you can turn on to calculate and post differences on partial payment

      SPRO ->Financial Accounting (New) ->Financial Accounting Global Settings (New) ->Global Parameters for Company Code->Currencies ->Indicate Currency Differences for Partial Payments

      I think this would be a solution of your question

  • Posted on Aug 15, 2013 at 01:02 PM

    Hi Asim,

    What transaction code are you using?

    You can use F-04 for wide variety for post with celaring functionalities and put exact translation date.

    In normal clearing transaction, translation date would default from the clearing date.

    Hope this helps.

    Thanks,
    S

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 16, 2013 at 12:19 PM

    You can enter invoice posting date in translation date filed to avoid forex differences.

    But this is not correct amounts have to be converted on paymnet date exchange rate and not invoice date exchange rate.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 16, 2013 at 01:34 PM

    Hi Asim, you can enter the exchange rate manually at the time of clearing. If you're using FB05 transaction for clearing you'll have the option either to enter the exchange rate or translation date ( in you're case the invoice date) whilst clearing.

    Regards,

    Sudhakar*

    Add comment
    10|10000 characters needed characters exceeded