Skip to Content
0

Validation on Exchange rate at Invoice level

Nov 15, 2016 at 01:32 PM

126

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

G Lakshmipathi
Nov 15, 2016 at 01:42 PM
3

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.
Show 1 Share
10 |10000 characters needed characters left 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

0
Kivanc Bilgin Nov 18, 2016 at 07:55 AM
1

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).

Share
10 |10000 characters needed characters left characters exceeded
G Lakshmipathi
Nov 18, 2016 at 10:12 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded