You may print the following two (2) reports to analyse the purchase and supplier return documents to analyse your purchases. 

1.Purchases per Product - Stock group 1

2.Purchases per Product - Stock group 2

This report only includes Purchase and Supplier return documents which are posted. Unposted Purchase and Supplier return documents will be NOT be included in this report.

This report only includes the default stock item type. It does not include any other stock item types (e.g. ten (10) stock item types i.e. Sales, Sales (no stock), Purchases, Purchases (no stock), Financial entry, Option item, Option item (no stock), BOM (Bills of Materials), BOM (Production), Linked Sale).

Report options

To print Purchases per product - Stock group reports

1.On the Reports ribbon, select Reports → Purchase analysis → Purchases per product


2.Select the following:

a)Report - Select the Purchases per product - Stock group 1 (default) or Purchases per product - Stock group 2 report. 

b)Period - Select the period on the Per period tab. You may click on the Free selection tab to select a specific date or a range of dates.

c)From... To... - Select the stock code(s) to include in the report. 

d)Reporting group 1 - This is optional and by default not selected (not ticked). You may select (tick) the reporting group(s) to include in the report. This "Reporting group 1" is only applicable to "Stock group 1

e)Sequence - Select "Stock code" or "Stock description" to sort the order in which you need to print the data.  

f)Show details - By default, this option is not selected. It will display the total quantities and cost prices of each stock item in posted purchase and supplier return documents. If this option is selected, it will display a list of document numbers, account code and description and the quantities and cost prices for each document.  

g)New page per item - If this option is selected (ticked), it will print the transactions for each product (stock item) on a new page. If supplier returns are applicable to a Stock item, the supplier returns will be printed on a new page.

The Company details will not be printed as in the Page header. The company name is displayed in the Page footer.

It is recommended that this option is only selected if the Show details option is selected.

3.Click on the OK button. 

Printed example : Purchases per product - Stock group 1

An example of the "Purchases per product - Stock group 1" (no details) report, is as follows:purchase-analysis-group-product-print

Printed example : Purchases per product - Stock group 1 : Show details

An example of the "Purchases per product - Stock group 1" ("Show details" option selected) report, is as follows: