We have a customer account from overseas who paid us in Japanese Yen. So, we have setup multi currency in order to invoice this customer in Japanese Yen. The wire transfer to our US bank account is adjusted accordingly with the exchange rate.

Our issue is that when we generated P&L, it reported the amount of Japanese Yen in US dollars instead. For example, for the month of October, we invoiced this customer for 800000 Yen. Customer wired 800000 Yen which is based on the exchange rate equaled to USD 7144.13. While with other US based customer, we received USD 10000. The P&L report reported income display as USD 810000 instead of USD 17144.13.

How do we fix this?