fivetran / fivetran/dbt_quickbooks

[Bug] Duplicate Entries for General Ledger Transaction ID's for two Accounts Receivable accounts

Open
#104 9 comments 0 reactions 0 assignees View on GitHub
type:bug 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

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.

![ss](https://github.com/fivetran/dbt_quickbooks/assets/112642463/c7a258fe-538d-41ed-be0f-addf7282413b)
[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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.