Purchases by Product Report

From Opentaps Wiki

This report shows the total purchases for each product for your company during a period of time.

The parameters of the report are:

• from and through date: by default, these are filled in for the last 30 days.
• supplier party ID: you can filter the report optionally by specifying a supplier's unique ID, which you can use the lookup widget to find. This will show you only the products purchased from this supplier during the specified time. Is left empty, the report will show products purchased from all suppliers.

The system will search through all purchase orders of your organization with order date that fall within the from and through dates specified. It will include all purchase orders, which were not canceled or rejected. It would not include any purchase orders, which are for another organization. The report will show the following columns:

• internal name and ID of the product
• quantity purchased, or original order quantity, minus any canceled quantity
• total value of purchases