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 customized. 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 Availability Product Stock Level Product Reordering (shows all active products) Products Low on Stock (shows only products low on stock) Product Price List Inventory Aging Report Lot Expiry
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 analyze 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 analyze disassembled quantity, cost of disassembled item and any costs from services during the operation.

BOM Component Availability: 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 Inventory Movement Details Inventory Movement Summary Production Cost Analysis
(FG = finished good)
Disassembly Analysis (FG = finished good/ disassembled product) BOM Component Availability (FG = finished good) Out-of-Stock Components for Auto-assembly (FG = finished good) Job Costing Materials
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.

Was this article helpful?

Have more questions? Submit a request