[Feature] Support consolidated currency conversion

fivetran / dbt_xero

Data models for Fivetran's Xero connector built using dbt.

https://fivetran.github.io/dbt_xero/#!/overview

Apache License 2.0

10 stars 20 forks source link

[Feature] Support consolidated currency conversion #47

Open rishi-tripathy opened 8 months ago

rishi-tripathy commented 8 months ago

Is there an existing feature request for this?

[X] 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.
[X] Yes, but I will need assistance and will schedule time during your office hours for guidance.
[ ] No.

Anything else?

No response

fivetran-reneeli commented 8 months ago

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 commented 8 months ago

Hi @rishi-tripathy, just following up!