Skip to Content
avatar image
Former Member

Validation on Exchange rate at Invoice level

Hi,

The exchange rate getting update in OB08 in the evening of 1st day of every month.

The issue is if User creating invoice or releasing for accounting in the morning of 1st day of the month , then system is taking exchange rate from last month.they dont want to change the setting of OB08. instead they want validation that if user raise invoice in the morning then system should give error message.

How to achieve this requirement? what is the name of user-exit where we can put the logic?

Thank you

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 15, 2016 at 01:42 PM

    Which exchange rate you were talking about ? As you should be aware, three exchange rates you can find in billing document.

    They are

    • VBRP-KURSK = Document currency for Price determination which depends on the setting of TVCPFLP-PFKUR in copy control
    • VBRK-KURRF = Document currency for FI postings. If you input manually in sale order field VBKD-KURRF, it is copied to above table / field. Otherwise, this will be determined during invoice generation. For more details see Note 36070 - Fixed foreign currency rate for Accounting document
    • KOMV-KKURS = this is for local currency at Price condition level which will be determined based on pricing date.
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Lakshmipathi,

      We are talking about the VBRK-KURRF = Document currency for FI postings exchange rate.

      sometimes what happened FI person update entry in OB08 in the evening of 1st day of the month.so we need to put validation that if the exchange rate has not been update for the current month then

      1.system should not allowed to create the invoice.2. If invoice already created then it should not allow to release it for FI posting.

      sometime invoices are created manually but usually invoices are created through batch jobs which run hourly.

      Can you please guide us where to put the validation?

      Thank you

      Regards,

      Rupali

  • Nov 18, 2016 at 07:55 AM

    Rupali,

    Validation can be written in user exit RV60AFZZ, FORM userexit_number_range. This will prevent the creation of billing document according to your logic (a new entry does not exist in OB08).

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2016 at 10:12 AM

    Have you checked the OSS note 36070 suggested by me already where solution is explained.

    Add comment
    10|10000 characters needed characters exceeded