Inventory Reports
View information about your inventory via the Reports module. Most reports can be automatically generated and sent out to authorized users using the Report Scheduling feature available to Cin7 Core customers with Automation module subscriptions.
Users will need the Inventory Reporting permission to view or edit inventory reports. See Managing Users & Roles for more information on setting user permissions.
This article displays a summary of each Cin7 Core report, click the links to see further information about each report and answers to common user questions. It is not possible to generate custom reports in Cin7 Core, but the layout can be reorganized and existing report fields can be added and removed. Please check the tables in this article to see which fields are included in each report.
For more information on searching, filtering, exporting and scheduling reports, please see Managing Cin7 Core Reports.
Product Availability:Shows available, on-hand, allocated and on-order quantities, and stock value for every product in every location for every batch/serial number and expiry date. Cin7 Core informs users of the expected delivery date of stock currently on order. This report cannot be customised. Use the Products Stock Level report for a more detailed view.
Products Stock Level: Shows the current stock level of all active products in all locations. Use this report to see available, on-hand, allocated, on-order, reordered and minimum before reorder quantities. You can also check the stock on hand value and unit cost of products on the current date.
Products Reordering: Shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for all active products.
Products Low on Stock: Shows stock level details necessary for stock refill. Use this report so see available, on order, reorder and minimum before reorder quantities as well as purchase price for active products with stock levels below the minimum before reorder quantity.
Products Price List: Shows a product price list. Use this report to see all of your inventory products listed with prices from up to 10 price tiers.
Inventory Aging: Inventory Aging Report shows how long products stay in stock by time intervals. Use this report to see which products have a high turnover rate and low turnover rate. See how long products stay in stock measured by time interval (0-30 days up to over 180 days) as of the current date.
Lot Expiry: Shows all product batches with their expiry dates. Use this report to check how much quantity on hand you have of different product batch numbers and when they will expire.
Field Name |
Product Reordering (shows all active products) |
Products Low on Stock (shows only products low on stock) |
|||||
Can be scheduled? |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
SKU |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Product |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
(Stock) Location |
Yes |
Yes |
Yes |
Yes |
|
Yes |
Yes |
Unit |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Brand |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Category |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Family |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Family Op.1 Name |
|
|
|
|
Yes |
|
|
Family Op.1 Value |
|
|
|
|
Yes |
|
|
Family Op.2 Name |
|
|
|
|
Yes |
|
|
Family Op.3 Name |
|
|
|
|
Yes |
|
|
Family Op.3 Name |
|
|
|
|
Yes |
|
|
Family Op.3 Name |
|
|
|
|
Yes |
|
|
Product Tags |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Product Additional Attribute 1-10 |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Barcode |
|
Yes |
|
Yes |
Yes |
|
|
Weight |
|
|
|
|
Yes |
|
|
Width |
|
|
|
|
Yes |
|
|
Height |
|
|
|
|
Yes |
|
|
Bin |
Yes |
|
|
|
|
Yes |
Yes |
Stock Locator |
Yes |
|
|
|
Yes |
|
|
(Product) Status |
Yes |
|
|
|
|
|
|
Batch/Serial # |
Yes |
|
|
|
|
Yes |
Yes |
Expiry Date |
Yes |
|
|
|
|
Yes |
Yes |
Supplier |
|
|
Yes |
Yes |
|
|
|
Supplier Additional Attribute 1-10 |
|
|
Yes |
Yes |
|
|
|
Price Tier 1 |
Yes |
|
|
|
Yes |
|
|
Price Tier 2 |
Yes |
|
|
|
Yes |
|
|
Price Tier 3 |
Yes |
|
|
|
Yes |
|
|
Price Tier 4 |
|
|
|
|
Yes |
|
|
Price Tier 5 |
|
|
|
|
Yes |
|
|
Price Tier 6 |
|
|
|
|
Yes |
|
|
Price Tier 7 |
|
|
|
|
Yes |
|
|
Price Tier 8 |
|
|
|
|
Yes |
|
|
Price Tier 9 |
|
|
|
|
Yes |
|
|
Price Tier 10 |
|
|
|
|
Yes |
|
|
(Expiry) Year |
|
|
|
|
|
|
Yes |
(Expiry) Quarter |
|
|
|
|
|
|
Yes |
(Expiry) Month |
|
|
|
|
|
|
Yes |
Job # |
|
|
|
|
|
|
|
Job Description |
|
|
|
|
|
|
|
(Expense) Date |
|
|
|
|
|
|
|
Job Status |
|
|
|
|
|
|
|
Customer |
|
|
|
|
|
|
|
(Customer) Address |
|
|
|
|
|
|
|
(Customer) Contact |
|
|
|
|
|
|
|
Input |
|
|
|
|
|
|
|
Lot Expires On |
|
|
|
|
|
|
Yes |
Data Headers |
|
|
|
|
|
|
|
Quantity on Hand |
Yes |
Yes |
|
|
|
|
Yes |
Available |
Yes |
Yes |
Yes |
Yes |
|
|
|
Allocated |
Yes |
Yes |
|
|
|
|
|
On Order |
Yes |
Yes |
Yes |
Yes |
|
|
|
Unit Cost |
Yes |
Yes |
|
|
|
|
|
Stock on Hand Value |
Yes |
Yes |
|
|
|
|
|
Reorder Quantity |
|
Yes |
Yes |
Yes |
|
|
|
Minimum before reorder |
|
Yes |
Yes |
Yes |
|
|
|
Volume on Hand |
Yes |
Yes |
|
|
|
|
|
Next Delivery |
Yes |
|
|
|
|
|
|
Purchase Price |
|
|
Yes |
Yes |
|
|
|
Average Cost |
|
|
|
|
Yes |
|
|
Days in stock |
|
|
|
|
|
Yes |
|
(Job) Quantity |
|
|
|
|
|
|
|
(Product) Price |
|
|
|
|
|
|
|
Tax |
|
|
|
|
|
|
|
Total (Quantity x Price) |
|
|
|
|
|
|
|
Inventory Movement Details: Shows a summary of stock movements in a specified timeframe. Use this report to see inventory movement details for specific transactions including transaction reference, date, quantity in and out and cost in and out.
Inventory Movement Summary: Shows a summary of stock movements in a specified timeframe. Use this report to see financial information such as stock on hand value, volume on hand (if dimensions are specified), unit cost and average cost for all active products. Use this report to check stock value as of a specific date. The summary report does not show transaction references.
Production Cost Analysis: Shows completed finished goods within the selected time period. Use this report to analyse finished goods yield quantity, production cost, and cost of component products and services within a date range.
Disassembly Analysis: Shows completed disassemblies within the selected time period. Use this report to analyse disassembled quantity, cost of disassembled item and any costs from services during the operation.
BOM Component Details: This inventory report shows products in Cin7 Core with Bills of Materials (BOM) along with the details of the components under each BOM. Use this report to see what components are required for a parent product, and the component amount available and on hand. The report can be filtered by BOM products in/not in a sale and the available component quantity.
Out of Stock Components for Auto-assembly: Shows out of stock components for auto-assembly products grouped by location. Use this report to see the quantities of components that need to be ordered to complete your pending auto-assembly operations.
Job Costing Materials: Shows materials and stock used on a particular job during the selected time period. It also indicates where this material was purchased if it did not come from inventory already in stock. Use this report to see the quantity and cost of job costing materials.
Field Name |
Production Cost Analysis |
Disassembly Analysis (FG = finished good/ disassembled product) |
BOM Component Details (FG = finished good) |
Out-of-Stock Components for Auto-assembly (FG = finished good) |
|||
Can be scheduled? |
|
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
SKU |
Yes |
Yes |
Yes (Component and FG) |
Yes (Component and FG) |
Yes (Component and FG) |
Yes (Component and FG) |
Yes |
Product |
Yes |
Yes |
Yes (Component and FG) |
Yes (Component and FG) |
Yes (Component and FG) |
Yes (Component and FG) |
Yes |
(Stock) Location |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
Yes (FG) |
|
Unit |
Yes |
Yes |
Yes (Component and FG) |
Yes (Component and FG) |
|
Yes (Component) |
Yes |
Brand |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
|
Yes |
Category |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
|
Yes |
Family |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
|
Yes |
Product Tags |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
|
Yes |
Product Additional Attribute 1-10 |
Yes |
Yes |
Yes (FG) |
Yes (FG) |
|
|
Yes |
Barcode |
Yes |
Yes |
|
|
|
|
|
Bin |
Yes |
|
|
|
|
|
|
Stock Locator |
Yes |
Yes |
|
|
|
|
|
(Product) Type |
|
|
Yes (Component) |
Yes (Component) |
|
|
|
Batch/Serial # |
|
Yes |
Yes (Component and FG) |
Yes (Component and FG) |
|
|
|
Year |
Yes |
|
Yes |
Yes (FG) |
|
|
Yes |
Quarter |
Yes |
|
Yes |
Yes (FG) |
|
|
Yes |
Month |
Yes |
|
Yes |
Yes (FG) |
|
|
Yes |
(Task) Type |
Yes |
|
|
|
|
|
|
(Task) Reference |
Yes |
|
|
|
|
|
|
Assembly # |
|
|
Yes |
|
|
|
|
Assembly Status |
|
|
Yes |
|
|
|
|
Completion Date |
|
|
Yes |
|
|
|
|
Disassembly # |
|
|
|
Yes |
|
|
|
Disassembly Date |
|
|
|
Yes |
|
|
|
Job # |
|
|
|
|
|
|
Yes |
Job Description |
|
|
|
|
|
|
Yes |
(Expense) Date |
|
|
|
|
|
|
Yes |
Job Status |
|
|
|
|
|
|
Yes |
(Job) Customer |
|
|
|
|
|
|
Yes |
Customer Address |
|
|
|
|
|
|
Yes |
Customer Contact |
|
|
|
|
|
|
Yes |
Supplier |
|
|
|
|
|
|
Yes |
Input |
|
|
|
|
|
|
|
Reporting Period |
Yes |
Yes |
Yes |
Yes |
|
|
Yes |
Show (All Products/ Components in a Sale/ Components not in a sale) |
|
|
|
|
Yes |
|
|
Filter by Available |
|
|
|
|
Yes |
|
|
Available qty is less than: |
|
|
|
|
Yes |
|
|
Data Headers |
|
|
|
|
|
|
|
Quantity on Hand |
|
Yes |
|
|
Yes |
|
|
(Qty) Available |
|
|
|
|
Yes |
|
|
(Qty) Allocated |
|
|
|
|
|
Yes |
|
(Qty) On Order |
|
|
|
|
|
|
|
(Qty) Required |
|
|
|
|
Yes |
Yes |
|
Quantity used |
|
|
|
|
|
|
Yes |
Unit Cost |
|
Yes |
|
|
|
|
|
Stock on Hand Value |
|
Yes |
|
|
|
|
|
Volume on Hand |
|
Yes |
|
|
|
|
|
Quantity In |
Yes |
Yes |
|
|
|
|
|
Quantity Out |
Yes |
Yes |
|
|
|
|
|
Cost In |
Yes |
|
|
|
|
|
|
Cost Out |
Yes |
|
|
|
|
|
|
Average Cost |
|
Yes |
|
|
|
|
|
Yield |
|
|
Yes |
|
|
|
|
Production/Services Cost |
|
|
Yes |
Yes |
|
|
|
Component Cost |
|
|
Yes |
Yes |
|
|
|
Component Quantity |
|
|
Yes |
Yes |
|
|
|
Disassembled Quantity |
|
|
|
Yes |
|
|
|
Disassembled Cost |
|
|
|
Yes |
|
|
|
Price |
|
|
|
|
|
|
Yes |
Tax |
|
|
|
|
|
|
Yes |
Total (Price x quantity used) |
|
|
|
|
|
|
Yes |
Lot Recall: This report shows Customers, Stock On Hand and Suppliers of selected product lots and batches. Use this feature to track your lot/batch/serial number usage from Purchase/manufacturing through to Sell. Prepare recall letters for customers in case of a Recall event.
Warehouse Details: Shows warehouse details for fulfilled sale orders over a specified date range. It shows the number of orders and SKUs that were handled by your pickers, with the aim of helping management make better decisions on warehouse operations. Can be scheduled.