Tracking of FX movement
We are a Euro based company but have some GBP Subsidaries. Running 11.5.10.2
We translate those balances to Euro on a monthly basis for group reporting. We also need to track the Gain/Loss on FX movements for our fixed assets.
At present we just use the Translated TB and pull out the rate adjustment column to get this data, however it's quite time consuming and it's limited as it can inly be run on a PTD basis.
Is there anyway to get this data easier on a YTD basis? or what are people using to achieve this.
I have tried to write some scripts but am having difficulty pulling it back as needed.