fivetran / fivetran/dbt_quickbooks

Quickstart transformation miscategorizes bill line

Open
#105 16 comments 0 reactions 0 assignees View on GitHub
type:wontfix
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.