Available in Sage 50 Premium Accounting and higher.

Closed

Modify a Customer Analysis Report

ClosedBefore you can perform this task 

Select the Customer Analysis report you want to modify:

ClosedCustomer Analysis Summary

  1. In the Home window, open the Report Centre. Select Forecasts and Analysis and then Customer Analysis Summary. Click Modify this report.
  2. (Optional) Select the Template you want to use for the report.
  3. Enter Start and Finish dates for the report.
  4. Select the ranking method you want to use: Revenue, Quantity, Profit, or Return On Investment.
  5. Select either Top or Bottom and enter the percentage of your customers the report should display.

(Optional) Select Include Customers With No Transactions to include customers who have not made a purchase within the reporting period.

  1. Select the sales items you want to report on:
    1. Inventory & Service items
    2. Other items - includes all goods and services not in the Inventory & Services List, such as items without an inventory record that are entered on an invoice, or items that have been deleted from your inventory list
  2. (Optional) Select Include inactive items. This is available only if you have included inventory and service items in the report.
  3. If you are including inventory and service items in the report, select the items. Click Select All to report on all items in the list.
  4. (Optional) Select Show location information, if you are using multiple locations and click Select Locations.
  5. (Optional) Customize the:
  6. (Optional) Save the report as a template in My Reports.
  7. Click OK to display the report.

ClosedCustomer Analysis Detail

  1. In the Home window, open the Report Centre. Select Forecasts and Analysis and then Customer Analysis Detail. Click Modify this report.
  2. (Optional) Select the Template you want to use for the report.
  3. Enter Start and Finish dates for the report.
  4. Select the ranking method you want to use: Revenue, Quantity, Profit, or Return On Investment.
  5. Select either Top or Bottom and enter the percentage of your customers the report should display.

(Optional) Select Include Customers With No Transactions to include customers who have not made a purchase within the reporting period.

  1. Select the sales items you want to report on:
    1. Inventory & Service Items
    2. Other Items - includes all goods and services not in the Inventory & Services List, such as items without an inventory record that are entered on an invoice, or items that have been deleted from your inventory list
  2. Inventory & Service Items, Other Items, or both. Other items are items that you have entered manually on an invoice, but have never entered into your inventory records.
  3. (Optional) Select Include inactive items. This is available only if you have included inventory and service items in the report.
  4. If you are including inventory and service items in the report, select the items. Click Select All to report on all items in the list.
  5. (Optional) Select Show location information, if you are using multiple locations and click Select Locations.
  6. (Optional) Customize the:
  7. (Optional) Save the report as a template in My Reports.
  8. Click OK to display the report.

What do you want to do?

Change the presentation of this report in the report viewer

Print this report

View detailed information about a specific part of this report

Search for text in this report

Open this report in Microsoft Excel

Export this report to another format

Change your default printer settings for reports

Refresh this report