Accounting Billed Amount instead of Transaction Amount x GL Conversion Rates

Summary:

Hi, has anyone found a solution to this.

Credit Card Bank File:

• Expense Transaction amount = 100 USD
  
• Billed Amount = 154.25 AUD
  
• Bank Conversion Rate 1 USD to AUD = 1.54

Oracle System:

• Ledger Currency = AUD
  
• GL Conversion Rate 1 USD to AUD = 1.56
  
• Accounted Amount = 156 AUD
  

Oracle Fusion will use the uploaded GL Conversion Rates (1 USD to AUD = 1.56) to convert the Expense Transaction amount 100 USD to 156 AUD when processing into AP and accounting in the GL. However the GL Conversion Rate loaded into Fusion is a different conversion rate that is used by the bank for Billed Amount thus causing a gain/loss.

The organisation use "Company Pay" and pay the Billed Amount back to the bank i.e. $154.25. Thus, the GL is now overstated by $1.75 by the AP invoice accounting.