The supplier spend analysis report can be run in by product mode. The report will then show you purchase data for specific products.
📌 Notes:
This report requires the PID to locate the product, the PID is Procure Wizards unique ID and not the suppliers SKU or product code.
This report considers all orders (excluding credits and returns) in any status other than cancelled created between the start and end dates inclusively. Where the invoice is outstanding the delivery or purchase order data will be used instead. Custom products are not included in the report. All values quoted are exclusive of tax and delivery or discounts (unless applied as a product).
Click the Admin Cogs icon along the top bar.
Click Suppliers then click Spend Analysis.
Click By Product Mode.
Enter the PID to the box titled Search For Products.
Click on Search.
At the right, click on Add.
Repeat step 6 and step 7 if adding multiple products.
Click Proceed.
Enter and set the following:
Suppliers.
Site.
Department.
Amalgamate orders.
Start date.
End date.
Click Display Report.