On the Purchases – average prices screen you can find summarized information for the average prices of your purchases. The screen is divided into several sections: Header (1), Filter (2) and Result (3).
Within the Header (1) section you can find a blue magnifier button that’s used to show and hide the Filter section.
When the Filter (2) section is shown, you can use it to filter purchases on specific criteria. The available options are summarized in the following table:
Option | Meaning |
Date range (From, To) | Allows you to filter your results based on the time the purchase happened |
Company | Allows you to filter based on the company that made the purchase |
Office | Allows you to choose the office where the purchases were made |
Supplier types | Allows you to filter based on client type – like an online supplier or a printing house |
Suppliers | Allows you to filter based on a specific supplier |
Trader | Allows you to filter based on the person who made the order |
Item Type | Allows you to filter based on the item type – like goods, material, product or services |
Item | Allows you to filter for a specific item |
Item set | Allows you to filter based on the item set |
Groups | Allows you to filter based on groups (if already defined in the system) |
Brand | Allows you to filter based on brand |
Search | Custom search for something specific |
By default the system will show you all prices without taxes. If you would like to see the prices with Tax included, you have to check the box Price inc-tax.
The Results (3) section shows you the purchases that happened based on the Filter criteria. By default the system will show the following columns:
Column | Meaning |
ID | Item ID |
Name | Name of the item |
Brand | Brand of the item |
Prices | Amount of different prices |
Purchases | Number of purchases |
Qty | Quantity of purchased items |
Amount | Total amount of the purchases |
Min | Minimum price |
Max | Maximum price |
Average price | Average price (based on Min, Max and purchased quantities) |
Standard deviation | The dispersion of the different prices |