fivetran / fivetran/dbt_quickbooks
[Bug] Duplicate Entries for General Ledger Transaction ID's for two Accounts Receivable accounts
- 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
Example transaction ID 150975 has duplicate entries in Bigquery General Ledger. Account_id 501 and account_id 500 are creating duplicate entries. The data from fivetran DBT job for the General Ledger is creating duplicate data for account id 501 and is causing our data to not reconcile. When you look in Quickbooks that isn't the case. See attached screen shots and advise.

[Query Export.csv](https://github.com/fivetran/dbt_quickbooks/files/12580457/Query.Export.csv)
### Relevant error log or model output
_No response_
### Expected behavior
We would only want to have entries for Account ID 500 in the General Ledger.
### dbt Project configurations
vars:
using_credit_card_payment_txn: true
using_purchase_order: true
### Package versions
packages:
- package: fivetran/quickbooks
version: [">=0.11.0", "<0.12.0"]
### What database are you using dbt with?
bigquery
### dbt Version
dbt Version: 1.5
### Additional Context
SELECT * FROM `back-bar.prod_quickbooks.quickbooks__general_ledger` where transaction_id = '150975'
### Are you willing to open a PR to help address this issue?
- [X] Yes.
- [ ] 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
Assessment
This issue has not been assessed yet.