Anyone know how I can make a sales report that contains a sales reps sales within a given time frame, including item price, with tax if any, and tender type (basically the entire sale rung up). I am trying to run a report that shows how much we are putting on types of credit cards, Visa, MasterCard, Discover, cash, etc. Would like to know the SQL statements that are needed to do so.
Jack,
Are you asking for 2 reports or a single one?
The second, how much for each tender types, you have already have, if you separate out your credit card tenders. A tender for MC, a separate for VISA, etc.
SO Manager | Reports | Misc | Tender Summary | then collapse grouped rows, the 8th icon on top or press Ctrl+O.
Jack to add Sales Person and Tender to a report you need to add these tables: LEFT JOIN SalesRep WITH(NOLOCK) ON TransactionEntry.SalesRepID = SalesRep.ID LEFT JOIN TenderEntry WITH(NOLOCK) ON TransactionEntry.TransactionNumber TenderEntry.TransactionNumber LEFT JOIN Tender WITH(NOLOCK) ON TenderEntry.TenderID = Tender.ID
Then add the Tender.Description and SalesRep.Name columns to the report.
Rob
"Jack T" wrote:
Try modifying the Detailed Sales report or the Detailed Sales Report with Return Values, I tried it by adding the code below and adding the columns and it worked.
Rob
"Jack T" wrote:
Jack,
Find a Custom - Detailed Sales with Return Values (Tax-Inclusive) attached. Includes the tender type, sales person, total sale with tax
In order to see Jeff's attachment you would have to use a News Reader (i.e. Outlook Express). You can add these columns to your report, make sure you put the Formula on one line.
Rob
Beg> Jeff,
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.