Revenue and Invoice amount mismatch for Foreign currency contracts
We are using Amount based Sales invoices and revenue recognition. So, we are creating billing events that can be used to Recognize revenue and generate sales invoices.
The issue we are facing is for foreign currency contracts, where the billing event amount is provided in foreign currency. Invoice amount conversion from Foreign currency to Ledger currency happens based on the Invoice date and Revenue amount conversion from Foreign currency to ledger currency happens based on Transaction date (which is the event completion date).
As the invoice date can be different from the Event completion date and the currency rate on those dates can be different invoice and revenue amount in ledger currency would be different.