Foreign Exchange Gain and Loss generated in 1 document...by SAP.

[Former Member]

I found a strange line item(Foreign Exchange loss line) after automatic clearing.

No.1: AP document

AP document Doc.Curr:USD LCurr:CNY Lcurr2:JPY Lcurr3:USD

Dr:AP 3000 -19500 -270270 -3000

Dr:Materil-1 1000 6500 90090 1000

Cr:Materil-2 2000 13000 180180 2000

No.2: Outgoing payment

Outgoing Payment Doc.Curr:USD LCurr:CNY Lcurr2:JPY Lcurr3:USD

Dr:AP 3000 19200 230784 3000

Cr:Bank -3000 -19200 -230784 -3000

No.3:Automatical Clearing

Auto. Clearing Doc.Curr:USD LCurr:CNY Lcurr2:JPY Lcurr3:USD

Dr:AP 0 300 39486 0

Dr:Exchange Loss 0 120 1443 0 <----

---

why this line generated?

Cr:Exchange Gain 0 -280 -27286 0

Cr:Exchange Gain 0 -140 -13643 0

Because the rate is different between AP document and Payment document.(No.1 and No.2)

I thought it should only have foreign Exchange gain, but after I did automatical clearing(t-code F.13)

I found the clearing document had a line item on Exchange loss in Document No.3(the second line).

Who know the reason?

Thanks a lot.

[Former Member]

Hi

As per the Accounting the entry is right

Dr:AP 0 300 39486 0

Dr:Exchange Loss 0 120 1443 0

Cr:Exchange Gain 0 -280 -27286 0

Cr:Exchange Gain 0 -140 -13643 0

But actual entry should come like this

Dr:AP 0 300 39486 0

Cr:Exchange Gain 0 -200 -27286 0

Cr:Exchange Gain 0 -100 -13643 0

We need to verify why 200 has come as 280 and 100 has come as 140

Can you verify the date which you have done outgoing payment and date which you have done clearing?

may be different dates with different foriegn currency rate

Reg

Vishnu

[Former Member]

I cleared the documents(AP and payment) with automatical claring with t-code: F.13,

the third document is generated by SAP automatically, so the foreign exchange loss is generated by SAP automatically....

I do not know the reason....

[former_member188028]

Hi,

Please check OB09 account determination for the vendor reconciliation account.

[Former Member]

To check what?