Is there an existing issue for this?
Describe the issue
I am working with a customer to bring in Quickbooks data by GL.
I see a transaction the GENERAL_LEDGER transformation as being associated with Account 7410, but in Quickbooks it is clearly classified as 7620.
I believe this is because the inference of the account via the item number associated with the bill line is not happening or is happening incorrectly. The Bill itself is associated with account 7410, but the Bill Line in question is a specific item that should be categorized as 7620.
Relevant error log or model output
As described above, there is a diff where more transactions that expected are being categorized in account 7410, since bill lines that are directly associated with an account are not being categorized as such
Expected behavior
Use the ACCOUNT_EXPENSE_ACCOUNT_ID column on Bill Line table to associate bill line items with accounts as part of the transformations, instead of only relying on the parent bill. line items with direct associations to accounts should override their parent bill.
dbt Project configurations
I'm using Fivetran's quickstart transformations for Quickbooks
Package versions
I'm using Fivetran's quickstart transformations for Quickbooks
What database are you using dbt with?
snowflake
dbt Version
I'm using Fivetran's quickstart transformations for Quickbooks
Additional Context
No response
Are you willing to open a PR to help address this issue?
Is there an existing issue for this?
Describe the issue
I am working with a customer to bring in Quickbooks data by GL.
I see a transaction the GENERAL_LEDGER transformation as being associated with Account 7410, but in Quickbooks it is clearly classified as 7620.
I believe this is because the inference of the account via the item number associated with the bill line is not happening or is happening incorrectly. The Bill itself is associated with account 7410, but the Bill Line in question is a specific item that should be categorized as 7620.
Relevant error log or model output
As described above, there is a diff where more transactions that expected are being categorized in account 7410, since bill lines that are directly associated with an account are not being categorized as suchExpected behavior
Use the
ACCOUNT_EXPENSE_ACCOUNT_IDcolumn on Bill Line table to associate bill line items with accounts as part of the transformations, instead of only relying on the parent bill. line items with direct associations to accounts should override their parent bill.dbt Project configurations
I'm using Fivetran's quickstart transformations for Quickbooks
Package versions
I'm using Fivetran's quickstart transformations for Quickbooks
What database are you using dbt with?
snowflake
dbt Version
I'm using Fivetran's quickstart transformations for Quickbooks
Additional Context
No response
Are you willing to open a PR to help address this issue?