List of Contributions

Hi Khai, Long time no hear. Yes, totally agree it affects all accounts in the P&L and gave the intercompany as an example. In my example, there would be a value in in the intercompany P&L account against company B in group currency (converted value) of GBP 166 whilst USD would be 0 as nothing being ...

Hi Tor, We use monthly translation for the P&L. The only thing I would say you need to be aware of is if someone books something incorrectly to the P&L. For example if on intercompany account a value was booked against the wrong counterparty and then the following month the correct counterparty used, ...

Hi John, Probably a bit late, what we do in our Excel reports is we have a data sheet that pulls back all the data from Cognos Controller (with the fgetval formula) and then we have another sheet called data values in the Excel report which is an exact replica of the data sheet but created using paste ...