Vendor costs report

Estimated reading: 2 minutes 232 views

The vendor costs report in Odoo Purchase tracks how vendor pricing changes over time, helping identify the most expensive vendors and spot seasonal price changes.

Open the report

Go to Purchase > Reporting > Purchase to open the Purchase Analysis dashboard, then click the pivot icon to switch to pivot view.

Add filters and groups

  1. Clear any existing filters in the search bar, then open the filter dropdown.
  2. Under Filters, choose Requests for Quotation or Purchase Orders, and pick a date field (Order Date or Confirmation Date) with a time range.
  3. Under Group By, select Vendor first, then optionally Product, Product Category, Status or Purchase Representative for more detail.
  4. Once a date range is set, a Comparison option appears: choose Previous Period or Previous Year. Only one comparison can be used at a time.

Add measures

Click Measures and select at least Average Cost or Untaxed Total for meaningful results. Total and Days to Receive can be added for further insight.

Tips

  • Group by Product as well as Vendor to see pricing at item level.
  • Use the Previous Year comparison to check for seasonal trends.
  • Click Insert in Spreadsheet to work with the results in the Documents app, if that module is installed.

Frequently asked questions

Why must Vendor be selected first in Group By?

Selecting Vendor first ensures the report is structured correctly, with each vendor’s figures grouped together.

Can I compare this year with last year?

Yes, once a date filter is set, choose Previous Year (or Previous Period) under Comparison.

Where can I see this report as a spreadsheet?

Click Insert in Spreadsheet from the pivot view, if the Documents Spreadsheet module is installed.

Need help?

Need help building procurement reports in Odoo? Contact support@thoughtlogik.com or see our Odoo optimisation services.

Leave a Reply

Your email address will not be published. Required fields are marked *

Learn how we helped 100 top brands gain success

Subscribe

×
Cancel