Wrong exchange rate/local currency taken up

[Former Member]

Hi,

I have a scenario at the following sequence as follow:

1. Booked in AR Invoice @ Foreign Currency USD5,215.88 @ Local Currency $15,890.18

2. Incoming Payment for invoice #1 above @ Foreign Currency USD5,215.88 @ Local Currency $15,850.02

- Journal Entry:

Dr. Bank $15,850.02

Dr. Realized exchange loss $40.16

Cr. BP $15,890.18

3. Cancel Incoming Payment #2 above.

- Journal Entry:

Dr. BP $15,890.18

Cr. Bank $15,850.02

Cr. Realized exchange loss $40.16

4. Incoming Payment for invoice #1 above @ Foreign Currency USD5,215.88 @ Local Currency RM15,850.02

- Journal Entry:

Dr. Bank $15,850.02

Cr. Realized exchange gain $0.01

Cr. BP $15,850.01 <--- This is not right. SAP B1 should be picking this up as $15,890.18

Is this some kind of bug?

SAP B1 2007A SP01 PL07

[Former Member]

Hi,

Try to check on which date you have create Incoming payment, on that day rate is some what different then cancelling same document date.

Hope (Incoming payment and cancelling) both date are different, and that a reason two different amount show.

Thanks

Kevin

[Former Member]

The incoming payment and the cancellation is the same date.

However, even if it's a different date, it should credit the business partner the original invoice value which is $15,890.18.

[Former Member]

Hi,

If Date different then you have to configure

Administrator > Setup > Finance > GL Determination > General tab

where you have choose GL, that will hit.

Thanks

Kevin

[Former Member]

Hi Kevin, thank you for the reply. However, the issue here is not about the GL. The GL is correct. The amount is wrong.

[Former Member]

Hi,

I try the same case on my test machine, i found the date was different and there rate as well different,

But If I do all activity on same date there is no problem.

Thanks

Kevin