F-28 does not post exchange difference automatically

[Former Member]

Hi

I have following scenario :

1) Customer invoice is $ 100 ( it is AED 368 )

2) Payment received in AED @ 3.7 ie total AED 370

3) In OB08 exchange rate is 1 $ = AED 3.68. So exchange diff is AED 2 ie $ 0.54 (ie AED 3.68 -3.70)

But entry for exc. diff goes to a different deduction account. It does not go to the GL defined in OB09

Pl advise.

Do I have to do some config in customer master. Is any specific selection to be done in F-28 screen.

Thanks

kamala

[Former Member · Accepted solution]

Have you checked the settings in transaction OBA1?

[Former Member · Accepted solution]

Hi

In OBA1, I have assigned the GL 700400 ( Gain / loss P/L a/c ) to the customer Reconciliation a/c 121000 .

The invoice is recored in foreign currency AED. But in Customer balance, it is showing in transaction currency USD.

In F-28 , I give currency AED and the rate is picked from OB09. Now I do not put any rate in the screen, though I receive AED 370 instead of AED 368 - invoice value. The excess of AED 2 is due to exc. rate diff and I want it to go to Gain /loss exc diff A/c.

I TRIED GIVING THE EXC RATE IN F-28 ( diff from one in OB08) and get foll entry.

001 40 0000113002 Conc Act - Wires In 3,710.00

002 50 0000440000 Unallowed Deduction 10.00-

003 15 0000123456 testks 3,700.00-

004 40 0000700400 G/L FC Difference 0.00

WHY IS G/L showing ' 0.00' amount.

Thanks

kamala

[Former Member · Accepted solution]

Hi,

Your local curreny is USD, and AED is a foreign currency, right? If yes, in your clearing process, the amount foreigh currency AED has a difference AED 2, the difference will go to payment difference account configured in T-code:OBXL rather than exchange rate differenct account.

Edited by: David Yin on Apr 14, 2010 9:08 AM

[Former Member · Accepted solution]

Have you configured for parallel currency, then in one currency the system show it as zero-'0' and in other currency it will display the amount

[Former Member · Accepted solution]

HI

The loc curr is USD. The invoice entry is in AED .Invoice amount $ 100 = AED 368 ( @ 3.68) .

In F-28, the amount received is in AED and the rate is 3.70.

1) I select currency AED , give rate ' / 3.700 ' and put amount 370 AED, then go to PROCESS OPEN ITEMS '

2) I select the invoice with amount AED 368. There is a diffrence of AED 2. I dont put it in 'difference posting'.

3) I stimulate and the entry is

001 40 0000113002 Conc Act - Wires In 370.00

002 50 0000440000 Unallowed Deduction 2.00-

003 15 0000123456 testks 368.00-

004 40 0000700400 G/L FC Difference 0.00

NO AMOUNT IN GAIN / LOSS DIFFERENCE.

Pl let me know

kamala

[Former Member · Accepted solution]

NO PARALLEL CURRENCY INVOLVED

thanks

[Former Member · Accepted solution]

Hi

It could be most probably cash discount or payment difference due to tolerance limits specified.

However to confirm this, Display the document in FB03 and find out the value in the field "Transaction" in the difference line item.

Then go to FBKP, click on automatic postings and find out where the same value of "Transaction" is. This will give you a clue as to why this line was generated.

In case if you have not posted the document, even then you can find the value of "Transaction field' in the debug mode with the help of an Abaper.

Regards

[Former Member · Accepted solution]

Hi

In document display, I clicked on the box ' DISPLAY CURRENCY' and here is the entry with the difference in Gain / loss account.

All along i was seeing the document in the foreign currency AED which said ' 0.00' for gain /loss.

40 113002 Conc Act - Wires In 100.00 USD

15 123456 testks 100.00- USD

40 700400 G/L FC Difference 0.54 USD

50 440000 Unallowed Deductions 0.54- USD

Thanks for the good inputs

kamala

[Former Member · Accepted solution]

Hi

Actually I want to find out the value of the field name "Transaction" in each line item. Can you please display the document with this information too and paste it here.

Regards

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi

To get the field "Transaction", go to T.code FB03, display the document, select "change layout" and find the field named "Transaction", add this to your layout and press Copy. Now you can see that the document display is displaying the document along with the Transaction for each line item.

BTW, FBKP is a T.code and not a table.

Regards

[Former Member · Accepted solution]

Hi...................here it is

PL tell me why the unallowed deductions come here. Is it because the local curr USD is the stronger one ie 1 USD = AED 3.68 and i am paying the same $ 100 irrespective ot the changes to AED.

40 113002 Conc Act - Wires In 370.00 AED

15 123456 testks 368.00- AED

40 700400 G/L FC Revaluation 0.00 `AED KDF

50 440000 Unallowed Deductions 2.00- AED ZDI

kamala

[Former Member · Accepted solution]

Hi

ZDI represents "Payment differences by reason" under "Cash discount and payment differences" under FBKP. So this line item was posted due to difference in payments.

You can also view this in T.code OBXL.

Also the reason for choosing that account could be that the "No forex rate diff. when clearing in LC" option would be ticked in its Co. code configuration (T.code OBY6), so to post the difference, system has choosen this GL account.

Regards