Welcome back, …
Component database · adapt-x
⚠️ Pending actions
Items waiting for your attentionQuick actions
Recent activity
More filters →| ID | Cat | MPN | Value | Location | Ownership | Stock | Last counted | Updated |
|---|
🏗️ Build feasibility
Pick a product + how many units you want to build. The tool rolls up the BOM, compares required qty against current stock across all locations, and flags shortages. No data is written — this is read-only analysis.
| ID | MPN | Value | Refs | Per unit | Required | Available | Shortage | Where (location: qty) |
|---|
🧮 BOM cost roll-up
Picks a product + a build volume and multiplies every BOM line
by its component unit_cost. Totals are reported
per currency (no FX conversion — finance does that).
Optional / DNP lines are excluded by default.
📊 Inventory value
Total stock × unit_cost, with breakdowns by
location and category kind. Multi-currency safe — never silently
converts. Stock with no recorded unit cost is reported as
unpriced quantity instead of being valued at zero.
📉 Reorder suggestions
Lists every component whose total stock is below
MOQ × factor. Suggested order qty rounds up to
a multiple of the vendor's MOQ. Components with no MOQ set
are skipped — there's nothing to compare against.
| ID | Cat | MPN | Value | Vendor | Stock | MOQ | Threshold | Shortfall | Suggested order | Lead (d) |
|---|
⚠️ Build shortfalls
Shows every product with a Target qty set where at least one BOM component's stock falls short of what's needed to build the target volume. Each line lists the component, how many it needs, what you have, and the gap. Components shared across products may appear in more than one section.
Products to include
| Code | Name | Qty |
|---|
By product shows each product's required vs stock for the parts it uses (same component appears under several products if more than one needs it). By component sums every product's demand for each component, then compares against the single global stock — exposes "looks fine each, can't build them all" shortages. Cascade walks sub-assemblies (linked products) recursively so the By component view rolls down to leaf raw parts only.
🗑️ Scrap report
Aggregates scrap quantities per component across all production runs. Sorted by scrap rate — useful for identifying components with chronic feeder loss or packaging damage.
💱 FX rates
Quick reference for converting between USD and the four other currencies the catalog uses (RMB, NTD, EUR, JPN). Rates come from a free public feed and are cached for ~1 hour. Reference only — your finance team should use a contracted rate for invoicing.
| Currency | Per 1 USD | Converted |
|---|
🔧 Adjustment report
Summary of all stock adjustments by component. Use this to identify parts with frequent or large discrepancies between system and physical count.
| ID | Cat | MPN | Value | # Events | Total adjusted | Last adjusted | By |
|---|---|---|---|---|---|---|---|
| Select a date range and click Run | |||||||
🧹 Unused components
Components that aren't referenced by any active product's BOM — candidates for retirement or stock-down. References from soft-deleted products don't count.
Dead-stock value
| ID | Cat | MPN | Value | Mfr | Vendor | Stock | Unit cost | Value (stock × cost) | EOL |
|---|
📈 Most-used components
Components ranked by how many active products use them. High counts = supply-chain risk (if this part disappears, lots of BOMs break) and good candidates for vendor consolidation / volume pricing. Click a row to see the product list for that part.
| ID | Cat | MPN | Value | # products | Used in (click ▸ for qty + ref-des) | Total qty / build | Stock | EOL |
|---|
| When | ID | Cat | Location | Type | IN | OUT | Destination | By | Notes |
|---|---|---|---|---|---|---|---|---|---|
| Set filters and click Search | |||||||||
Stock IN
Stock OUT
Transfer
Reassign Ownership
Change who owns stock at a location without moving any quantity. Logged to the activity log; no stock movement recorded.
Adjustment
Free Sample Receipt
Record components received as free samples — no PO required. Stock is added immediately.
New component
ID is generated automatically as <category-code><5-digit-seq> (e.g. R00039).
Add a new lookup value
If the dropdown is missing what you need, add it here — the form on the left will pick it up immediately.
| Value | Logo | Used by | Vendor | Actions |
|---|
R00001).
Once a category has at least one component, its row locks 🔒 — you'd have to
reassign or delete those components first. Unused categories
(Used by = 0) can be edited or deleted freely.
| Code | Name | Kind | Next ID seq | Used by | Actions |
|---|
Products
Files
| Kind | Filename | Uploaded | By | Size | Notes | Actions |
|---|
Links
BOM lines
⇩ Download (.xlsx)| ID | Cat | MPN | Value | Mfr | Refs | Qty | DNP | ECN | Notes | Edit |
|---|
Build feasibility
Enter how many units you want to build. We'll compute the required quantity per BOM line, compare against current stock, and flag any shortages.
| ID | MPN | Value | Refs | Per unit | Required | Available | Shortage | Where (location: qty) |
|---|
Users
| Username | Full name | Role | Active | Online | Created | Last login | Actions |
|---|
🏢 Company information
Branding shown on the printable PO form. Any field left blank
falls back to the corresponding PO_COMPANY_*
environment variable (so legacy .env setups keep
working). Changes take effect immediately on the next PO you
print. Admin only.
Logo
Shown on the printable PO header. PNG / JPG / GIF / WebP / SVG, up to 2 MB. Re-uploading replaces the existing logo.
💾 Storage usage
Disk usage of uploaded files on this machine, the MySQL
database size, and free space on the drive hosting
webui/. Admin only.
Uploaded files
Datasheets / 3D models / drawings / etc. are broken out by kind (not by folder) since a single upload folder can hold several kinds of file.
| Category | Files | Size |
|---|---|---|
| Loading… | ||
| Total | ||
Database —
| Table | Approx. rows | Size |
|---|---|---|
| Loading… | ||
| Total | ||
| Component | Vendor | Vendor P/N | MOQ | Unit price | Cur | Lead (d) | Effective | Preferred | Actions |
|---|
Purchase orders
Files
| Kind | Filename | Uploaded | By | Size | Notes | Actions |
|---|
Lines
| ID | Cat | MPN | Value | Ordered | Received | Remaining | Unit price | Line total | Target loc. | Receive |
|---|
Receipts
| When | ID | Location | Qty | By | Notes |
|---|
New Purchase Order
Line items
| Cat | ID * | Qty ordered * | Unit price | Target location |
|---|
When editing an existing PO, saving replaces every line item. If any line already has receipts logged, editing is refused — reverse the receipts first via the Log tab.
| Product | ID | Cat | MPN | Value | Footprint | Mfr | Refs | Qty | DNP | Notes | Files |
|---|
Archived products
Soft-deleted products. Restore brings one back and reclaims its original product code (only if no live product has taken that code in the meantime). Permanently delete removes the product, all its BOM lines, and all attached files from disk — this cannot be undone.
| Original code | Name | Rev | Status | Deleted at | Deleted by | BOM lines | Files | Mangled code | Actions |
|---|
1. Upload BOM file
Accepts .xlsx, .xlsm, .csv, .tsv, .txt.
The first row must be the header.
2. Target product
3. Map columns
We guessed these from the header row — adjust if needed. Either ID or MPN must be mapped so we can match rows to your catalog.
4. Preview & import
| # | Match | Refs | Qty | ID | MPN | DNP | Notes |
|---|
🏭 Production consumption
Pick a product and build volume — used quantities are taken directly from the BOM.
Optionally upload a scrap file (Excel/CSV) listing only components that had waste.
Required columns: ID, Scrap, Location.
Optional: Notes. Components not in the file default to scrap = 0
and the location with the most stock.
Preview
| # | ID | MPN | Value | Location | Used | Scrap | Total | Stock | After | BOM expected | Status |
|---|
🏭 Production log
History of every production-consumption batch applied via Edit → 🏭 Production consumption. Read-only.
| When | By | Product | Volume | Lines | Used | Scrap | Scrap % | Actions |
|---|
| ID | Category | MPN | Value | Used | Scrap | Total | Scrap % | # Runs | Locations |
|---|
📜 Activity log
Every state-changing action recorded in the system — component edits, stock moves, BOM imports, PO receipts, lookup renames, user registrations, etc. Use the filters below to scope by who, what, or when.
| When | User | Operation | Summary | Undone? |
|---|
Submit scrap file
Upload a scrap file for this production run. Stock OUT moves will be created for each scrapped component.
| ID | MPN | Value | Location | Used | Scrap | Total | Stock before |
|---|
Customize quick actions
Choose which actions appear on your home screen. Drag to reorder.