Solved

Cannot find QuickBooks Online data on reports

  • 30 March 2023
  • 1 reply
  • 35 views

Userlevel 4
Badge

Can the QuickBooks Online driver pull data on Reports? I'm not seeing the Profit & Loss report, or any other reports, in the list of tables and views.

icon

Best answer by Elizabeth G 30 March 2023, 19:58

View original

1 reply

Userlevel 4
Badge

The driver can indeed pull this data. As they use stored procedures rather than tables or views, you can run that report's stored procedure (such as CreateProfitAndLossDetailReport) to view data from that particular report. A list of stored procedures for the v22 version of the driver can be found at the link below, but the most up-to-date list will be on the documentation on the website.

https://cdn.cdata.com/help/RNH/xls/pg_allsps.htm

Reply