How can we have both gain and loss from exchange rate difference in one clearing document?

[former_member494026]

Dear experts,

Please, advise on the following issue.

We have two customer invoices that were posted in the foreign currency on two different dates and with two different exchange rates respectively.

Also, we have an incoming payment in the same foreign currency that covers exactly both invoices and it’s posted on a date later than the invoices. It’s posted with FB01 without clearing the invoices.

The exchange rate of the payment falls between the rates of the invoices.

If we clear all these 3 items with one clearing document in F-32 or FB05, we find that the system posts the net exchange rate difference – either gain or loss. So, the system finds the exchange rate difference of the first invoice against the payment (let’s say it’s gain (-5)) and the exchange rate difference of the second invoice against the payment (let’s say it’s loss (+3)). And only the delta (difference) of (-2) is posted to the gains account in the clearing document. The currency of the clearing document is the one of the invoices and the payment.

It’s correct mathematically, but we need to unfold the difference in the posting – we need not (-2), but (-5) in the gains account and +3 in the losses account.

How can we do it within one clearing document?

We understand that we can clear invoices one by one in separate clearing sessions, but the number of the documents is large and it’ll mean more manual work.

We have different gains and losses accounts in OBA1. Also, we tried to tick and untick checkbox Indicator: No ex.rate difference when clearing in local crcy in the company code global data. But that didn’t change the system behavior.

I read similar topics here but didn’t find the exact answer.

Thank you and Regards,

Anton Morgunov

[narendra_b12]

Hi Anton,

Hope you have resolved the above issue. We are also facing the same issue.

Could you help us to resolve.