More PO Reports

1 - PO activity by supplier & month
PO activity overview by month, detailing top 12 suppliers, last 12 month.

PO 01 - PO activity by supplier
Purchase order activity last 12 months for top 250 suppliers. Top 25 suppliers are shown, others are grouped. To see all suppliers, clear filter. Float with mouse over chart to display supplier name

PO 02 - PO activity by product
Purchase order activity last 12 months for top 250 products. Top 25 products are shown, others are grouped. To see all products, clear filter. Float with mouse over chart to display product name.

PO 03 - PO activity by product group
Purchase order activity last 12 months by product groups. Float with mouse over chart to display product group name.

PO 04 - PO activity breakdown by sub-group
Purchase order activity last 12 months, breakdown by product sub-groups in product group. Change product group in tabs to see sub-groups. Float with mouse over chart to display product sub-group name.

PO 05 - PO monthly activity
Monthly purchase order activity, last 24 months. Values above one standard deviation are highlighted in table and charts.

PO 11 - Monthly PO % received
Ratio of PO amounts received to ordered for orders of the last 6 month.

PO 12 - PO % received top 10 suppliers
Ratio of PO amounts received to ordered for orders of the last 6 month, broken down by top

PO 13 - PO amount to receive by expected delivery
Distribution of PO amount ordered but not received by product group and expected delivery month. Shows both past and future months.

pO 21 - Delivery times top 100 suppliers
Average days to delivery for top 100 suppliers, last 12 month. Suppliers sorted top-down by PO amount. Exceptional delivery delays are highlighted.

PO 22 - Delivery delays top 100 suppliers
Overdue PO lines ratio for worst 50 suppliers, showing overdue and on-time PO lines, overdue ratio and average days overdue, last 12 month.

PO 23 - Control list of overdue POs
List of PO lines not received yet over 30 days (only POs from last 180 days), sorted by purchase date.

PO 24 - Control list of undelivered POs
List of PO lines overdue, sorted by days overdue.

PO 31 - List of price deviations in POs
Analyses unit prices of purchases made in last 12 months and returns those with normalized standard deviation > 0.5. Drill down to PO ID in order to see source of deviations.

PO 41 - Suppliers return ratio
Shows return ratio by supplier for top 1000 suppliers, goods purchased in last 12 months. Return ratio 1% and above is highlighted.

PO 42 - Products return ratio
Shows products where goods were returned, purchased in the last 12 months. Return ratio 20% and above is highlighted.

OR activity by project
OR amount purchased by project, last 12 month. Switch to table view to see month-by-month.

OR 01 - OR activity by user
Number and amount of ORs by ordering user, last 12 month. Filtered to show top 20 users by OR amount.

OR 02 - OR activity by month
Number and amount of ORs by ordering month, last 12 month.

OR 03 - OR activity by supplier & user
Number and amounts of ORs for 100 top suppliers and order above 100 euro, by ordering user, last 12 month. Sorted top-down by order amount, highlighting exceptional order amounts.

OR 04 - Top 10 projects breakdown by supplier
Purchased OR amounts by supplier, for top 10 projects, showing top 80% per project.

OR 11 - Rejection ratio by user
OR lines rejection ratio by user, showing users with more than 50 OR lines, last 12 month. Highlighted are rejection ratios above one normal standard deviation.

OR 12 - Rejected ratio trend
OR lines rejection ratio by month, showing trend and summmary, last 24 month.

OR 21 - Order to purchase times by approving user
Average days from OR submition to PO, by approving user, last 12 month, showing top 50 approving users. Highlighted are delays above half normal standard deviation.

3 - Products in stock
Stock position - sorted top-down by product, showing type of packing. List filtered to show products making up 80% of stock value.

SK 01 - Products in stock extended
Detailed list of products in stock, including locations, quantities, reordering, amounts and prices. Filtered to show top 1000 products by amount.

SK 02 - Stock value over time by products
Stock position - sorted top-down by product, showing type of packing. Only products with a stock amount of more than 10 euros are shown.

SK 03 - Stock information over time
Stock monthly development, last 24 month. Shows stock amount position, stock age and number of products in stock.

SK 04 - Stock in consumption month
Stock position relative to average consumption - expressed in months consumption value of stock.

SK 11 - Stock details for PO
Stock movement details for one product in a purchase order. Shows movements and positions in quantity and amount terms. Enter product code and Purchase Order ID in input pane.

SK 12 - Stock movements last 7 days
Stock movement details for last 7 days, showing in & out quantities by product, supplier and project for each day.

4 - Invoice summary by supplier
Summary of invoices by supplier for the last 12 months. Filtered to show top 25 by amount.

INV 01 - Declined invoices by supplier
Invoices decline ratios by supplier, last 12 month.

INV 02 - Open invoices by supplier
PO lines # and amounts for POs delivered but not invoiced, by supplier. Shows POs from last 365 days, ignoring recent 30 days. Filtered to show top 80% in amounts.

INV 03 - List of invoices by ledger number
List of invoices for specific GL numbers, last 12 month. Enter GL numbers, separated by commas, in step #6 of input pane.

INV 04 - Overhead ratio
Overhead ratio by supplier, last 12 month, showing invoices with overhead above Euro 1.0.

INV 11 - List of invoice unit price differences
List of invoices where the invoice unit price was different than the PO unit price stated, last 12 month. Filtered to show differences above +100 or below -100.

INV 12 - List of invoice amount differences
List of invoices where the invoice amount was different than the PO amount stated, last 12 month. Filtered to show differences above +1000 or below -1000.

INV 21 - In-process invoices
List of pending or "in-process" invoices with over 15 days from invoice date by user, last 12 month.

INV 22 - List of invoices registered in delay
Lists invoices where invoice registration date is more than 30 days after invoice date, for invoices registered in the last 12 month, grouped by supplier.

5 - Product catalog
Shows the product catalog for specific suppliers. Please select supplier in input pane step #6.

PROD 01 - Product card
Shows product position and attributes. Enter product ID in input pane.

PROD 02 - Products not ordered by supplier
List by supplier of products in catalog where no PO has been made in the last 12 months. Products # is the number that were not ordered, and Product in stock # is the number that are still in stock. Drill-down into a supplier to see individual product entries.

PROD 03 - Added products
List of products added to catalog in the last 30 days.

PROD 04 - PO to catalog price diff
Shows products where absoluete relative PO price to catalog price (net) is more then 1%, last 60 days.

6 - Supplier overview
Report shows different metrics for selected suppliers. Use the 7. Define filter menu in the input pane to choose one or multiple suppliers. Only supplier with activity in the last year are shown.