[QODBC-Desktop] Troubleshooting - Is there a Sales journal report by class
Posted by Jack - QODBC Support on 07 March 2017 07:10 AM
Troubleshooting - Is there a Sales journal report by class
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.
You can refer SalesByCustomerDetail for the required details. Please refer below sample query for the same.
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 report is available you can refer below listed report:
SalesByCustomerSummary, SalesByItemDetail, SalesByItemSummary, SalesByRepDetail, SalesByRepSummary
You can find most of QuickBooks report using 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, parameters which are supported.