Customer sales report

SUGGESTED

I am trying to create a report that will list each customer's total sales for year.  I do not need the invoice details, only the summary of their sales.  I would like it to be sorted based on highest sales first.  that is to have to the customer with the highest dollar sales listed first.  I need this for years 2011 through 2015.

  • 0
    SUGGESTED
    Standfas-
    In the current Sage BusinessWorks program, there is no report that stores the information you are looking for and for the time period you need. The only report I could suggest in Sage BusinessWorks is the AR, Reports, Sales Analysis Report by Customer. This report can be run by Summary. You can select your time periods.

    If you are familiar with the field names, Sage BusinessWorks does store Customer History but only for the last 12 months. For assistance on table and field names, you may want to refer to KB article #19339 “Where do I find the table and field names?”

    If you are looking for a report that gives you a summary of the customer sales by month and or by year, then that would need to be customized. You would need to create a report by invoice detail to get the sales, then do formulas to calculate and summarize for you. When creating a custom report for you company, you may want to refer to KB article #19339 “Where do I find the table and filed names?”

    If you are looking for someone to help you customize a report, you can contact our client care department at 800-447-5700 to find a reseller in your area who you can work with to customize a report for you.

    Thanks,
    Coleen