When I operate the sales reports in QB it includes the credits, and sales receipts.

What files do I access so I can get the information, combined, so I can write a report that includes all these 3 types of sales?  Currently my report works great but only with invoices.  Is there ONE file I can look at which will retrieve all the sales data from all 3 files, or must I "SELECT" 3 different files and combine them myself?

If I must use 3 different files, what is the select statement I would use to "join" the 3 files together so they sort by rep, and then by date.

I am using Crystal Reports to generate the reports, so realistically I cannot just create my own SELECT statement but instead must link the 3 files together (which I am also not sure how to do in Crystal)

Thanks

Victor Nahigian

Try running the following report directly in Crystal Reports using the "Add Command" procedure:

sp_report SalesByRepDetail show TxnType_Title, Date_Title, RefNumber_Title, Memo_Title, Name_Title, Item_Title, Quantity_Title, UnitPrice_Title, Amount_Title, RunningBalance_Title, Text, Blank, TxnType, Date, RefNumber, Memo, Name, Item, Quantity, UnitPrice, Amount, RunningBalance parameters DateMacro = 'ThisMonthToDate'

See: How do I use QODBC with Crystal Reports? for more information.