Quickbooks Online Class Mapping

Question

I have connected Power BI desktop to my Quickbooks Online data and really like the stock reporting, however I need more detail.&nbsp; Specifically adding class level reporting to my income statements.&nbsp; Has anyone sucessfully mapped the class field to the General Ledger table?&nbsp; Thank you.

anonymous · Answer

Hi&nbsp;bmaupin&nbsp;,Please check the following documentations, hope they can help you.https://community.powerbi.com/t5/Desktop/Quickbooks-Online-General-Ledger-Table-is-gone/m-p/905685https://www.cdata.com/kb/tech/quickbooks-odbc-power-bi.rsthttps://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/generalledgerBest RegardsRena

anonymous · Answer

Good day&nbsp;Please let me know if you have any solution on Mapping the Class to the Income and Expenses.&nbsp; How is the Class Fields map to the Income and Expenses transactions?&nbsp;&nbsp;

mneville · Answer

bmaupin&nbsp;were you&nbsp;able to do this?&nbsp; I'm not seeing class as a column in the General Ledger table.

bmaupin · Answer

MNeville&nbsp;We did ultimately add class through a series of custom code, but then the connector was updated and the code broke.&nbsp; We moved to using Excel downloads as our source which has given us a greater degree of customizations and reporting detail than we previously experienced.&nbsp;&nbsp;

Forum Discussion

Quickbooks Online Class Mapping

4 Replies

Related content

QuickBooks Online Beta Connector Error

Power BI to Quickbooks Online Error

Quickbooks Online stopped connecting

Alternatives to QuickBooks connector post deprecation

Quickbooks online connector - Data Factory