Any way to pull in basic Quickbooks records? (Customers, Vendors, etc.)
I can't find a way, using either of the included Quickbooks Online connectors, to pull basic lists of records from Quickbooks -- e.g., my Customer list, my Vendor list, Sales Receipts, etc. All I see are reports, which are nice but don't necessarily include all the data I would need. For example, a G/L report doesn't include certain details from Sales Receipts (like payment method) that I would like to be able to report on.
Am I missing something that's totally obvious or are the Quickbooks connectors really this limited?
Comments
-
I'm looking closer and seeing that my first post was a little too general. The basic QB connector does seem to have access to most, if not all, transaction records (Sales Receipts, Bills, Purchases, Journal Entries, etc.). And also Accounts from the chart of accounts. But not Customers or Vendors... anyone know of a workaround for pulling full Customer or Vendor detail into Domo through one of the built-in QB connectors?
I tried running a Customer Balance Summary report through the Advanced connector but that apparently only pulls Customers who actually have a balance, and it doesn't provide detail (such as billing address).
One of the things that really frustrates me about Quickbooks at this time of year (tax time) is that there is no built-in report that shows sales by customer location. I was hoping to use Domo to help me with that but no luck there either, apparently. ?
0 -
I have built a custom Python script to pull any table or report from Quickbooks and dump to a CSV file. I then use Domo Workbench to push the CSV file to Domo. Let me know if you are interested.
0 -
I agree with OP. We would love to have the customer table as part of the out of box connector.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 743 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive