Quickbooks Online Class Mapping

[bmaupin]

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

[MNeville]

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

[bmaupin]

@MNeville We did ultimately add class through a series of custom code, but then the connector was updated and the code broke.  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.  

[JohannMor]

Good day 

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

[v-yiruan-msft]

Hi @bmaupin ,

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/905685

https://www.cdata.com/kb/tech/quickbooks-odbc-power-bi.rst

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/generalledger

Best Regards

Rena