Skip to Content
0
Former Member
May 04, 2018 at 06:33 AM

How SAP calculate exchange gain/loss while clearing AR?

228 Views Last edit May 04, 2018 at 07:36 AM 2 rev

Dear Experts,

Please take a look of this document snapshot and the text I attached, which is the cleared document list.

As you can see, most of AR were posted between 2018/03/07 and 2018/03/09, and the exchange rates are 29.25, 29.26 and 29.275 (USD to TWD).

The clear date is 2018/04/23, and the rate is 29.405.

There is one payment from customer is 3,500,000 HKD, 2018/04/20.

When SAP calculate the exchange gain and loss, it generated the first line of 77.38 USD, which we know it's because of the payment of 3,500,000 HKD, But we don't understand how lines 8 to 11 come out with such big numbers (in the red box).

Total AR = 3,886,073 USD = 114,269,977 TWD on 4/23, and 113,689,887 when posting. Payment receiving: 3,500,000HKD and 1,000,000 USD on 4/20 and 2,440,000 USD on 4/23.

Can you tell me how 5,523,699, 42,539,738 and 47,541,774 been calculated?

Thank you so much!

Joanne

Attachments

clearing-docs.txt (44.7 kB)