SQL to get sales by Supplier

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date SQL to get sales by Supplier Jason 10-21-2007  Re: SQL to get sales by Supplier Jason 10-21-2007  RE: SQL to get sales by Supplier Akber Alwan 10-22-2007
Posted by Jason on October 21, 2007, 10:49 pm Please log in for more thread options I would like to get output of total sales by supplier via SQL with output like: Supplier Name Sales --------------- -------------- If the sales can be formatted like #,###.##, that would be great. Can someone assist with the SQL query? Posted by Jason on October 21, 2007, 11:00 pm Please log in for more thread options I could also use the date and time of the output in the SQL output (FYI, I am using OSQL to output this data to a .txt file). >I would like to get output of total sales by supplier via SQL with output >like: > > Supplier Name Sales > --------------- -------------- > > > > If the sales can be formatted like #,###.##, that would be great. > > Can someone assist with the SQL query? > Posted by Akber Alwani on October 22, 2007, 1:08 am Please log in for more thread options hi Jason, Try this below is the date paramter you can enter your own date. If works rate this. Select SupplierName,Sum(TransactionEntry.Price) Sales from [Transaction] INNER JOIN TransactionEntry On [Transaction].TransactionNumber=TransactionEntry.TransactionNumber LEFT JOIN Item ON TransactionEntry.ItemID=Item.ID LEFT JOIN Supplier ON Item.SupplierID=Supplier.ID WHERE [Transaction].Time between '2007-01-01' AND GetDate() Group by SupplierName "Jason" wrote: > I would like to get output of total sales by supplier via SQL with output > like: > > Supplier Name Sales > --------------- -------------- > > > > If the sales can be formatted like #,###.##, that would be great. > > Can someone assist with the SQL query? > > > Similar Threads Posted Supplier List and Sales Report June 24, 2005, 2:26 pm Manual Purchase Orders not adding Supplier to Items Supplier List. January 23, 2006, 9:20 am Supplier dicounts in purchase order and Supplier dicount report April 9, 2007, 10:22 pm Discrepancies between Detailed Sales Report and Summary Sales Repo August 30, 2006, 12:37 pm RMS should record gift card sales as liabilities, not sales. December 31, 2005, 4:08 pm Error Total sales report hour sales August 14, 2006, 3:19 pm Department Sales Report (Tax Included in Sales) is wrong February 29, 2008, 6:44 pm Adding % of total sales to a sales report April 11, 2006, 6:36 pm Department Sales Report (Tax Included in Sales) April 18, 2007, 10:58 am Sales Taxes for Sales on Customer Account September 6, 2007, 3:58 pm