Hello. We are using Apps 9 Update 13.
When we receive a customer payment for an advanced invoice, the FX gain/loss is not recognized into the FX/Gain loss account but stays in the deferred revenue account.
In the example below, accounting currency is in CAD and invoice currency is in USD. When the invoice was booked, it was booked at a CAD equivalent of 165,758.34.
Below is the customer payment (green highlighted). The CAD equivalent of the payment is 167,402.52. So there should be an FX gain on the payment of CAD 1,644.18, but it is not separated out to be posted to the FX gain/loss account. Instead, it is booked into the deferred revenue account, so it stays there.
Is there any way to get the FX gain/loss on customer payment of advance invoice to automatically post to a separate FX gain/loss account?
I would appreciate any help or ideas. Thank you.