[Feature] Support consolidated currency conversion

[rishi-tripathy]

Is there an existing feature request for this?

• I have searched the existing issues

Describe the Feature

Support transforms reporting their values in the converted currency of the primary subsidiary. Currently they are reported in the source currency of each currency, resulting in mixed values in the output.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response

[fivetran-reneeli]

Hi @rishi-tripathy thanks for opening this!

Could you elaborate on how you would imagine the conversion to the primary currency would work? Currently in our general ledger model, amounts are taken from journal_line table but there does not exist a conversion rate field in that table.

I am looking through our ERD to figure out the best way to bring conversion rate into the models. In the meantime, let me know if you have found an accurate way of doing so?

[fivetran-reneeli]

Hi @rishi-tripathy, just following up!