Closed fivetran-joemarkiewicz closed 10 months ago
Looks good, just wanted to know your thoughts if it's worth updating the ymls as well. For example, I think a lot was done under the hood for converted_amount and the balance_transactions overall, but I think the definitions still apply so it might be fine. But also could copy some of the notes from the changelog over?
Though future-looking, if the logic were to change again, now you'd have to update the yml again. So it may be best to keep the more high-level definitions that are in place.
@fivetran-reneeli great call out on if we should update the docs. Truthfully I agree with you that I would prefer not to update the docs to be hyper specific in case we end up making more modifications in the future. The description of the existing models and fields still hold true with these updates, they just are not hyper specific.
@fivetran-reneeli great call out on if we should update the docs. Truthfully I agree with you that I would prefer not to update the docs to be hyper specific in case we end up making more modifications in the future. The description of the existing models and fields still hold true with these updates, they just are not hyper specific.
Sounds good with me, let's keep the docs broad
PR Overview
This PR will address the following Issue/Feature: #78 #75
This PR will result in the following new package version:
v0.11.0
This will be a breaking change as significant updates are being applied to the code which we would like to be reflected in a major update as opposed to a patch.
Please detail what change(s) this PR introduces and any additional information that should be known during the review of this PR:
converted_amount
innetsuite__balance_sheet
andnetsuite2__balance_sheet
.general_rate_type
rather thanaccount_category
, as is intended by Netsuite definitions.converted_amount_using_transaction_accounting_period
. Otherwise, it looks atconverted_amount_using_reporting_month
.is_leftside
logic is added to make sure debit values are properly assigned as negative converted values if false and positive if true.netsuite2__balance_sheet
model to be built upon referencing that the general_rate_type is eitherhistorical
oraverage
as opposed to checking that the account_category isequity
.equity
check was not as robust as had an opportunity to generate an incorrect value.PR Checklist
Basic Validation
Please acknowledge that you have successfully performed the following commands locally:
Before marking this PR as "ready for review" the following have been applied:
Detailed Validation
Please acknowledge that the following validation checks have been performed prior to marking this PR as "ready for review":
We were able to validate these changes with our internal data and confirmed the totals matched our expected results.
Standard Updates
Please acknowledge that your PR contains the following standard updates:
dbt Docs
Please acknowledge that after the above were all completed the below were applied to your branch:
If you had to summarize this PR in an emoji, which would it be?
💵