[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 to the 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 reports available you can refer below-listed reports:
SalesByCustomerSummary, SalesByItemDetail, SalesByItemSummary, SalesByRepDetail, SalesByRepSummary
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.