Troubleshooting - Is there a Sales journal report by class

Problem Description:

For months I've been trying to get a Sales journal report. All I seem to get is either too detailed (by items) or too summary (sum by customer). I need a list of invoices by class.

A report by class showing CLASS, Inv #, Inv DATE, CUSTOMER NAME, Inv TOTAL AMT).

All I seem to get is either too detailed (by items) or too summary (sum by customer).

I haven't been able to figure out how. I'm extracting this info from a GL data dump, but I have to use lots of code and work around.

Is there such a report?

Solution:

You can refer SalesByCustomerDetail for the required details. Please refer to the sample query for the same.

For Example:

sp_report SalesByCustomerDetail show Text, Blank, TxnType, Date, RefNumber, Memo, Name, Item, Class, Quantity, UnitPrice, Amount, RunningBalance parameters DateMacro = 'ThisMonthToDate.'

Also, There are other Sales reports available you can refer below-listed reports:

SalesByCustomerSummary, SalesByItemDetail, SalesByItemSummary, SalesByRepDetail, SalesByRepSummary

Also Refer: How to use the QuickBooks Reporting Engine with QODBC

You can find most of the QuickBooks report using the above link. You can change report parameters as per your requirement.

Also, Refer QODBC table & report schema site to get details about each report column and supported parameters.