Skip to content

Tracking Inventory

Know exactly what you have, where it is, and where it went — every receipt, issue, transfer, and adjustment in one place.

What You'll Learn

  • How to record inventory transactions (receipts, issues, transfers, adjustments)
  • How to track filament spools and material usage
  • How to run cycle counts to reconcile physical stock with system records
  • How to read inventory status indicators

Prerequisites


Understanding Transaction Types

Every inventory movement in FilaOps is recorded as a transaction. There are six types:

Type Color What It Records
Receipt Green Stock coming in — supplier deliveries, returns from customers, production output
Issue Red Stock going out — shipped to customers, consumed in production
Transfer Blue Stock moving between locations — warehouse to shop floor, shelf to shelf
Adjustment Yellow Corrections — fixing miscounts, reconciling system vs. physical quantity
Consumption Orange Materials used up during production — filament, resin, adhesives
Scrap Gray Damaged, defective, or expired stock being written off

Each transaction type appears as a colored badge throughout the system, making it easy to scan your transaction history at a glance.


The Inventory Transactions Page

Navigate to Inventory > Transactions in the sidebar. This is your main page for recording and reviewing all inventory movements.

Recording a Transaction

Step 1. Click + New Transaction.

Step 2. Fill in the transaction details:

  • Product — Select the item (required). Start typing to search by name or SKU.
  • Transaction Type — Choose from the six types above (defaults to Receipt)
  • Location — Where this transaction happens (defaults to your primary location)
  • Quantity — How many units (supports decimals for weight-based items like filament)
  • Cost per Unit — The unit cost for this transaction (optional — used for costing reports)

Step 3. Add optional details:

  • Reference Type — Link this transaction to a source document:
    • Purchase Order
    • Production Order
    • Sales Order
    • Adjustment (standalone correction)
  • Reference ID — The specific document number (e.g., PO-1234)
  • Lot Number — For traceability, if your materials use lot tracking
  • Serial Number — For serialized items
  • Notes — Free-text notes about why this transaction happened

Step 4. Click Save.

Transfer transactions

When you select Transfer as the transaction type, an additional To Location field appears. This is required — you must specify both where the stock is coming from (Location) and where it's going (To Location).

Adjustment transactions

When you select Adjustment, an Adjustment Reason dropdown appears. Choose a reason that explains the correction — this feeds into your audit trail and accounting records.

Filtering Transactions

Use the filters above the transaction table to find specific records:

  • Product — Show transactions for a specific item
  • Type — Show only receipts, issues, transfers, etc.
  • Location — Show transactions at a specific warehouse or shop

Reading the Transaction Table

The transaction table shows these columns:

Column What It Shows
Date When the transaction was recorded
Product Item SKU and name
Type Color-coded badge (Receipt, Issue, Transfer, etc.)
Quantity Amount with unit of measure
Location Where the transaction occurred
Reference Linked document type and number (e.g., "Purchase Order #12")
Cost/Unit Unit cost at time of transaction
Total Cost Quantity multiplied by cost per unit
Notes Any notes attached to the transaction
Reason Adjustment reason (for adjustment transactions only)

Material Spools

If you work with filament or other spool-based materials, FilaOps tracks individual spools so you know exactly how much material is left on each one.

Navigate to Inventory > Spools in the sidebar.

The Spools Page

Each spool in the list shows:

  • Spool Number — Your identifier for this physical spool
  • Material — The material name and SKU
  • Weight — A progress bar showing current weight vs. initial weight, with the exact values displayed
  • Status — Active, Empty, Expired, or Damaged
  • Location — Where the spool is stored or in use

Weight Progress Bar

The weight progress bar is color-coded to give you a quick visual read on remaining material:

Color Meaning
Green More than 20% remaining — plenty of material left
Yellow Between 10% and 20% remaining — getting low, plan a replacement
Red 10% or less remaining — nearly empty, swap soon

Adding a Spool

Step 1. Click + Add Spool.

Step 2. Fill in the spool details:

  • Spool Number — A unique identifier (required). Use whatever system works for you — sequential numbers, label codes, etc.
  • Material — Which material product this spool contains (required). Select from your materials catalog.
  • Initial Weight — The starting weight in grams (required). For a standard 1kg spool, enter 1000.
  • Current Weight — How much material is currently on the spool in grams (required). For a brand new spool, this matches the initial weight.
  • Status — The spool's condition (Active, Empty, Expired, or Damaged)
  • Location — Where the spool is stored
  • Supplier Lot Number — The manufacturer's lot or batch number (useful for traceability)
  • Expiry Date — When the material expires (for hygroscopic materials like nylon)
  • Notes — Any additional details

Step 3. Click Save.

Spool Number, Material, and Initial Weight are locked after creation

Once you save a spool, you can't change its number, material assignment, or initial weight. You can always update the current weight, status, location, and other fields. If you made a mistake, delete the spool and create a new one.

Updating Spool Weight

As you use material, update the current weight to keep your progress bars accurate:

Step 1. Click Edit on the spool you want to update.

Step 2. Enter the new Current Weight in grams. Weigh the spool on a scale for accuracy.

Step 3. Click Save.

Filtering Spools

  • Search — Find spools by spool number, SKU, or material name
  • Status — Show only active, empty, expired, or damaged spools

Weigh spools regularly

The most common complaint about spool tracking is stale weight data. Make it a habit to weigh active spools at the start of each day or each print run. Accurate weights prevent mid-print runouts and improve your MRP material planning.


Cycle Counts

A cycle count is a physical inventory audit — you count what's actually on the shelf, enter those numbers, and FilaOps calculates and records the variances. This keeps your system quantities aligned with reality.

