[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 classProblem 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. Solution:You can refer SalesByCustomerDetail for the required details. Please refer below 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 report is available you can refer below listed report: SalesByCustomerSummary, SalesByItemDetail, SalesByItemSummary, SalesByRepDetail, SalesByRepSummary Also Refer: How to use the QuickBooks Reporting Engine with QODBC 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.
| |
|