Show TOC

Object documentationSales Analysis Report: Items Tab Locate this document in the navigation structure


Use this tab to specify selection criteria for the Sales Analysis by Item report, which analyzes sales either per item, or per item group. SAP Business One creates a sales volume analysis for each item.

To access the tab, choose   Sales – A/R   Sales Reports   Sales Analysis   Items.  

Alternatively, access it from the Reports module.

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Sales Analysis Items Tab Fields
Annual Report, Monthly Report, Quarterly Report

Select whether you want the report to reflect results for the entire year, per month, or per quarter.

If you select the Monthly Report or the Quarterly Report radio button, the total for the year is also displayed. In addition, if you select one of these options, you can hide empty periods by selecting the Hide Empty Months/Quarters checkbox.

Invoices, Orders, Delivery Notes

Select the document type on which you want to base the sales analysis.

Note Note

  • If you base an A/R credit memo on an A/R down payment invoice, that A/R credit memo does not appear in the report.

  • Cancelled sales orders do not appear in the report.

  • Returns are displayed as part of delivery notes and they decrease the sales amount.

End of the note.
Individual Display

Displays a report for an individual item.

No Totals

Displays one row for each item or item group in the report (this depends on the selections you have made in the Individual Display and Group Display fields).

Total by Customer

Displays a row for each combination of an item and customer (or items group and customer) in the report.

Total by Sales Employee

Display a row for each combination of an item and sales employee who sold it.

Main Selection

Specify the item range to be included in the report.

Define the item codes range, specify an item group if required, and choose Properties to use the item properties as a selection criteria.

Secondary Selection

Select to define an additional selection: by customer range, group or properties, by sales employee or both.

Display Amounts in System Currency

Displays the amounts in the system currency in the report.

More Information

Sales Analysis