System is not translating Goodwill offset account in USD_Reporting

Summary:

Goodwill offset account is not getting translated in USD_Reporting for some of the entities and for some entities it is getting translated incorrectly. We have exchange rates in USD for the period,

and the data is consolidated and translated in USD.

Find below the observations with screenshots.

1. Data at the top parent entity “AEGON” matches the USD_Reporting data (refer to the green-highlighted cells). However, the entities beneath it do not match in USD and only reconcile in Entity Currency (refer to the yellow-highlighted cells). Refer screenshot "1".

2. The Balance Sheet variance in USD is being driven by the “Goodwill Offset” account. This account is translating correctly for the entities highlighted in green, translating incorrectly for the entities highlighted in yellow, and not translating at all for the entities highlighted in red under entity hierarchy AEGON. Refer screenshot "2".