Joe Chevalier
Joe Chevalier
Been waiting for this. Hopefully gets merged soon.
The root cause is actually multiple accounts with the account type "Accounts Receivable" when int_quickbooks__invoice_double_entry.sql runs it does a join on ar_accounts. If there are multiple accounts with the type...
Even after consolidating AR Accounts into one the DescriptionOnly lines cause issue. My suggestion would be to exclude these in the main branch as I've done above.
The larger issue is that multi-currency accounts can have multiple AP and AR accounts to support different currencies. This results in a wildly inaccurate balance sheet as transactions on the...
@fivetran-jamie Happy to assist in testing as work is complete. I have access to multi-currency quickbooks file and can run branches for testing. The largest issue I see right now...
@fivetran-jamie happy to schedule a call.
@fivetran-joemarkiewicz Good to hear you guys are approaching it the more robust way and trying to extract the mapping data from the api.