Skip to content

v1.4.2 dbt_quickbooks

Latest

Choose a tag to compare

@fivetran-data-model-bot fivetran-data-model-bot released this 03 Mar 21:13
e2bdd8f

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