Transfers with no currency and exchange rates halting our use of the General Ledger Model

[instantbookkeeper]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

https://fivetran.com/docs/transformations/data-models/quickbooks-data-model/quickbooks-transform-model#multicurrencysupportandexistinglimitations

if this is critical and/or you believe you can help contribute to scoping out adding that functionality in.

Relevant error log or model output

Expected behavior

Transfers and all transactions within QB for Multi currency, should be

Possible solution

No response

dbt Project configurations

NA

Package versions

NA

What database are you using dbt with?

bigquery

How are you running this dbt package?

Fivetran Quickstart Data Model

dbt Version

NA

Additional Context

No response

Are you willing to open a PR to help address this issue?

• Yes.
• Yes, but I will need assistance.
• No.

[fivetran-avinash]

Hi @instantbookkeeper , thanks for reporting this! This is a known gap in our product and we have been trying to explore best ways to address this. Once we come up with a good solution, we will report back with any findings or solutions!

[instantbookkeeper]

@fivetran-avinash Thank you! Can I help in any way?

[fivetran-avinash]

Hi @instantbookkeeper ! We'll investigate and let you know if there is any way you can help!

[fivetran-joemarkiewicz]

@instantbookkeeper just wanted to report back that we're still looking into this fix and will let you know if we find a solution.