v0.13.1 dbt_quickbooks

PR #125 includes the following updates:

Bug Fix

• The period_first_day and period_last_day fields were mistakenly left out in the quickbooks__profit_and_loss model although they were intended to be introduced as new fields in the v0.13.0 release. We have added these fields into the model.

Full Changelog: v0.13.0...v0.13.1

v0.13.0 dbt_quickbooks

PR #124 includes the following updates:

🚨 Breaking Changes 🚨:

• Updates the int_quickbooks__invoice_join and downstream quickbooks__ap_ar_enhanced models to include and require the using_payments config. Previously, these models would fail if the payment or the payment_line source tables did not exist.
• Corrects the misspelled customer_vendor_webiste field to customer_vendor_website in quickbooks__ap_ar_enhanced.

Bug Fixes

• Updates the logic for the amount field in int_quickbooks__invoice_double_entry to use invoice.total_amount only on the condition when a bundle is associated with the invoice and invoice.total_amount is 0, otherwise invoice_lines.amount is used.
  • This avoids double counting when aggregating invoice_line items and accounts for the edge cases where a bundle_id is involved.

Feature Updates

• Updates the quickbooks__profit_and_loss and quickbooks__balance_sheet models to include both period_first_day and period_last_day in addition to calendar_date. This allows users to have greater flexibility in choosing which date to aggregate records upon.
  • Please note calendar_date is slated to be deprecated, and the fields period_first_day and period_last_day are both offered as replacements, depending on how your company performs their financial reporting.

Full Changelog: v0.12.4...v0.13.0

v0.12.4 dbt_quickbooks

PR #123 includes the following updates:

Bug Fixes

• Added source_relation to joins within the following models as it was previously missed:
  • int_quickbooks__invoice_join
  • int_quickbooks__bill_join
  • int_quickbooks__refund_receipt_double_entry
  • int_quickbooks__sales_receipt_double_entry
  • quickbooks__balance_sheet analysis model.

Contributors

• @MatteyRitch (PR #121)

Full Changelog: v0.12.3...v0.12.4

v0.12.3 dbt_quickbooks

PR #119 includes the following updates:

Bug Fixes

• Included a default start and end date in the int_quickbooks__general_ledger_date_spine logic when generating the date spine. These default start and end dates will ensure the model still succeeds when no transactions are yet available.
  • The default start date will be one month in the past
  • The default end date will be the current date

Under the Hood

• Updated the maintainer PR template to resemble the most up to date format.
• Removed the check docs GitHub Action as it is no longer necessary.

Full Changelog: v0.12.2...v0.12.3

v0.12.2 dbt_quickbooks

PR #114 includes the following updates:

Bug Fixes

• Updated model int_quickbooks__invoice_double_entry to account for the sales_item_account_id field from the invoice_lines source when determining the account_id associated with an invoice.

Full Changelog: v0.12.1...v0.12.2

v0.12.1 dbt_quickbooks

PR #109 includes the following updates:

Bug Fixes

• Adjusted the joins within the below intermediate double entry models to be left join as opposed to an inner join. This update was necessary as there was the possibility of the respective account cte joins to return no records. If this was the case, the logic could erroneously remove transactions from the record.
  • int_quickbooks__bill_payment_double_entry
  • int_quickbooks__credit_memo_double_entry
  • int_quickbooks__deposit_double_entry
  • int_quickbooks__invoice_double_entry
  • int_quickbooks__payment_double_entry

Full Changelog: v0.12.0...v0.12.1

v0.12.0 dbt_quickbooks

PR #103 includes the following updates:

🚘 Under the Hood

• Update seeds and configs in the integration tests folder to match what was updated upstream in the (source package PR #51) to correct timestamp fields that should be date fields (due_date, transaction_date). Previously, some fields were getting interpreted as timestamps while some were interpreted as dates, leading to errors on downstream joins. In the upstream staging models, due_date and transaction_date are now explicitly cast as date types.

This will be a breaking change to those whose source tables still use the old timestamp formats, so please update your package version accordingly.

Full Changelog: v0.11.1...v0.12.0

v0.11.1 dbt_quickbooks

This release of dbt_quickbooks includes the following updates:

🐛 Bug Fixes 🩹

• Updated intermediate double entry models that have account_type and account_sub_type filters with configurable variables, since the type names used in the filter can be adjusted internally by QuickBooks customers. (#98)
• Includes items.asset_account_id as the second field of the coalesce for the payed_to_account_id field within the int_quickbooks__bill_payment_double_entry model to ensure all account_id types are taken into consideration when mapping the transaction to the proper account. (#100)

🎉 Feature Updates 🎉

• The intermediate models where these variables were introduced in the models below (#98):

Updated model	New variables to filter on
int_quickbooks__bill_payment_double_entry	quickbooks__accounts_payable_reference
int_quickbooks__credit_memo_double_entry	quickbooks__accounts_receivable_reference
int_quickbooks__deposit_double_entry	quickbooks__undeposited_funds_reference
int_quickbooks__invoice_double_entry	quickbooks__sales_of_product_income_reference, quickbooks__accounts_receivable_reference
int_quickbooks__payment_double_entry	quickbooks__accounts_receivable_reference

🗒️ Documentation

• Updated README with additional steps for configuration. This is an optional step since most customers will rely on the default account type/subtype values available.

Contributors

• @mikerenderco (#100)

Full Changelog: v0.11.0...v0.11.1

v0.11.0 dbt_quickbooks

🚨 Breaking Changes 🚨

PR #95 includes the following updates:

🪲 Bug Fixes

• Included source_relation in all joins and window functions for models outputting source_relation. This is to prevent duplicate records in end models when using the unioning functionality. These updates were in the intermediate models, which flowed to downstream end models:
  • quickbooks__general_ledger
  • quickbooks__expenses_sales_enhanced
• In end model quickbooks__general_ledger, added source_relation as part of the generated surrogate key unique_id to prevent duplicate unique_ids when using the unioning functionality.

🎉 Features

• Added description for column source_relation to the documentation.

🚘 Under the Hood

• Updated test from a combination of columns to uniqueness of unique_id in quickbooks__general_ledger.
• Updated partitioning in certain models to include source_relation.
• Updated analysis quickbooks__balance_sheet with updated join strategy.

Full Changelog: v0.10.0...v0.11.0

v0.10.0 dbt_quickbooks

This release of dbt_quickbooks includes:

🎉 Feature Update 🎉

• Databricks compatibility! (#92)

Full Changelog: v0.9.1...v0.10.0