Skip to Content
0
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!

Thanks.

Attachments