Purchase Analysis report

Estimated reading: 2 minutes 275 views

The Purchase Analysis report gives a clear picture of a company’s purchasing activity in Odoo, from how much has been spent to how quickly vendors deliver. It helps procurement teams of any size make better-informed buying decisions.

Opening the report

Go to Purchase > Reporting > Purchase to open the Purchase Analysis dashboard.

Choosing a measure

Click the Measures button to choose what to analyse. Useful measures include:

  • # of Lines: the number of purchase order lines across all orders.
  • Average Cost: the average cost of purchase orders.
  • Days to Confirm and Days to Receive: how long it takes to confirm an order, and to receive the products.
  • Qty Ordered, Qty Received, Qty Billed and Qty to be Billed: quantities at each stage of the order.
  • Total and Untaxed Total: total spend including or excluding tax. Untaxed Total is selected by default.

Only one measure can be shown at a time in a graph view, but several can be combined in the pivot table view.

Comparing vendors and time periods

Switch to the pivot table, group by Vendor and then Product for more detail, and use a date filter such as Confirmation Date together with the Comparison option (Previous Period or Previous Year) to see how spending has changed over time.

Example use cases

A bar chart grouped by vendor with the Days to Receive measure quickly shows which vendors are consistently slow to deliver. A pivot table filtered to one vendor, with a period comparison enabled, shows whether spending with that vendor has gone up or down since a previous decision was made.

Frequently asked questions

Which measure is selected by default?

Untaxed Total, the total amount spent excluding tax, is the default measure.

Can I compare two time periods?

Yes, using the pivot view with a date filter and the Comparison option, such as Previous Period or Previous Year.

Can more than one measure be shown at once?

Yes in pivot table view, but only one measure can be shown at a time in a graph view.

Need help?

Need help interpreting your Odoo Purchase reports? 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