Consignment Inventory Tracking
What it does
This NetSuite customization enables accurate tracking and management of consignment inventory — goods physically held at your location but still owned by the vendor until consumed or sold. It maintains a clear separation between consigned and owned stock within NetSuite, with ownership transfer and accounting triggered automatically at the point of consumption rather than receipt.
Operations, procurement, and finance teams gain visibility into exactly how much consignment stock is on hand, which vendor owns it, and what has been consumed in each period — supporting accurate liability reporting, vendor reconciliation, and working capital management without maintaining parallel records outside the system.
Common use cases
Consignment tracking handles the full lifecycle from vendor delivery through consumption, billing, and reconciliation — across the scenarios where standard NetSuite inventory falls short.
Consignment Receipt & Tagging
When consignment goods arrive, they are received into a designated consignment location in NetSuite and tagged with the owning vendor — visible in inventory counts and reports but excluded from owned asset valuation until consumed.
Consumption-Triggered Accounting
When consigned items are used in production, fulfillment, or a work order, ownership transfers automatically — generating the appropriate liability entry and notifying accounts payable to accrue or process the vendor payment for the consumed quantity.
Vendor Consumption Reporting
Periodic consumption reports summarize quantities used by item and vendor for a given period, forming the basis for vendor invoices or self-billing arrangements — eliminating the need to manually compile usage data from multiple sources.
On-Hand Balance Visibility
Dashboards show consignment balances by vendor, item, and location in real time — giving procurement teams visibility into how much consignment stock remains available and whether replenishment requests need to be sent to the vendor.
Vendor-Managed Inventory (VMI)
For VMI arrangements where the vendor monitors and replenishes stock automatically, the solution tracks on-hand thresholds and can generate or notify replenishment signals — keeping consignment locations stocked without manual procurement involvement.
Multi-Location Consignment
For businesses with consignment stock spread across multiple warehouses, plants, or customer sites, the solution tracks ownership and consumption by location — giving vendors and finance an accurate view of stock position and liability across the entire operation.
How it's built
Custom inventory ownership logic, location-based segregation, and SuiteScript automation work together inside NetSuite to track consignment stock and trigger accounting at the point of consumption.
Receipt & Tagging
Consignment goods are received via a custom item receipt type that assigns vendor ownership and routes stock to a dedicated consignment bin or location — keeping consigned and owned inventory physically and logically separate.
Consumption Tracking
A SuiteScript User Event script monitors transactions that consume consigned items — work orders, item fulfillments, or inventory adjustments — recording the quantity consumed, the owning vendor, and the consumption date against the consignment record.
Ownership Transfer & Accounting
On consumption, a journal entry is automatically created to recognize the liability to the vendor and move the cost into the appropriate COGS or inventory account — eliminating the manual accounting step that typically follows consignment usage.
Reconciliation & Reporting
Saved searches and dashboards summarize on-hand consignment balances and period consumption by vendor — providing the data needed for vendor billing reconciliation and month-end liability accruals without manual extraction.
Before → After
Before
- Consignment inventory is tracked in spreadsheets outside NetSuite — there is no system-level distinction between stock the business owns and stock the vendor still owns.
- Consumption is recorded manually and summarized periodically, creating gaps between when stock is actually used and when the liability to the vendor is recognized.
- Month-end consignment accruals are estimated rather than calculated from actual consumption data, introducing variance that distorts the P&L.
- Vendor reconciliation at the end of each period is time-consuming — teams must manually compare their consumption records against the vendor's invoice, often finding discrepancies.
- There is no real-time view of how much consignment stock remains on hand by vendor or location, making replenishment timing a manual judgment call.
- Consigned stock is often inadvertently included in owned inventory valuations, overstating assets on the balance sheet.
After
- Consigned and owned inventory are clearly separated in NetSuite by location, ownership tag, and valuation — the balance sheet reflects only what the business actually owns.
- Consumption is tracked automatically at the transaction level — ownership transfers and journal entries are created the moment consigned stock is used, with no manual follow-up required.
- Month-end accruals are calculated from actual consumption data in NetSuite, eliminating estimation errors and accelerating the close process.
- Vendor reconciliation reports are generated directly from NetSuite consumption records — matching vendor invoices against system data in minutes rather than hours.
- Real-time dashboards show consignment balances by vendor, item, and location — giving procurement the visibility to manage replenishment proactively without monitoring spreadsheets.
- Consigned stock is correctly excluded from owned inventory asset totals, producing accurate balance sheet reporting without manual adjustments each period.
Explore more capabilities on the NetSuite Solutions hub or read about our customization services.