PR #213 includes the following updates:
Schema/Data Change
12 total changes • 3 possible breaking changes
| Data Model(s) | Change type | Old | New | Notes |
|---|---|---|---|---|
| All tax line models | Variable configuration (opt-in) | Individual tax line variables sufficient | quickbooks__tax_lines_enabled: true also required
| Possible breaking change for dbt Core users If you previously enabled any individual tax line variables, those models will now be disabled by default. See the Enabling Tax Lines section of the README for configuration details. |
quickbooks__general_ledger
| Potential new rows | No tax lines for Quickstart users | Tax lines now opt-in | Tax line rows are disabled by default. Set quickbooks__tax_lines_enabled: true and enable individual tax line variables to post tax lines to the tax liability account. Tax lines are added only when you opt in. See the Enabling Tax Lines section of the README for details.
|
int_quickbooks__purchase_double_entry
| Data change | paid_to_account_id = purchase line expense account; class_id = expense class from purchase line
| paid_to_account_id = tax liability account; class_id = null
| Possible breaking change for users with using_purchase_tax_line: true and quickbooks__tax_lines_enabled: true. Tax lines now correctly post to the tax liability account. class_id is no longer populated for tax line rows.
|
currency_id, exchange_rate, quantity, sales_item_quantity in several header staging tables
| Data change | Warehouse-native type | Explicit data cast to string for currency_id, or float for remaining fields
| Possible breaking change for downstream consumers with type-sensitive logic built on staging models. |
stg_quickbooks__bill_tax_linestg_quickbooks__bill_tax_line_tmp
| New models (opt-in) | — | — | Enabled via quickbooks__tax_lines_enabled: true and using_bill_tax_line: true. See the README for details.
|
stg_quickbooks__credit_memo_tax_linestg_quickbooks__credit_memo_tax_line_tmp
| New models (opt-in) | — | — | Enabled via quickbooks__tax_lines_enabled: true and using_credit_memo_tax_line: true. See the README for details.
|
stg_quickbooks__deposit_tax_linestg_quickbooks__deposit_tax_line_tmp
| New models (opt-in) | — | — | Enabled via quickbooks__tax_lines_enabled: true and using_deposit_tax_line: true. See the README for details.
|
stg_quickbooks__estimate_tax_linestg_quickbooks__estimate_tax_line_tmp
| New models (opt-in) | — | — | Enabled via quickbooks__tax_lines_enabled: true and using_estimate_tax_line: true. See the README for details.
|
Feature Updates
Exchange Gain/Loss
- Adds the ability to realize exchange gain/loss entries to
int_quickbooks__bill_payment_double_entryandint_quickbooks__payment_double_entry, which populate inquickbooks__general_ledgerandquickbooks__general_ledger_by_period, to capture the currency impact when a foreign currency transaction is settled at a different exchange rate than when it was originally recorded. Requires an account with a subtype ofExchangeGainOrLossin QuickBooks to generate entries. - Adds the
quickbooks__exchange_gain_loss_enabledvariable (defaultfalse) to opt into exchange gain/loss entry generation. Enable this if your QuickBooks data includes multi-currency transactions and you have anExchangeGainOrLossaccount configured. See the README for configuration details.
Full Changelog: v1.8.1...v1.9.0