cancel
Showing results for 
Search instead for 
Did you mean: 

Foreign Exchange

Former Member
0 Kudos

Dear Experts

We have issue  we have maintain the exchange rate in OB08 for USD for the current date at the current exchange rate , even we have maintain the GL s in the OBA1 KDF, KDB  transaction keys , but still system is not picking the exchange rate difference while receiving the incoming payment from customers

we have posted the  sales invoice  against the USD  last month but this month we need to get the payment from customer but why stem is not picking the exchange rate difference Profit or loss

even we have maintain the average M in the OBA7 Document Type

please help us

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Can you please check OBY6 for company ocde and check whether you have setting check box ticke "

Indicator: No ex.rate difference when clearing in local crcy" and also check vaiance "Max. exchange rate deviation"

Many Thanks

Former Member
0 Kudos

Hi Preeti,

Please refer the screen shot and correct us where we are missing

Former Member
0 Kudos

Hi Preeti,

Please refer the screen shot  please guide us

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

You have selected the "No forex rate diff.when clearing in LC" check box for the co.code in OBY6, due to this it is not generated exchange diff.posting. If you uncheck it, then it will generate.

Regards,

Mukthar

Former Member
0 Kudos

You should not tick on "No forex rate diff. when clearing in LC".

Go to this field and press F1 the help has good example as well to understand.

Best Regards,

Chirag Panchal

Former Member
0 Kudos

Hi Mukthar

we have unchecked now and did testing but still system not giving line item of exchange difference

Gustavo_Vazquez
Active Contributor
0 Kudos

Hi Inayat,

Could you check: FBZP -> Paying Company codes -> select your company code -> "No Exchange rate differences" ?

Kind regards

Former Member
0 Kudos

I can see that You have ticked " No exchnage diff on Clearning" i believe that is the reason .

So please undo this tick in you Development system do the testing I am sure after untick this will Generate the Clearning different .

But this will generate the Difference on clearing of any open item like F-03 .

Former Member
0 Kudos

Hi Preeti,

Just now we check  by un check the " No exchange diff on Clearing" and we have tested still its not showing any result

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

As per your screen shots of invoice & payment documents, you have used the exchange rate 50 for both documents. So there is no exchange diff.araised while clearing. So use different exchange rate for the payment document.

Regards,

Mukthar

Former Member
0 Kudos

Hi Mukthar,

so please guide us how to post now i mean

invoice we have maintain exchange rate is 50 while receiving the payment i will change the posting  date then system should calculate the difference

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

First post invoice with exchange rate 50. After that you make the payment with 51 on different date with maintain exchange rate settings in OB08 or manually input the exchange rate in F-53 as shown in the screen shot.

Regards,

Mukthar

Former Member
0 Kudos

Hi Mukthar

how you have said we tried manually entering the exchange rate , now why system is not picking automatically ??

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

It will pick automatically, if we have defined it in OB08.

Answers (5)

Answers (5)

former_member626853
Participant
0 Kudos

Hi Inayat,

Document no. 2300000031 amount $ 600 exchange rate INR 50.

Payment document image share earlier $ 500.00 exchange rate INR 50.

I do not see any difference in exchange rate. Both documents have same exchange rate i.e. INR 50. 

There is no realise exchange gain\loss between these transactions to post an entry.

Regards,

Deepak

aman_goel
Active Participant
0 Kudos

Hi Inayat,

Please check the GL account master data the check for 'Only Balances in local crcy' is activated.

Go to T code FS00

Check in tab Control data

Thanks, Aman

former_member626853
Participant
0 Kudos

Hi Inayat,

Your issue is quite surprising. Please share FI document image for sales invoice with exchange rate tab.

Regards,

Deepak

Former Member
0 Kudos

Dear Dalvi,

Please refer the screen shot of sales invoice

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

1. First check the exchange rates in both cases?

2. You have to maintain the gain/loss accounts in OB09 for the customer recon.account as shown in the below screen shot.

Regards,

Mukthar

Former Member
0 Kudos

Hi Mukthar,

Thanks for your reply

we have  maintain the Reco account in Exchange rate realized Field please  help us 

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

Keep the currency & currency type fields as blank and do posting after done configuration.

Regards,

Mukthar

Former Member
0 Kudos

Dear Mukthar,

we tried as you mention but still same problem , system is not showing exchange rate line.

Former Member
0 Kudos

The screenshot shows entry in document currency. Please click on "Display currency" and select "local currency".

Check and let us know.

Best Regards,

Chirag Panchal

Former Member
0 Kudos

Hi Chirag Panchal

we checked now still the same result please help

Former Member
0 Kudos

Writing some basic points which should be taken care:

  • Reconciliation account of customer code to be maintained in OB09.
  • Realized & unrealized gain & loss account and adjustment account to be maintained in OB09. As already informed currency details should not be maintained.
  • Post customer invoice with posting date of past. Check exchange rates correctly picked up in invoice or not.
  • Post payment in current date. Maintain exchange rate in current date which MUST be different than posting date of invoice.

Best Regards,

Chirag Panchal

former_member198650
Active Contributor
0 Kudos

Hi Inayat,

What is your local currency?

Regards,

Mukthar

Former Member
0 Kudos

Hi Mukthar

Local Currency is INR

Former Member
0 Kudos

Dear  Chirag Panchal

We have already Tried with above Points , still no impact please help

Former Member
0 Kudos

Hi Mukthar,

Plaese Find the OBBS  & OB08 screen shot

Former Member
0 Kudos

Hi Mukthar,

Please find the screen shot of OBBS & OB08

Former Member
0 Kudos

HI All

Please help

Former Member
0 Kudos

Dear Inayat Khan,

Maintain the Exchange rate in Ob08 like below format.then it will automatically trigger while doing sale order/invoice.

 

Regards,

Ashwin