Inventory Reports
View historical inventory levels across all warehouse locations. Track inventory by location, product line, and SKU over time.
Monthly Inventory Report
The monthly inventory report displays all your historical inventory across all warehouse locations created in Moselle.
Table Structure
The table displays:
Warehouse column - Lists all warehouses with chevron arrows to expand
Month columns - Historical months showing inventory snapshots (sum of starting inventory + sum of ending inventory for each month)
Expand Warehouses: Click the chevron arrow beside any warehouse to drill down and view SKUs with their inventory levels by month.
Single vs Multiple Columns
Toggle between viewing options:
Single Column Groups all product lines and SKUs into one column for a compact view.
Multiple Columns Breaks out data into three separate columns:
Warehouse → Product Line → SKU
Sort and Search
Click month column headers to sort by inventory amount. Use the Filter button to search for specific inventory amounts and update the table.
Customize Table View
Columns
Click Columns on the far right of the table to customize your view.
Toggle columns on or off:
Location
Warehouse location
Product Line
Product line grouping
Product Type
Type of product
SKU
Product SKU
Name
Product name
Month
Time period
Starting Inventory
Inventory at the beginning of the month
Ending Inventory
Inventory at the end of the month
Row Groups: Drag and drop columns to reorder table grouping. Click the X button to remove a column from grouping.
Filters
Click Filters on the far right to refine table data.
Filter by:
Archived
Category
Channel
Month
Name
Product Line
Product Type
SKU
Click the chevron arrow beside any filter option to expand and select specific values. Use the search bar above each list to quickly find items.
Export Report
Select a cell within the report
Right-click on the cell
Select Export and choose:
Excel export
CSV export
The file will begin downloading.
Last updated
Was this helpful?