[Bug] quickbooks__profit_and_loss table is missing data

[Brianm0440]

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.

[fivetran-reneeli]

Hi @Brianm0440 thanks for bringing this to our attention! It would be helpful to get more detail about these accounts that are not tying out since we don't have the visibility. For instance are they all revenue-related accounts or is there anything else they all have in common.

By the way, I noticed you're on an older version of the package. I'd suggest upgrading to the newest 14.1

[fivetran-catfritz]

Hi @Brianm0440 just checking in if you were able to take a look at this issue again.

Also it would be helpful if you open a support ticket (link) and let them know I directed you there from this issue. That would provide a way for us to work more directly with your data!

[Brianm0440]

Hello,

Thanks for the suggestion to update the Fivetran model version. I completed that step, but we are still noticing differences. The GL accounts where differences are noticed are revenue related. We haven't seen any balance differences with Expense accounts or balance sheet accounts. But a few revenue accounts are off, and only for a few specific months.

I will open a ticket using the link you provided.

Best, Brian

On Thu, Aug 22, 2024 at 3:03 PM fivetran-catfritz @.***> wrote:

Hi @Brianm0440 https://github.com/Brianm0440 just checking in if you were able to take a look at this issue again.

Also it would be helpful if you open a support ticket (link https://support.fivetran.com/hc/en-us) and let them know I directed you there from this issue. That would provide a way for us to work more directly with your data!

— Reply to this email directly, view it on GitHub https://github.com/fivetran/dbt_quickbooks/issues/139#issuecomment-2305825590, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAWOM4SWISZNFDGLFPXREMLZSZNZXAVCNFSM6AAAAABMNTU7VWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMBVHAZDKNJZGA . You are receiving this because you were mentioned.Message ID: @.***>

[fivetran-catfritz]

Thanks @Brianm0440. Let me know your ticket number once it's opened!

[fivetran-catfritz]

Hi @Brianm0440 just checking in if you were able to open the ticket. Thank you!

[Brianm0440]

Yes, the ticket was opened. Here is the link:

https://support.fivetran.com/hc/en-us/requests/219930 ticket#219930

On Wed, Sep 4, 2024 at 2:21 PM fivetran-catfritz @.***> wrote:

Hi @Brianm0440 https://github.com/Brianm0440 just checking in if you were able to open the ticket. Thank you!

— Reply to this email directly, view it on GitHub https://github.com/fivetran/dbt_quickbooks/issues/139#issuecomment-2330168725, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAWOM4VPCSX2VJOVRRFZX6DZU52W5AVCNFSM6AAAAABMNTU7VWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMZQGE3DQNZSGU . You are receiving this because you were mentioned.Message ID: @.***>