fivetran/dbt_quickbooks v0.18.0

v0.18.0 dbt_quickbooks

on GitHub

This release introduces the following updates.

Breaking Changes

• Modified int_quickbooks__bill_payment_double_entry model to ensure bill payment accuracy by updating the converted_amount logic. These changes improve the integrity and granularity of debit/credit entries for bill payments. (PR #155)
• We've made this a breaking change as this update could potentially change (but fix) the amount outputs of the end models.
  • Utilized the line-level amount from bill payment lines instead of total_amount from bill payments, then summed the lines to calculate the total. Bill payment lines in a bill payment can have different exchange rates applied depending on which bill it's associated with, so the bill exchange rate can come into play.
  • Applied exchange_rate from the associated bill where available, falling back to the bill payment exchange rate otherwise.
  • Inverted the sign of the amount when associated with a journal entry (to correctly reflect the accounting direction).
  • Updated joins to link bill payments with related bills and bill payment lines via the bill_linked_txn table to support more accurate allocation of payment amounts.

Under the Hood

• Added a general ledger consistency test to ensure matching records between production and development models. (#155)

Documentation

• Added Quickstart model counts to README. (#152)
• Corrected references to connectors and connections in the README. (#152)

Full Changelog: v0.17.1...v0.18.0