Purchases per product (Reports menu)

Parent Previous Next

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).

To print Product by 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.

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 account - If this option is selected (ticked), it will print the transactions for each account 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.

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

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

Created with the Personal Edition of HelpNDoc: Free HTML Help documentation generator