Welcome back, …
Component database · adapt-x
Quick actions
Recent activity
| SN | Cat | MPN | Value | Location | Ownership | On-hand | Last counted | Updated |
|---|
| When | SN | Cat | Location | Type | IN | OUT | By | Notes |
|---|
Stock IN
Stock OUT
Transfer
Adjustment
New component
SN 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 | Used by | Actions |
|---|
R00001), so renaming or deleting an existing category would break that link.
You can add new ones below.
| Code | Name | Next SN seq | Used by |
|---|
Products
Files
| Kind | Filename | Uploaded | By | Size | Notes | Actions |
|---|
BOM lines
⇩ Download (.xlsx)| SN | 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 on-hand inventory, and flag any shortages.
| SN | MPN | Value | Refs | Per unit | Required | Available | Shortage | Where (location: qty) |
|---|
Users
| Username | Full name | Role | Active | Created | Last login | Actions |
|---|
| 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
| SN | Cat | MPN | Value | Ordered | Received | Remaining | Unit price | Line total | Target loc. | Receive |
|---|
Receipts
| When | SN | Location | Qty | By | Notes |
|---|
New Purchase Order
Line items
| SN * | Qty ordered * | Unit price | Target location |
|---|
| Product | SN | Cat | MPN | Value | Footprint | Mfr | Refs | Qty | DNP | Notes |
|---|
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 SN or MPN must be mapped so we can match rows to your catalog.
4. Preview & import
| # | Match | Refs | Qty | SN | MPN | DNP | Notes |
|---|