Sales per product (Reports menu)

Parent Previous Next

You may print the following two (2) reports to analyze your invoices and credit notes.

1.Sales per product - Inventory group 1

2.Sales per product - Inventory group 2

This report only includes Invoices and Credit notes which are posted. Unposted Invoices and Credit notes 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 → Sales analysis → Sales per product.

2.Select the following:

a)Report - Select the Sales per product - Inventory group 1 (default) or Sales 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, selling prices, cost prices, profit / loss and profit loss percentage of each inventory item in posted invoices and credit notes. If this option is selected, it will display a list of document numbers, account code and description and the quantities, selling prices 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 Sales per product - Inventory group 1 (no details) report, is as follows:

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

Page 1

Page 2

Created with the Personal Edition of HelpNDoc: Easily create Web Help sites