dbt 0.20.0 Compatibility

🎉 dbt 0.20.0 Compatibility 🎉

🚨 This is a breaking change! 🚨 dbt v0.20.0 or greater is required for this release. If you are not ready to upgrade, consider using a previous release of this package.

Additional considerations when upgrading to this package:

• This package utilizes the latest v0.7.0 release of the dbt-labls/dbt_utils package. If your project also utilizes a version of the fishtown-analytics/dbt_utils package then you will receive a duplicate package error. If this is the case you will need to consider upgrading your other packages to be compatible with this update or use a previous release of this package.
• Similar to the above point, all previous Fivetran dbt packages utilize the fishtown-analytics/dbt_utils package and you will need to upgrade all Fivetran dbt packages to the latest dbt 0.20.0 compatibility releases in order for your packages to run without package conflicts.

Customer and Vendor Addition to GL

🎉 General Ledger Customer and Vendor Addition Enhancement 🎉

This release introduces the following non-breaking enhancements:

• Addition of the customer_id and vendor_id to the quickbooks__general_ledger model. These fields can be used to join accompanying customer and vendor information into transaction lines related to the customer or vendor. Issue #18

Rounding bug fix and account_id addition

This PR includes the following non-breaking changes:

• Addition of the account_id field into the quickbooks__profit_and_loss and quickbooks__balance_sheet models. Issue #20
• Fixes a rounding bug which occurs within Snowflake warehouses. Issue #21

Postgres Rounding Fix

This release includes the following non-breaking changes:

• Removes the rounding syntax within models to be compatibile with Postgres and other databases. Issue #13

Postgres Compatibility and Address Variable

This release includes the following non-breaking changes:

• Incorporates Postgres compatibility and added Postgres testing to CircleCi. Issue #10
• Adds a variable to disable address fields in downstream models. Issue #11

P&L and Balance Sheet Additions

🚨 This update introduces breaking changes in the form of custom schemas which output final models into a respective <target.schema>+_quickbooks schema. Refer to the ReadMe for more details. 🚨

The release also:

• Includes the addition of the quickbooks__profit_and_loss as well as the quickbooks__balance_sheet models which address Issue #5.
• Updates to the int_quickbooks__account_classifications model for parent account recognition.
• Applies minor documentation updates.

Sales Receipt Variable and Transaction Line Updates

This release contains the following non-breaking changes:

• Addition of the using_sales_receipt variable to disable in downstream models.
• Changes to capture all customer and account id's within the transaction_line models for bills, invoices, purchases, and vendor credits.

Documentation and Formatting Fixes

This release does three things:

• Removes an unnecessary comment within the int_quickbooks__credit_memo_double_entry model.
• Corrects an indented where clause within the int_quickbooks__invoice_double_entry model.
• Fixes the account_id coalesce within the int_quickbooks__invoice_transactions model to appropriately search the expense account before the asset account reference for an invoice.

Initial Release

This is the initial release of the QuickBooks transform package!

The main focus of this package is to provide users insights into their QuickBooks data that can be used for financial statement reporting and deeper analysis. The package achieves this by:

• Creating a comprehensive general ledger that can be used to create financial statements with additional flexibility.
• Providing historical general ledger month beginning balances, ending balances, and net change for each account.
• Enhancing Accounts Payable and Accounts Receivables data by providing past and present aging of bills and invoices.
• Pairing all expense and sales transactions in one table with accompanying data to provide enhanced analysis.

Currently the package supports Redshift, BigQuery, and Snowflake.