fivetran / fivetran/dbt_quickbooks
Quickstart transformation miscategorizes bill line
- Dominant language
- No language data
- Stars
- 41
- Forks
- 48
- PR merge metrics
- No merged PRs in 30d
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### 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
```shell
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?
- [ ] Yes.
- [X] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [ ] No.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by locating the GENERAL_LEDGER transformation and the Bill Line table in the QuickBooks dbt project, then trace how account inference currently uses the parent Bill. Check how ACCOUNT_EXPENSE_ACCOUNT_ID is represented in the Snowflake data. Done means directly associated Bill Line accounts override the parent Bill account and the resulting categorization matches the expected output.
Written by the indexing model from the issue text.
Assessment
- Domain
- data, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100