Access the Purchasing Reports Group
Expand the Reports & Graphs section.
Click Reports.
In the report type dropdown, select Purchasing Reports.
In the second dropdown, select one of the following reports:
Purchase Order Detail Report
Summarizes details of a historical Purchase Order. Can be grouped by date range and vendor.
Sort fields include: Ordered By, PO Status, PO Number/Date.
Purchase Order Summary Report
Summarizes each historical PO including Status, Order/Expected Dates, Cost, and Amount Received.
Filter by date range and vendor.
Sort by: Ordered By, PO Status, PO Number/Date.
Purchases by Model ID Report
Shows purchases grouped by Item Number, for both tools and consumables.
Includes: Vendor, Order Date, Quantity, Cost, and Received/Cancelled/Remaining amounts.
Sort fields include: Category, PO Status, PO Date/Number.
How to Calculate Average Purchase Cost for Consumables
To calculate the average unit cost of a consumable item:
Run the Purchases by Model ID Report.
Locate the consumable item you want to evaluate.
Use the values in the Cost column (not the Extended column).
Add up all the costs for that item.
Count the number of purchase records (rows).
Divide the total cost by the number of records.
Average Unit Cost = Total of Cost column ÷ Number of POs (rows)
This gives you the true average per-unit cost across all purchases.
Receipts by Model ID Report
Shows receipts grouped by item and date range.
Includes: Vendor, Receipt Date, Quantity Received, and Cost.
Sort by: Category, Receiving Number, Receiving Date.
Receiving Ticket Detail Report
Summarizes individual receiving tickets.
Group by date range and vendor.
Sort by: Received By, PO Number, Date Received.
Receiving Ticket Summary Report
Summarizes each receiving ticket including: Vendor, PO Number, Date Received, Received By, and Amount Received.
Filter by date range.
Sort by: Received By, Date, or Amount Received.
Vendor Discrepancy Report
Identifies items received at a price different from the PO.
Includes: Model Record info, Quantity Received, Ordered Price, Received At, and Price Difference.
Group by: Vendor, PO, or Discrepancy.