Sales Summary - Management Reports Sales Analysis Tab

The Sales Analysis screen shows sales and returns by customer, based on the filters you select. You can analyse the results by week, month or quarter and display values, quantities or both.

The screen consists of filters at the top and a results grid below.
Important: After changing your filters or options, click Refresh to update the grid.
You can also group the information in the grid to make larger sets of results easier to analyse. For details, see Grouping in Grids.

Filters and Display Options

Filters

Use the Filters button to choose which sales information you want to include. See Available Filters below for the options available.
Delivery charges: If Issued Only is selected, the results include delivery charges where applicable. If Sales Orders is selected, delivery charges are not included in the totals.

UDA Filters

You can also filter the results using UDA information recorded against a company.

Row Height

Use the Row Height spinner to change the height of the rows and their charts. You can set the height between 18 and 300 points.

Net

Net is selected by default. When selected, values in the grid are shown excluding VAT.

Period

Choose how the selected date range is divided into columns:
  • Weekly – the default.
  • Monthly
  • Quarterly
The period columns displayed in the grid depend on both the date range selected in the filters and the period you choose.

Amounts

Choose what you want to display for each period:
  • Amount – displays the value for each period. This is the default.
  • Qty – displays quantities for each period.
  • Both – displays both values and quantities.

Available Filters

The following filters are available from the Filters button:
  • Agent (Customer) – filters by the default agent recorded against the customer in the Lookup Data Area on [ Customer | Detail | General ]. You can select more than one agent.
  • Agent (Sales Order) – filters sales orders according to the agent recorded against the order. You can select more than one agent.
  • Brand – shows orders for the selected brand.
  • Classification – shows orders where the customer belongs to the selected classifications.
  • Company Type – shows orders for customers of the selected company type.
  • Date – filters invoices or sales orders using a date range. Use the date range options to the right of the filter popup to specify how the date is applied.
  • Sales Source – shows orders with the selected sales source recorded against them.
  • Stock Code – shows orders containing the specified stock code.
  • Stock Item – shows orders containing the selected stock item.
  • Stock Type Type – shows orders containing stock belonging to the selected Level 1 stock type.
  • Stock Type – shows orders containing items belonging to the selected Level 2 stock type.
  • Stock Mid Type – shows orders containing items belonging to the selected Level 3 mid-type.
  • Stock Sub Type – shows orders containing items belonging to the selected Level 4 sub-type.
  • Supplier – shows orders containing items associated with the selected supplier.
  • URN – filters by the company's URN.
Note: Unlike the stock type filters on other Sales Summary screens, the stock type filters in Sales Analysis allow you to select more than one stock type. You can also invert your selection.

Filter Right-Click Options

Additional options are available when you right-click a filter. The options available depend on the type of filter you are using:
  • Refresh – updates the options available in the filter, for example after new options have been added.
  • Show All – displays all possible options, including inactive or expired entries where applicable.
  • Set Date Value – lets you set the required date value for a date filter.
  • Clear – removes the current or default selection, such as a default date.
  • Select All – selects all available checkbox options.
  • Select None – clears all checkbox selections.
  • Invert Selection – reverses the current selection. Selected options become unselected and unselected options become selected.

Sales Analysis Grid

After setting your filters and refreshing the results, the grid displays the following information.
  • URN – the customer's company URN.
  • Company – the company name.
  • Company Class – the customer's company classification.
  • Company Type – the customer's company type.
  • Total – the overall total for the period columns. This shows value, quantity or both, depending on the Amounts option selected.
  • Chart – provides a visual representation of the periods in which the customer ordered or returned items.
    • A positive overall value appears as a green block above the line.
    • A negative overall value, such as returned items, appears as a red block below the line.
  • Period columns – the number and headings of these columns depend on your selected date range and whether you are viewing the results weekly, monthly or quarterly.
Totals are displayed at the bottom of the grid.

Viewing Large Totals

If a Total cell at the bottom of the grid has a red background, the value is too large to display within the current column width.

To see the complete value:
  • Click and drag the column heading to make the column wider, or
  • Use Resize Column from the Grid Menu.

Sales Analysis Grid Context Menu

Right-click within the Sales Analysis grid to access additional options:
  • Goto Customer – opens [ Customer | Detail | General ] for the selected customer.
  • Add to/open List Manager – adds the selected customer, or selected group of customers, to List Manager.
  • Clear Selection – deselects the currently selected line or lines.

See Also


Did you find this article helpful?