How can I create a sales by quarter report?

Question

Column one is Client name, column two is sum of sales for first quarter, column three is sum of sales for second quarter, then third, then fourth quarter. 
 Thanks for any help!

datasoft · Answer

I don't believe there is anyway to group the columns like you want inside the standard Sage 50 product. 
 Option A) You could create an Excel spreadsheet and use the Customer Sales History report to print the Quarters totals by date range, then move those columns into your spreadsheet. I know this is not ideal but it is one work around. 
 Option B) DataSoft has a custom report writer (DSStudio) that we could develop this report for you. This of course would provide a simple way to generating the report, you would also have more say on report options, example: exclude freight, sales tax, customer ranges, custom date ranges, etc... 
 
 Here is a link to our report Customer Sales Totals 4 Timeframes 
 If you are interested please feel free to contact us through our website: https://dscorp.com 
 Regards

Sage 50 US

How can I create a sales by quarter report?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING