Most generic inventory management software was designed for retailers and distributors. Stock comes in, stock goes out, reorder when levels drop. For Singapore manufacturers, this model is incomplete: stock arrives as raw materials, transforms through multiple production stages, spends time at subcontractors, and exits as finished goods with a cost structure built from all those transformations.
The gap between what generic inventory tools handle and what manufacturers need is the root of most inventory management failures in Singapore SMBs.
The Five Inventory States in Manufacturing
A manufacturer's inventory is not a single pool of stock — it exists in five distinct states simultaneously:
- Inventory states:
- Raw materials: components and materials received from suppliers, stored in the warehouse, not yet issued to production
- Work in progress (WIP): materials that have been issued to production and are at various stages of completion — at a work centre, waiting between operations, or at a subcontractor
- Subcontractor stock: components or semi-finished goods physically off-site at a subcontractor for processing
- Finished goods: completed products ready for delivery or in finished goods storage
- Customer-owned materials: materials supplied by the customer for use in their jobs — owned by the customer but held by the manufacturer
Generic inventory software handles raw materials and finished goods reasonably well. WIP tracking, subcontractor stock, and customer-owned materials are where most tools fall short.
Where ABSS and Xero Fall Short for Manufacturers
ABSS and Xero inventory modules track quantities and values of stock items. They handle purchase orders (stock in), sales invoices (stock out), and current on-hand quantities. For a distributor, this is sufficient. For a manufacturer, three critical capabilities are missing:
- Manufacturing gaps in accounting software inventory:
- No BOM-based material consumption: issuing materials to a production order requires manually reducing each component quantity
- No WIP location tracking: once materials are issued to production, they disappear from the accounting system until finished goods are received
- No subcontractor stock tracking: components at a subcontractor are typically written off as a cost until they return, creating a phantom inventory gap
- No lot or batch traceability: no connection between the supplier lot number and the production batch or customer delivery
Minimum Viable Inventory System for Singapore Manufacturers
For Singapore manufacturers who cannot yet justify a full ERP investment, the minimum viable inventory system covers three things: a proper item master (all raw materials, sub-assemblies, and finished goods with consistent codes and units), BOM-based production consumption (issuing materials from a job automatically reduces component stock based on the BOM), and subcontractor stock tracking (a dedicated stock location for goods at subcon, updated when goods leave and return).
These three capabilities, built into even a simple custom system, give a production manager the information they need to manage materials without daily manual stock counts or Excel reconciliation.
Lot Traceability for Singapore Manufacturers
Lot traceability records which supplier lot of each raw material was used in which production batch, and which production batch was shipped to which customer. It creates an audit trail from raw material receipt to customer delivery — and in reverse, from a customer complaint back to the specific material lot that was used.
For food manufacturers in Singapore, SFA requires this traceability. For medical device manufacturers, HSA and customer requirements mandate it. For precision engineers and specialty manufacturers, large OEM customers increasingly audit for traceability capability as part of supplier qualification.
Multi-Location Stock for Singapore Manufacturers
Singapore manufacturers often operate across multiple stock locations: the main warehouse, the production floor staging area, quality hold, finished goods, and one or more subcontractor locations. Generic inventory tools handle multiple physical locations for retail (store A, store B, warehouse) but not the production-specific locations a manufacturer needs.
A custom inventory system can define location types that match the manufacturing workflow: raw material store, production floor issue point, work centre buffer, subcon (with subcon name as a sub-location), QC hold, finished goods. Stock moves are recorded as transfers between locations rather than write-offs and re-entries, which gives a continuous, accurate picture of where inventory is at any point in time.
When to Build Custom vs Use a Packaged Tool
- Use a packaged MRP tool (Katana, Cin7) when:
- Products are standard with fixed BOMs and no custom configurations
- Subcontractor use is minimal or none
- Lot traceability is not required
- Multi-location complexity is limited to warehouse and production floor
- Build a custom inventory system when:
- Products are custom or highly variable (precision engineering, specialty manufacturing)
- Subcontractor stock tracking is a daily operational need
- Lot or serial number traceability is required by regulation or customer
- Customer-owned materials need to be tracked separately from manufacturer stock
- Inventory connects to a custom quoting or job costing system