Managing Consigned Inventory Processes for Vendor-Owned On-Site Stock

Walking the warehouse floor and seeing pallets of supplier owned stock you haven't paid for is a massive operational blind spot unless your system accurately tracks ownership. Navigating a vendor managed inventory ERP setup can be a high-wire act for supply chain leaders. Whether you are configuring NetSuite Consigned Inventory features or adapting another platform, tracking physical goods improperly will inevitably distort your financials. Tracking it wrong artificially inflates your consignment balance sheet valuation, leading to taxes on assets you don't actually own. Conversely, failing to track it risks critical stockouts while your production line grinds to a halt. The challenge is clear: you need precise visibility into physical inventory levels within your four walls, entirely decoupled from the financial ownership of that stock until the exact moment of consumption or sale.

The Core Conflict: Physical Location vs. Financial Ownership

Most standard ERP architectures are built on a simple premise: if an item is received into a warehouse location, its value hits an inventory asset account on the balance sheet, and a corresponding liability (Accounts Payable) is created.

Consigned inventory breaks this fundamental rule. When a supplier ships vendor-owned stock to your facility, you have physical custody, but not legal ownership.

Why Standard Receiving Fails

If your receiving team treats a consignment delivery like a standard Purchase Order receipt in NetSuite or Acumatica, several things go wrong immediately:

1. Balance Sheet Inflation: The value of the goods artificially bloats your current assets.
2. Premature AP Liability: Your finance team will start receiving invoices (or the system will accrue liability) for goods you haven't consumed.
3. Insurance Complexity: If a fire destroys the warehouse, valuing the loss becomes a chaotic dispute between your insurance carrier and the vendor's.

On the flip side, trying to keep consignment stock "off the books" completely—perhaps by just storing it in a corner and tracking it in a Google Sheet—is equally disastrous. Your production planners won't see the stock when running MRP (Material Requirements Planning), and warehouse workers will inevitably pick it without recording the transaction, leading to phantom inventory and vendor disputes.

The Wilson Tech Approach: Process First, Technology Second

The classic tech fix for consigned inventory usually involves buying a heavy, specialized WMS add-on, or writing a tangled web of custom SuiteScripts in NetSuite to intercept receipts and manually reverse GL impacts via journal entries. This is a band-aid. It treats the symptom (bad GL data) while ignoring the disease (a broken intake process).

At Wilson Technology, we believe that you shouldn't have to write custom code to trick your ERP into doing what it was designed to do. We focus on the business process first: how does the material physically arrive, how is it segregated, and what triggers the transfer of ownership?

Instead of custom scripting to suppress financial impacts or cobbling together multi-location inventory (MLI) workarounds, we architect the solution using NetSuite's native Consigned Inventory Management feature. We configure dedicated consigned inventory statuses combined with proper vendor item setups. When the business process changes to respect these statuses, the technology naturally supports it—providing visibility without the financial bloat, and minimizing the long-term technical debt of maintaining custom GL-reversal scripts.

Architecting Consigned Inventory in NetSuite

To track inventory levels inside physical locations without inflating overall balance sheet valuation, you need a structured architecture. Here is how we typically model this for mid-market manufacturers and distributors using NetSuite's native Consigned Inventory Management features.

1. The Consigned Inventory Status

Do not try to mingle owned and un-owned stock using messy zero-dollar transfer workflows if your ERP natively supports status-based tracking.

In NetSuite, the cleanest approach is to leverage the native Consigned Inventory Management feature, which utilizes a distinct set of inventory statuses dedicated to vendor-owned stock.

• Visibility: The inventory is fully visible to demand planning, shop floor, and warehouse personnel via item receipts and inventory reports.
• Valuation Control: You configure a specific "Vendor Consignment Asset Account" on the item record. Stock in a consigned status does not impact your primary inventory asset accounts or Accounts Payable until ownership explicitly transfers.

2. The Intake Process

When the supplier delivers the stock, the warehouse must receive it into the designated consigned inventory status.

• Do not use standard inventory statuses for this stock.
• Ensure the item record has the "Allow Vendor Consignment" setting enabled. Receive the stock normally on an Item Receipt, but explicitly assign the consigned inventory status (e.g., "Vendor Consigned") to the inbound regular, lot, or serialized items. This updates physical on-hand quantities without generating premature AP liability.

3. The Trigger: Consumption and Transfer of Ownership

The most critical step in managing consigned inventory is the exact moment ownership transfers from the supplier to you. This usually happens in one of two ways:

• Consumption: The raw material is issued to a Work Order on the shop floor.
• Sale: The finished good is picked, packed, and shipped to an end customer (common in retail/Shopify environments).

At this trigger point, NetSuite systematically handles the ownership transfer.

This transfer is the financial event. When consigned quantities are consumed or sold, NetSuite automatically triggers an inventory ownership transfer. It recognizes the inventory asset and simultaneously generates the liability on the associated Purchase Order, allowing you to pay the supplier for exactly what was consumed.

Overcoming Common Hurdles

Multi-Channel Selling and Shopify

If you are an omnichannel retailer pushing inventory to Shopify, exposing consigned stock requires careful mapping. Shopify doesn't natively care who owns the inventory; it just cares if it's "Available."

If you use Celigo or a direct API connection to sync NetSuite to Shopify, you must sum the available quantities from both your regular inventory statuses and your consigned inventory statuses to pass an accurate aggregate number to the storefront. However, order routing logic must dictate that if an order allocates against the consignment stock, the backend ERP must trigger the ownership transfer workflow before fulfilling the order.

Reconciling with the Vendor

Vendors need visibility. If they are trusting you with their stock, they expect regular reporting. Instead of manually exporting CSVs every Friday, build a saved search in NetSuite that automatically emails the vendor a "Consignment Stock on Hand" report, or expose this data via a secure B2B vendor portal.

Moving Forward

Managing consigned inventory doesn't require reinventing your ERP. It requires a disciplined operational process paired with the correct native system architecture. By isolating the physical tracking from the financial valuation until the exact moment of consumption, you protect your balance sheet while empowering your supply chain.

If your warehouse is struggling with ghost inventory, or your finance team is manually adjusting journal entries for vendor-owned stock, consider re-evaluating your architecture. A holistic review of your business processes and ERP design can often uncover native solutions that require less maintenance, provide greater visibility, and seamlessly align your physical operations with your financial reality. If you're ready to explore how these strategies can be tailored to your operations, the Wilson Technology team is here to help guide your next steps with practical, business-first insights.