Inventory Management
Purchasing Analysis
What you've bought over time and how much you've spent with each supplier, down to each order.
Can't find what you need? Contact Cinchio:
About
Inventory Management only
This report is only available to companies using Inventory Management.
The Purchasing Analysis report shows product purchases over time, including buying patterns and total spend with each supplier.
Open it from Reports & Analysis > Inventory Management > Purchasing > Analysis. What it shows depends on the filters you choose.
Delivered orders only
The report only includes supplier orders marked as Delivered, so it reflects completed purchases.
Filters
Choose these before you run the report.
The sites or site groups to include.
The delivery dates to include.
The product groups to include. Leave blank for all.
The suppliers to include. Leave blank for all.
Tick to open the report with every level expanded. Otherwise, the totals are shown and you can expand rows as you need.
Report Output
The report has three levels. What they show depends on the Analysis Type filter.
Same for every reporting profile
This report looks the same whichever reporting profile your company uses.
Which Analysis Type did you choose?
By Product
Level 1: Product Summary
The products bought in the date range. Select a product to see its supplier products.
- Product Name
- Display Unit
- Ordered Qty
- Delivered Qty
- Delivered Cost
See columns for what each one means.
Level 2: Supplier Product Summary
Each supplier product bought for the selected product.
- Supplier
- Supplier Product Name
- Supplier Product Code
- Supplier Product Pack Size
- Ordered Qty
- Delivered Qty
- Delivered Cost
See columns for what each one means.
Level 3: Order Listing
Each supplier order for the selected supplier product.
- Order ID
- Delivered Date
- Our Order Ref
- Supplier Order Ref
- Supplier Product Pack Size
- Ordered Qty
- Delivered Qty
- Delivered Cost
See columns for what each one means.
By Supplier
Level 1: Supplier Summary
Orders received and total spend with each supplier in the date range. Select a supplier to see its sites.
- Supplier Name
- Orders Received
- Delivered Cost
See columns for what each one means.
Level 2: Site Summary
The same figures for the selected supplier, broken down by site.
- Site Name
- Orders Received
- Delivered Cost
See columns for what each one means.
Level 3: Order Listing
Each product received at the selected site from the selected supplier.
- Order ID
- Delivered Date
- Our Order Ref
- Supplier Order Ref
- Supplier Product Name
- Supplier Product Code
- Supplier Product Pack Size
- Ordered Qty
- Delivered Qty
- Delivered Cost
See columns for what each one means.
Columns
Every column used in both analysis types.
The product's description.
The product's unit size. Quantities and costs are based on this size.
The supplier.
The site.
The product's name, as the supplier knows it.
The product's code, as the supplier knows it.
The supplier pack size the quantities and costs are based on.
The supplier order's unique ID in Cinchio Back Office.
When the order was delivered.
Your reference for the order.
The supplier's reference for the order.
The number of orders received in the date range.
The quantity ordered.
The quantity received.
The cost of the goods delivered. At supplier and site level, this is your total spend.