Skip to main content
January 10, 2024
Solved

FX Rates

  • January 10, 2024
  • 3 replies
  • 0 views

Is there an audit on FX rates, to see who updated the FX rates?

Best answer by dipayan_roy

you can refer to the AuditFXRate table in the application database and find out who updated and when based on the source and destionation currency id 

3 replies

January 11, 2024

you can refer to the AuditFXRate table in the application database and find out who updated and when based on the source and destionation currency id 

January 11, 2024

Check that you have the standard System / Application Reports from Marketplace:


JackLacava_0-1704981459249.png

 

October 24, 2024

What about the actual FX Rate Amount?  How can we audit the amount?

I'm looking at the standard report.  There are two reports in report group "FX Rates Audit."  The first is the "FX Rates Lock/Unlock Audit" and the second is the "FX Rates Current Status."

I've locked periods 10, 11, and 12.  Then I unlocked period 10.  The first report shows this unlocked/locked activity.


chris_rothermel_0-1729769263201.png

While the second report shows period 10 is unlocked, while periods 11 and 12 are locked. 


chris_rothermel_1-1729769387289.png

In both the audit portion shows the specific rate type, period, locked/unlocked status, User, and Date/Time.

I was expecting to see the actual FX Rates.  If I were to investigate a currency restatement to explain a variance I'd want to know what the actual rates were before and after the change.  The reports show who is locking/unlocking the rates however there are no rates in the report.

Standard Application Reports PV 610 SV 100

 

 

 

October 24, 2024

Same latest version (PV640 SV100 2024)