Please provide your name and company
randy/Jared, lyrahealth
Link the issue/feature request which this PR is meant to address
mutl-books
Our Netsuiite has two books enabled: primary and adjustment. The adjustment book includes all transactions on primary + additional transactions. That relationship between books is noted in the database by the fields is_primary and adjustment_only.
currently the models don't let user to choose which book to use. this PR will add it.
converted_amount formula fixes
Detail what changes this PR introduces and how this addresses the issue/feature request linked above.
adding accounting_book_id for the 3 final models
fix on converted_amount formula
How did you validate the changes introduced within this PR?
we have validated results by building in our datawarehouse
Which warehouse did you use to develop these changes?
snowflake
Did you update the CHANGELOG?
[ ] Yes
Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)
[ ] Yes
Provide an emoji that best describes your current mood
:dancer:
**Feedback**
We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next.
**PR Template**
- [Community Pull Request Template](?expand=1&template=pull_request_template.md) (default)
- [Maintainer Pull Request Template](?expand=1&template=maintainer_pull_request_template.md) (to be used by maintainers)
Please provide your name and company randy/Jared, lyrahealth
Link the issue/feature request which this PR is meant to address
currently the models don't let user to choose which book to use. this PR will add it.
Detail what changes this PR introduces and how this addresses the issue/feature request linked above.
How did you validate the changes introduced within this PR? we have validated results by building in our datawarehouse
Which warehouse did you use to develop these changes? snowflake
Did you update the CHANGELOG?
Did you update the dbt_project.yml files with the version upgrade (please leverage standard semantic versioning)? (In both your main project and integration_tests)
Provide an emoji that best describes your current mood
:dancer: **Feedback** We are so excited you decided to contribute to the Fivetran community dbt package! We continue to work to improve the packages and would greatly appreciate your [feedback](https://www.surveymonkey.com/r/DQ7K7WW) on our existing dbt packages or what you'd like to see next. **PR Template** - [Community Pull Request Template](?expand=1&template=pull_request_template.md) (default) - [Maintainer Pull Request Template](?expand=1&template=maintainer_pull_request_template.md) (to be used by maintainers)