Skip to content

v0.11.0 dbt_netsuite

Compare
Choose a tag to compare
@fivetran-joemarkiewicz fivetran-joemarkiewicz released this 18 Oct 21:16
· 84 commits to main since this release
6e8f101

PR #92 includes the following updates:

🚨 Breaking Changes 🚨:

  • This release includes a breaking change in the upstream dbt_netsuite_source dependency. Please refer to the respective dbt_netsuite_source v0.8.0 release notes for more information.

🐛 Bug Fixes 🐛:

  • Adjusted our translation rate logic to calculate converted_amount in netsuite__balance_sheet and netsuite2__balance_sheet.
    • The logic is adjusted so we examine the general_rate_type rather than account_category, as is intended by Netsuite definitions.
    • Historical and average rates now convert amounts into the converted_amount_using_transaction_accounting_period. Otherwise, it looks at converted_amount_using_reporting_month.
    • The is_leftside logic is added to make sure debit values are properly assigned as negative converted values if false and positive if true.
  • Modified the Cumulative Translation Adjustment calculation within the netsuite2__balance_sheet model to be built upon referencing that the general_rate_type is either historical or average as opposed to checking that the account_category is equity.
    • This update more accurately reflects the behavior of how the Cumulative Translation Adjustment should be calculated. The equity check was not as robust and had an opportunity to generate an incorrect value.

Contributors:

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