Purchase Analysis Report

Purchase Analysis

Go to Purchases > Reporting > Purchase Analysis. Pivot and graph view for procurement data.

Dimensions

• Vendor, Product, Product Category.
• Buyer, Purchase Team.
• Order Date, Receipt Date.
• Country, State.

Measures

• Untaxed Amount, Total, Quantity Ordered, Quantity Received.
• Number of Orders, Average Order Value.

Filters

Date range, order status (RFQ, PO, Done, Cancelled), vendor, buyer.

Key Insights

• Spend by vendor - identify top suppliers.
• On-time delivery rate - compare expected vs actual arrival dates.
• Price trends - track price changes per product over time.
• Procurement cycle time - PO creation to receipt.

Best Practices

• Review vendor performance quarterly using on-time delivery and quality metrics.
• Negotiate better prices based on volume trends identified in the report.
• Use the pivot table to forecast future procurement needs.