fivetran / fivetran/dbt_quickbooks
[Bug] quickbooks__profit_and_loss table is missing data
- Dominant language
- No language data
- Stars
- 41
- Forks
- 46
- 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
We are trying to tie out the result of quickbooks__profit_and_loss, compared to the quickbooks online profit and loss report, and there are some discrepancies. In one case an account number doesn't appear at all in the table, and in another case a revenue account is incorrect, for a single month. I suspect it's not capturing some record deletes correctly.
account_number = '4310' does not appear in the quickbooks__profit_and_loss table, even though it is present in Quickbooks.
### Relevant error log or model output
_No response_
### Expected behavior
The quickbooks__profit_and_loss table should match the QBO p&l report
### dbt Project configurations
We use the fivetran transformation. We did not deploy this DBT model independently.
### Package versions
0.13.1
### What database are you using dbt with?
bigquery
### dbt Version
0.13.1
### Additional Context
_No response_
### Are you willing to open a PR to help address this issue?
- [ ] Yes.
- [X] Yes, but I will probably need assistance.
- [ ] No.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by inspecting the quickbooks__profit_and_loss dbt model and comparing account 4310 and the incorrect revenue account with the QuickBooks Online report for the affected month. Trace whether deleted source records are handled, then verify that the transformed table matches the report for those accounts.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- google-cloud
- Domain
- data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100