Skip to Content
Former Member
Oct 13, 2016 at 08:12 PM

Consolidation - Incorrect YTD Currency Translated value for Periodic Model

140 Views Last edit Oct 10, 2016 at 07:56 AM 2 rev

Hi Experts,

We have a Consolidation Model with Periodic Data Type.

While there are no issues with LC calculations, we are encountering issues with YTD issues post currency conversion for P&L accounts.

Post Currency conversion, owing to differences in FX AVG rates, even if the Periodic values have been nullified to 0, the YTD currency converted value continues to have a residual amount. The Currency conversion business rule is AVG for P&L accounts.

Please check the screenshot attached to see how the YTD value continues to have a minimal residual balance pertaining to FX even after the balance has become 0. What would be the solution for this? Naturally, this wouldn't be a problem if the Model was YTD, but is this how the system would always function for Periodic models? This makes reporting in YTD very difficult.

Any suggestions would be welcome!