Apply customer ledger entries with foreign currency problems

Stephanie_Yip

If a customer has customer ledger entries in LCY (for example: 1 outstanding invoice of $3531 LCY which was invoiced on 14/11/07 and the exchange rate for SGD is 1.45). I received the payment on 03/03/08 of $5,119.95 in SGD. The exchange rate for SGD is 1.41 as at 03/03/08.

The following information is entered in cash receipt journal:

Posting Date : 03/03/08
Document Type : Payment
Account Type : Customer
Account No. : C0001
Currency : SGD
Currency Factor : 1.41

In the Apply Customer Entries window, the entry for the outstanding invoice displays the following:

Remaining Amount : $3531
Appln. Remaining Amount : $4978.71

The payment has applied to the invoice, but shows Balance field of -$141.24 SGD in Apply Customer Entries window.

The payment is posted.

In the Customer Card window, the Balance (LCY) displays -$100.17.

Here are my doubts:

1. Why is Appln. Remaining Amount in Apply Customer Entries window displays $4978.71, not $5119.95?

2. Why is the Customer Card displays an overpaid of $100.17 LCY ($141.24 SGD) not $0?

kiyac

Hi Stephanie,

Do you get your answer? As I have similar enquiry, besides, sometimes, I found foreign currency apply another foreign currency will trigger exchange gain / loss, is it normally, any example explain the NAV behaviour on foreign currency payment apply with foreign currency invoice?

Thanks!