Navigate to Inventory > Cycle Count in the sidebar.

How Cycle Counts Work

graph LR
    A[Filter items to count] --> B[Count physical stock]
    B --> C[Enter counted quantities]
    C --> D[Review variances]
    D --> E[Submit count]
    E --> F[System records adjustments]

When you submit a cycle count, FilaOps automatically creates inventory adjustment transactions for every item where the counted quantity differs from the system quantity. These adjustments include the reason you selected and create corresponding accounting entries.

Running a Cycle Count

Step 1: Set Up the Count

At the top of the page, configure your count session:

  • Count Reference — Auto-generated as "Cycle Count YYYY-MM-DD" (today's date). You can edit this to add specifics like "Cycle Count 2026-02-15 — Shelf A".
  • Default Reason — Select a reason that will apply to all variances in this count (required). You can override the reason on individual items later. Options include:
    • Physical count variance
    • Damaged/defective — scrapped
    • Found in alternate location
    • Data entry error correction
    • Theft/loss suspected
    • Received but not recorded
    • Shipped but not recorded
    • Sample/testing usage
    • Other — see notes

Step 2: Filter What to Count

Narrow down which items to include in this count:

  • Location — Select a specific location, or count across all locations
  • Category — Filter by product category (e.g., count only filament, or only finished goods)
  • Search — Find specific items by SKU or name
  • Show zero quantity items — Toggle this on to include items with zero system quantity (useful for finding unrecorded stock)

Step 3: Enter Counted Quantities

The inventory table shows every item matching your filters. For each item you physically counted:

Column What It Shows
SKU The item's part number
Product Name Item name, with category and unit of measure shown below
System Qty What FilaOps thinks you have
Counted Qty Where you enter the number you actually counted
Variance The difference (counted minus system) — shown in green if positive, red if negative
Reason Per-item reason override — only appears when there's a variance

Two shortcut buttons help speed up data entry:

  • Fill Current Qty — Pre-fills every Counted Qty field with the current System Qty. Then you only need to change the items that differ.
  • Clear All — Resets all Counted Qty fields to blank.

The \"Fill Current Qty\" shortcut

For most cycle counts, the majority of items will match. Click Fill Current Qty first, then walk the shelves and only change the items where your count differs. This is much faster than entering every number from scratch.

Step 4: Review Variances

As you enter quantities, FilaOps highlights variances in real time:

  • Rows with variances get a yellow background so they stand out
  • The Counted Qty input gets a yellow border when it differs from System Qty
  • The Variance column shows the difference in green (found more than expected) or red (found less than expected)

For each item with a variance, you can optionally select a per-item reason from the dropdown. If you don't, the default reason from the top of the page is used.

Step 5: Submit the Count

When you've finished entering all quantities, click Submit Count.

FilaOps processes the count and shows a results summary:

  • Total Items — How many items were included in the count
  • Successful (green) — Items processed without errors
  • Failed (red) — Items that couldn't be processed (rare, usually a system error)

Below the summary, a variance details table shows every item that had a variance:

Column What It Shows
SKU Item part number
Name Item name
Previous What the system quantity was before the count
Counted What you entered
Variance The difference
Status OK (green) or FAILED (red)

Accounting impact

Every cycle count variance creates a journal entry in your general ledger. Positive variances debit Inventory and credit the Inventory Adjustment expense account. Negative variances do the opposite. This keeps your books in sync with physical reality.

Cycle Count Best Practices

  • Count by area, not all at once — Use the Location and Category filters to count one section at a time. This is faster and more accurate than trying to count your entire inventory in one session.
  • Count high-value items more often — Finished goods and expensive materials deserve weekly or monthly counts. Low-value supplies can be counted quarterly.
  • Investigate large variances — A variance of 1-2 units might be a normal counting error. A variance of 50 units suggests a process problem (unrecorded shipments, theft, data entry mistakes).
  • Use specific reasons — "Physical count variance" is a catch-all, but specific reasons like "Shipped but not recorded" help you find and fix process gaps.
  • Count during quiet times — Avoid counting while production is running or orders are being packed. Activity during the count leads to inaccurate results.

Tips & Best Practices

  • Record transactions in real time — Don't batch up a week's worth of receipts and enter them on Friday. Real-time recording keeps your available quantities accurate for MRP and order fulfillment.
  • Always link to a reference — When recording a receipt, link it to the purchase order. When recording an issue, link it to the sales order. This creates a complete audit trail.
  • Use lot numbers for traceability — If a customer reports a quality issue, lot numbers let you trace the problem back to a specific supplier batch.
  • Monitor the Items page stock colors — The Items page shows stock status colors (red/orange/yellow/green) at a glance. Check it daily for out-of-stock and low-stock alerts.
  • Weigh spools, don't estimate — A cheap kitchen scale is your best friend for spool tracking. Guessing leads to mid-print failures.
  • Run cycle counts monthly — At minimum, count your top 20% of items (by value) every month. This catches variances before they snowball.

What's Next?

With inventory tracking in place, you can automate replenishment and plan ahead:

Quick Reference

Task Where to Find It
Record a receipt Inventory > Transactions > + New Transaction > Type: Receipt
Record a transfer Inventory > Transactions > + New Transaction > Type: Transfer
Record an adjustment Inventory > Transactions > + New Transaction > Type: Adjustment
Add a new spool Inventory > Spools > + Add Spool
Update spool weight Inventory > Spools > Edit on the spool row
Run a cycle count Inventory > Cycle Count > Fill quantities > Submit Count
Filter by location Use the Location dropdown on any inventory page
Check stock levels Inventory > Items > Look at stock status colors