What's it for?
The Products Report shows you how much your total purchases were during a given period of time. It enables you to view the purchased quantity of each product, the total price paid for that product and the average price per package ordered (this is important for products with fluctuating prices).
In addition, you can compare the average price you paid for the same product purchased from different suppliers.
How to run the report:
- On the Side Menu click on Reports -> Products Report;
- You can filter the report by suppliers, dates and tags; You can also select to run the report with or without tax. Make your selection at the drop-down menus at the top. Note that the total amount at the top right hand corner of the report changes according to your filter.
- Once the data appears you can search for a specific product in the search-box.
- You can sort this report by each column, ascending or descending. Just click on the column title.
Delivered: this report looks at the delivery date of the order. If an order has not been delivered yet in the system, it looks at the sent order date and includes those orders in the report as well. For accurate data, make sure to receive your merchandise in the system (order status changed to “Delivered” in Purchase Order section) and to run the report over a time period in which all orders have already been delivered.
The quantity delivered showing is: if order has a status of "Delivered" this number is what appears under the "delivered" column. If the order is with status submitted or received, this is the number of the ordered quantity.
Total ($): is the catalog price x delivered quantity /sent quantity(if ordered is not "delivered"). If a price per unit was changed on receiving the order, it will not affect the total, unless the "Update your own prices according to changes made in this order" was selected (in which case there is no credit line at the top).
Average: average means the average price per unit. If the price for an item changed throughout this period of time, it will sum up the totals of the different orders and divide it by the total quantity delivered. For example: 2 packages were purchased for $10 and 3 packages were purchased for $15, it would come up to be 2x10 + 3x15 = 65 divide by 5 the average per unit is $13.
* In order to export the report in an excel format click the Export icon at the top.