Knowledgebase: QODBC
[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

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.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).