Show TOC

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

 

Use this tab to specify selection criteria for the Purchase Analysis by Items report. This report lets you analyze purchases either per item or per item group. SAP Business One creates a purchase volume analysis for each item.

Note Note

Service invoices are not included when you run the Purchase Analysis by Items report.

End of the note.

Use this tab to create a purchase analysis per item or item group.

To access the tab, choose   Purchasing – A/P   Purchasing Reports   Purchase Analysis   Items  , or open 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.
Items Tab Fields
Annual Report, Monthly Report, Quarterly Report

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

If you select the Monthly Report or the Quarterly Report radio buttons, the total for the year is also displayed. In addition, if you select one of those options, you can hide empty periods by selecting the Hide Empty Months/Quarters checkbox.
A/P Invoices, Purchase Order, Goods Receipt PO

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

Note Note

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

  • Cancelled purchase orders do not appear in the report.

  • Goods returns are displayed as part of the Goods Receipt PO, and they decrease the purchased amount.

End of the note.
Individual Display, Group Display

Select whether you want to display the report for an individual item or for item groups.

Selecting the group option, displays each item group in a separate row in the report. To display the purchase for each item in an item group, double-click the row number of the respective item group.
No Totals

Displays one row for each item or item group (depending on whether you selected Individual Display or Group Display).
Total by Vendor

Displays a row for each combination of item (or item group) and vendor from whom you bought that item.
Total by Sales Employee

Creates a row for each combination of item and sales employee who bought the item.

Main Selection: Item

Specify the item range to include in the report.

Define the item codes range, specify an item group by clicking if required, and choose Properties to use the item properties as the selection criterion.
Secondary Selection

Offers additional selections: by vendor range, group or properties, by sales employee, or both.

Vendor

Enter the vendor code range to be included in the report.

Define vendor code ranges, specify a vendor group if required, and choose Properties to use the vendor properties as a selection criterion.

Sales Employee

Specify the range of sales employee codes to include in the report.
Display Amounts in System Currency

Select to display the amounts in the system currency.

More Information

Purchase Analysis – Selection Criteria