E9.2 GL Consolidations

[BCampbell]

We are looking to use GL Consolidations in E1, but in the guide it states that the companies you are consolidating must have the same currencies:

General Accounting Implementation Guide

The account consolidation programs enable you to group, or consolidate, business unit account balances for online review and reports, provided that the balances are in the same currency and all of the companies use the same fiscal date pattern.

docs.oracle.com

Has anyone used a third party product that integrates to E1 that could convert amounts for all companies to USD then consolidate?

 

[jemez842]

We used the R11414A to restate everything to USD in the AC ledger within JDE. Then exported the balances of both AA and AC ledgers to Hyperion to use for the consolidation piece. We had some reports we ran in JDE too, but most of the interactive piece the users were using was in Hyperion.