Purchases per product (Reports menu)

Parent Previous Next

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

1.Purchases per Product - Inventory group 1

2.Purchases per Product - Inventory 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 inventory item type. It does not include any other inventory item types (e.g. ten (10) inventory item types i.e. Sales, Sales (no inventory), Purchases, Purchases (no inventory), Financial entry, Option item, Option item (no inventory), BOM (Bills of Materials), BOM (Production), Linked Sale).

To print Product by Inventory 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 - Inventory group 1 (default) or Purchases per product - Inventory 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 inventory 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 "Inventory code or Inventory 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 inventory 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 - Inventory group 1 (no details) report, is as follows:

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

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