Part number discipline
Use the manufacturer part number as the primary identifier and keep an internal code for warehouse operations. Add supplier part numbers as aliases.
- Manufacturer + MPN as the unique key.
- Package, tolerance and voltage as attributes.
- Alias fields for supplier and customer part numbers.
- Datasheet link or note field for reference.
Reels, cut tape and pieces
| Purchase | Sale | Conversion | Note |
|---|---|---|---|
| Reel of 5,000 | Piece | 1 reel = 5,000 pcs | Track cut-tape remnants |
| Box of 100 | Pack of 10 | 1 box = 10 packs | Minimum order applies |
| Tube of 50 | Piece | 1 tube = 50 pcs | Static-sensitive handling |
Record partial reels as their own batch so quantity and traceability stay accurate.
Quotations and BOM picking
Customers often send a bill of materials. Being able to enter multiple lines quickly and substitute equivalents wins business. Keep equivalent part numbers as aliases so search finds alternatives.
- Fast multi-line entry with part number and quantity.
- Show stock and lead time before confirming.
- Print a quotation or proforma with part numbers and prices.
- Convert a confirmed quotation into a sales invoice without retyping.
Date codes and quality traceability
Record date code and lot on receipt, and issue by oldest suitable lot. If a customer reports a quality issue, the batch history should identify what was supplied and when.
- Batch and date code fields on receipt and issue.
- Quarantine for returned components.
- Monthly count of high-value reels.
- Report stock by age to avoid obsolete inventory.