Problem in T-code: F-32

[Former Member]

Dear Experts:

We are facing a problem while doing transaction against T-code: F-32. In Transaction we are selecting USD as Vendor's currency is USD but our Local Currency is BDT. Exchange rate maintained in system as BDT 78 = USD 1. So when we are transferring Charge of difference in a Particular G/L system exchanging USD amount with an impractical rates like 3848.45. We can't understand and confused how system calculating this rates. Please find attached screen shot for your reference. Already our users given lots of entries and we don't know actually how we resolve this issue.

Your suggestion and expert opinion is highly appreciated.

Thanks & Best Regards.

Ripon Kumar Paul

[former_member182339]

Check ratio maintained in OBBS, it seems the ratio may be different

Best Regards

Hrusikesh

[Former Member]

Dear All:

Ratio maintained for B and M type is 1:1

Best Regards.

Ripon Kumar Paul

[Former Member]

Hi,

Looks like line 2 of the document was manually added,

When the line is captured the Local currency amount can be changed from the standard calculated amount (Trx curr amt * exh rate), this will result in the actual rate for the line to be different from the rate in the header of the document.

Best regards

Lodie

[former_member188028]

Please check the below

1. Check exchange rate type in OB08

2. Next check translation ratio for this type for the affected currencies in OBBS.

[former_member184580]

Hi Ripon kumar,

Have you checked the exchange rate table (ob08) and any default exchange rate type assigned to clearing document?

Regards,

Prasad

[Former Member]

Hi Ripon,

Can I ask you some questions?

- Doc 100001296 is clearing document, created from F-32,correct?

- Is the first screenshot exported from SAP system?

- In the first screenshot, when I use Local Curr amount divided (BDT) to Doc Curr amount (USD) to get Exchange rate, I see all exchange rate is different.

Doc amount (USD)	LC amount (BDT)	Exchange rate
288,127.16	22,473,918.48	78.00
365.97	1,408,417.45	3,848.45
(89,123.17)	(7,257,986.60)	81.44
(223,536.71)	(18,441,778.70)	82.50
(16,398.25)	(1,352,778.70)	82.50
40,565.00	3,170,285.00	78.15
-	187,708.68	#DIV/0!
-	(187,708.68)	#DIV/0!

Do you maintain exchange rate daily or monthly or yearly or you use only one exchange rate is 78?

I guess that the user is entered manually LC amount when posting document, so, the system cannot get exchange rate 78.

- Now, what do you want to fix? like below table?

Posting Key	Doc amount (USD)	LC amount (BDT)	LC amount (BDT) new	Ex. Rate old	Ex. Rate new
09	288,127.16	22,473,918.48	22,473,918.48	78.00
40	365.97	1,408,417.45	28,545.66	3,848.45	78
17	(89,123.17)	(7,257,986.60)	(7,257,986.60)	81.44
17	(223,536.71)	(18,441,778.70)	(18,441,778.70)	82.50
17	(16,398.25)	(1,352,778.70)	(1,352,778.70)	82.50
27	40,565.00	3,170,285.00	3,170,285.00	78.15
40	-	187,708.68	1,379,794.86	#DIV/0!
50	-	(187,708.68)	0	#DIV/0!

Sorry if I'm not clear your requirement.

Please explain to me in more detail.

Thank you.

Julie

[Former Member]

Dear Julie:

Yes This is a clearing document created from F-32.

Yes the first screen shot from SAP but its a Z development.

We maintain exchange rate per Central Bank Circular. It can be daily, weekly or Monthly. We change when it requires. 78 is current rate.

Yes I want to fix like that table and want to know from where system getting exchange rate 3,848.45. and How can I fix the problem so that in future exchange rate will take same rate in every transaction.

Thanks & Best Regards.

Ripon Kumar Paul

[Former Member]

Hi Ripon,

OK. I understanded your case.

1. So now, please go to tcode OB08 to check exchange rate USD:BDT whether it maintain daily, monthly or yearly.

2. Next, go to tcode FBL5N, fill you customer number, choose Cleared Item option, fill Clearing date is 07.06.2013, then execute.

- See your report whether field Clearing document, Clearing date are available or not. If they aren't here, choose Change Layout button (or press Ctrl + F8), choose field Clearing document and Clearing date in Hidden column (right column) and move them to left comlumn to display them.

- Filter report by Clearing document with value:100001296 and show me this screenshot.

3. If the line item Remittance (amount 365.97USD) and line item (amount 288,127,16USD) are in the same document number, please go to FB03 to display it and show me the screenshot.

The solution in this case is reset and reverse cleared document, make adjustment and clear customer again. But, before that, we need to find out where the error comes. So, please be calm and share me more information to fix it.

Regards,

Julie

[Former Member]

Dear Julie,

Thank you very much for your support. It is really appreciated. Please find attached screen shots as per your requirement.

Hope these screen shots will help you out to fix the issue.

Thanks.

Best Regards.

Ripon Kumar Paul

1.

2.

3.

[former_member182339]

Hi Ripon,

You should check couple more check points

Check Point 1-I would suggest check if any exchange rate type assigned in OBA7 for that specific document type if yes check what value maintained for the same in OB08.

Check Point-2-The exchange rates are entered pretty inconsistent in relation to your OB08 table in most entries so for me it looks like program error

See Following SAP note and implement as required

329950, 1578928

891585. 633908

There is few more SAP notes need to be checked and i would suggest 

Raise an OSS query to SAP for the same.

Best Regards

Hrusikesh

[Former Member]

Dear Hrusikesh:

Exchange Rate Type not assigned with Document type AB. We have maintained two types (B & M) of Exchange rate type to meet our requirement. B for Payment and M for collection. Please see below screen shot for OBA7.

Best Regards.

Ripon

[Former Member]

Hi Julie,

Please help in following mentioned issue.

Two invoices was cleared with the credit balance in customer's account and some amount is still left credit after clearing.

The issue is the customer belongs from Canada but invoices cleared with USD instead of CAD through T-Code F-32. Now, I want to reset the same but the problem is that I am not able to process this in T-Code : FBRA. There  is some error message occurred.

If there is any other way to resolve this issue than please advise.

Thanks

Raman

[Former Member]

Hi Raman,

May I know which the error message you face when run FBRA?

As my understanding, if you need to reverse cleared document, you need to use FBRA to reset and reverse it.

Julie

[Former Member]

Hi Julie,

Thanks for your help.

Right now I don't have the exact error message. I will forward you once I get it.

Regards,

Raman