Skip to Content
0
Former Member
Aug 10, 2016 at 04:34 AM

Foreign exchange difference in Auto payment

42 Views

Hi SAP Experts,

I'm new on SAP and currently set up for Auto Payment Program.

My client had case that the AP amount comprised items with difference FX rate.

For example: Item 1: 100,000 JPY with FX USD/JPY = 100 -> 1,000 USD

Item 2: 121,000 JPY with FX USD/JPY = 110 -> 1,100 USD


And when made payment the FX was USD/JPY = 105.

My client want that when run Auto Payment for this Vendor, system will calculate the FX difference for each items. The transaction will be:

Dr A/P 221,000 JPY 2,100 USD

Dr FX loss 52.38 USD (the FX difference for item 2)

Cr Cash 221,000 JPY 2,104.76 USD

Cr FX gain 47.62 USD (the FX difference for item 1)

But when use Auto Payment, system create transaction as below:

Dr A/P 221,000 JPY 2,100 USD

Dr FX loss 4.76 USD (Net FX difference of 2 items)

Cr Cash 221,000 JPY 2,104.76 USD


Please advice how could I make configuration so the APP record transaction same as requirement.


Best regards

Tung Luu.