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

PurchaseSaleConversionNote
Reel of 5,000Piece1 reel = 5,000 pcsTrack cut-tape remnants
Box of 100Pack of 101 box = 10 packsMinimum order applies
Tube of 50Piece1 tube = 50 pcsStatic-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.