fivetran/dbt_quickbooks v1.4.2

v1.4.2 dbt_quickbooks

on GitHub

PR #199 includes the following updates:

Bug Fixes

• With variable configuration now available in Quickstart, the quickbooks__home_currency variable from the v1.1.1-a2 pre-release is now available across all 13 intermediate double-entry transaction models to optimize multi-currency handling. When the variable is set, transactions in the designated home currency will not apply exchange rate conversions on converted_amount, improving accuracy. When left empty, all transactions will see exchange rate conversions applied. (PR #197)
  • Updates the README with instructions for configuring the quickbooks__home_currency variable.
• Applies fixes in int_quickbooks__sales_receipt_double_entry model to correctly reference quickbooks__global_tax_account_reference and quickbooks__sales_tax_account_reference variables. (PR #197)
• Introduces the partition_by_source_relation macro to conditionally include source_relation in window function PARTITION BY clauses only when multiple sources are configured via the quickbooks_union_schemas and quickbooks_union_databases variables. This resolves partition by constant expression errors on Redshift. See the README on how to leverage these variables. (PR #198)

Under the Hood

• Changes default quickbooks__home_currency value to empty string for easier understanding within Quickstart UI. (PR #197)

Full Changelog: v1.4.1...v1.4.2