Skip to main content

Reports not appearing in QuickBooks Online

  • July 18, 2023
  • 0 replies
  • 47 views

Forum|alt.badge.img

The driver can indeed pull this data, but not through typical tables or views. As they use stored procedures rather than tables or views, you can run a report's stored procedure (such as CreateProfitAndLossDetailReport) to generate an RSD schema file for that report. Once this has been done and you attempt to pull new tables from QuickBooks Online into Access, the report (such as ProfitAndLossDetailReport) will appear as a view that you can pull into Access. Upon querying this view, you will be able to see the data of that report. 

 

A list of stored procedures for the v23 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/RNJ/xls/pg_allsps.htm 

This topic has been closed for replies.