NetSuite Consignment Inventory: How to Track Consigned Stock

Your warehouse is full of goods you don't own. Vendors sent them to you on consignment. But your finance team still spends time fixing records each month. They need to keep the books right. Your controller also worries when vendor stock shows up in the wrong accounts.

This problem affects many businesses. Teams spend hours matching stock records with vendor reports. The goods sit on your shelves, but they still belong to the vendor. The good news? NetSuite Services can help you track this stock with less manual work. You get clearer records without relying on endless spreadsheets.

Key Takeaways

• NetSuite 2026.1 added a native tool to track vendor-owned stock.
• Consignment helps lower upfront stock costs and saves cash.
• Built-in tracking cuts the time spent checking stock records.
• Separate accounts help track vendor stock and related costs.
• Setup requires Multi-Location Inventory, Inventory Status, and other features.
• Oracle confirms that Advanced Bin/Numbered Inventory Management is also required.

Understanding Consignment Inventory and Why It Matters

Consignment changes how businesses buy and sell goods. Instead of buying stock upfront, you receive goods from a vendor. The vendor still owns them. You usually pay when the goods sell.

This setup can help both sides.

• For buyers: Lower upfront costs, less risk, and more cash on hand.
• For vendors: More sales channels and better access to buyers.
• For both sides: Shared goals because both benefit when goods sell.

Problems start when your software can't track who owns each item. Some systems treat all stock in your warehouse as goods you own. That can cause errors in your accounts. Vendor stock may appear as regular stock on your books. Your reports may show the wrong values.

Auditors may spot these issues. Banks may also ask questions when they review your finances. And your finance team? They have one more issue to fix before month-end.

The Real Cost of Poor Consignment Tracking

Tracking vendor stock by hand takes time. Staff must enter journal entries each month. Separate warehouse sites can make reports harder to read. Custom scripts may also need regular fixes.

Then there's the issue of staff knowledge. One worker may know how the whole process works. If they leave, someone else must figure it out.

Old software and custom fixes can also add technical debt. This means more time and money spent keeping systems running.

For teams focused on NetSuite Optimization, fixing these issues is a good place to start. Clear stock records mean fewer errors and less work.

Key Features of Inventory Management Software for Consigned Stock

Good stock tracking needs more than basic inventory tools. Here are the main features to look for.

Separate Quantity Tracking

Your system should show vendor-owned stock apart from stock you own. NetSuite has a Consigned Inventory subtab for this purpose. You can see both types of stock on supported item records. This helps warehouse staff know which goods belong to vendors.

Dedicated GL Accounts

Vendor stock needs different accounting rules from goods you buy. NetSuite uses accounts such as Vendor Consignment Inventory Asset and Vendor Consigned Inventory Received Not Billed.

These accounts track the value of vendor goods. They also keep related entries apart from regular stock costs. These entries may still appear on financial reports. Your finance team should check how they affect the books.

Automated Ownership Transfer

When you sell consigned goods, NetSuite records the sale through supported transactions. For a sales order fulfillment, the system debits the right COGS account. COGS means cost of goods sold. It also credits the consignment asset account.

You can then create a vendor bill from the purchase order. The bill covers goods used or sold but not yet billed. This cuts the need for manual journal entries.

Vendor Reconciliation Tools

Matching your records with vendor reports is easier when you track each step. NetSuite's Consignment Purchases Workbook shows orders, goods received, stock used, and bills. Your team can use it to find errors before they grow.

Return Workflow Support

Not every consigned item will sell. Some goods must go back to the vendor. NetSuite supports Vendor Return Authorization workflows for these cases. These tools help staff track returns and keep stock counts right.

Setting Up NetSuite for Consignment Inventory Tracking

You need to prepare your NetSuite account before using native consignment. The steps below cover the main tasks.

Step 1: Enable Core Features

Go to Setup > Company > Setup Tasks > Enable Features.

Open the Items & Inventory tab and check these features:

• Inventory Management
• Multi-Location Inventory
• Inventory Status
• Advanced Bin/Numbered Inventory Management
• Bin Management
• Vendor Return Authorizations

Oracle's setup guide lists these needs.

Once these features are active, turn on Consigned Inventory Management.

Check your current setup first. NetSuite does not support native consignment with Assembly Items or Warehouse Management.

Expected result: New fields and tools for consigned stock become available. You can also set up special GL accounts.

Step 2: Configure Default GL Accounts

Go to Setup > Accounting > Accounting Preferences > Items/Transactions.

Review the main accounts used for consigned stock:

• Default Vendor Consignment Asset Account: Tracks the value of vendor stock.
• Default Vendor Consignment COGS Account: Tracks the cost of sold vendor stock.

Create the needed accounts before you assign them. The COGS account is optional if you want to track these costs on their own.

NetSuite also creates some accounts for consignment. One is Vendor Consigned Inventory Received Not Billed.

You can use default accounts for most items. You can also set different accounts for certain goods.

Step 3: Create Consigned Inventory Statuses

Go to Setup > Accounting > Inventory Status.

NetSuite lets you use special statuses for vendor-owned stock.

You may want to create these:

• Consigned - Good
• Consigned - Inspection
• Consigned - Damaged
• Consigned - Reserved

Critical step: Mark each status for consigned stock use.

Use clear names so staff can tell vendor stock from owned stock. Remember that NetSuite does not let you change stock directly between consigned and non-consigned statuses.

Step 4: Flag Items as Consignable

Open your item records under Lists > Accounting > Items.

Find the Allow Vendor Consignment setting. Turn it on for the right items. You can also review account settings for goods that need different rules.

If you have many items, check which fields support CSV updates. Test a few records before making large changes.

Our NetSuite CSV import guide has tips for working with item data.

Step 5: Test the Full Cycle

Before going live, test the whole process.

1. Create a Purchase Order and mark an item as consigned.
2. Receive the goods through an Item Receipt.
3. Choose the right consigned stock status.
4. Check the consigned stock count on the item record.
5. Create and fulfill a Sales Order.
6. Create a Vendor Bill for the goods sold.
7. Check the GL entries for each step.

Pay close attention to the accounting results. When goods arrive, NetSuite debits Vendor Consignment Inventory Asset. It credits Vendor Consigned Inventory Received Not Billed.

When goods sell, the system records their cost in the right COGS account. Check that the vendor bill matches the amount of stock used.

Once the test works, you can plan your live setup.

Common Setup Challenges and How to Fix Them

Even a good setup can run into problems. Here are some issues to watch for.

The last issue needs extra care. Your business may use virtual locations or custom scripts to track vendor stock. Those records won't vanish when you turn on the new feature.

If you don't clean up old records, some values may get counted twice. This can lead to wrong stock totals and errors in your reports.

Check old entries, account balances, and custom processes before switching. Your finance team should approve the starting balances.

Leveraging NetSuite's Advanced Inventory Features for Consignment

Once your setup works, you can use other stock tools. These features help teams manage goods across sites and product types.

Serialized and Lot Tracking

Some goods need more detailed tracking. For example, medical devices may need serial numbers. Food products may need a lot of numbers.

NetSuite supports these tools for compatible consigned items. This helps staff trace goods when checking stock or handling returns.

Multi-Location Inventory

Many businesses store goods at more than one site. NetSuite can track vendor-owned stock across several warehouses. You can see the stock count at each site.

Supported transfers also let you move these goods between sites. NetSuite keeps their consigned status during the move.

Bin Management

Bins help warehouse staff find and store goods. You can place vendor stock in certain bins and track where it sits.

Using bins with stock statuses gives staff a clearer view of what is available. It also helps stop different types of stock from getting mixed up.

Workflow Automation

Custom workflows can help staff act when stock levels change. For example, you can send alerts when vendor stock falls below a set level.

You can also alert finance when goods are ready for vendor billing. These alerts help staff deal with small issues before they grow.

For more ideas, read our NetSuite automation guide.

Streamlining Operations with NetSuite Automation for Consigned Stock

Manual work can take away the gains from good stock tracking. The goal is to let NetSuite handle routine tasks. Your team can then focus on work that needs human input.

Automating Consignment Reporting with Saved Searches

Start with the questions your team asks most often.

For example:

• How much vendor stock do we hold?
• Which goods haven't sold in 90 days?
• Which sold items still need vendor bills?
• Which warehouses move vendor stock most often?

Saved searches can show data from supported stock and sales fields. You can set up these reports and send them to staff by email. Some details may need SuiteAnalytics instead.

The Consignment Purchases Workbook helps track orders, stock use, and bills. Your buying team can use these reports to spot slow sales. Finance can find goods that still need billing.

Custom Workflows for Consigned Stock Management

NetSuite workflows can handle alerts and approval tasks.

Some useful examples include:

• Low stock alerts: Tell buyers when stock falls below a set level.
• Aging notices: Flag old stock that may need to go back.
• Billing approval: Send large vendor bills for review.

These tools can cut emails and manual checks. They also help staff follow the same steps each time. That matters when several workers deal with the same vendors.

NetSuite Consignment for Wholesale Distributors and Manufacturers

Different industries use consignment in different ways. Wholesale sellers often gain the most from native consignment. Factories may need another approach due to NetSuite's feature rules.

Wholesale Distribution

NetSuite for wholesale distributors helps businesses manage stock, orders, and vendors.

Consignment is useful for sellers that handle:

• Vendor-managed inventory (VMI): Vendors help check stock and plan new orders.
• Multiple vendors: Several suppliers provide goods under consignment terms.
• Large product lists: Some goods are owned while others belong to vendors.

Native consignment helps sellers track these goods in one system. It also helps staff see which items still belong to vendors.

The money saved depends on each deal. For example, a seller may receive goods without paying upfront. Payment becomes due after those goods sell.

This can leave more cash in the business. Actual savings depend on sales, vendor terms, and stock levels.

Manufacturing

NetSuite for manufacturers has tools for making goods, tracking stock, and buying parts.

However, native consignment has an important rule. Oracle confirms that Consigned Inventory Management cannot run with Assembly Items.

The native feature also does not support related manufacturing workflows. This means factories should check their current setup before choosing it.

Some may need custom tools to track vendor-owned parts. Others may need separate buying and accounting steps.

The right choice depends on how parts enter production and when ownership changes.

Comparison: Native Consignment vs. Legacy Workarounds

If you already use custom tracking, don't rush to replace it. First, check if native consignment fits your business. Then review old records and account rules.

A careful switch can help prevent duplicate entries and reporting errors.

Best Practices for Managing Consigned Inventory in NetSuite

Good consignment tracking starts with careful planning. These steps can help your team avoid problems later.

Start with clean data

Check your vendor stock counts before making changes. Match warehouse counts with vendor records. Review old journal entries and stock values.

If your starting numbers are wrong, your new reports will also be wrong.

Train warehouse staff thoroughly

Your warehouse staff must know how to receive and move vendor stock. Show them which stock statuses to use. Give staff time to practice with test orders.

The wrong status can lead to stock errors and extra work for finance.

Document your vendor agreements

Your vendor deals should state when ownership changes. In supported NetSuite sales flows, ownership moves when consigned goods sell or are used.

But your contracts may have different terms. Review these terms before setting up your process.

Run the Consignment Purchases Workbook monthly

This workbook helps you track goods received, used, and billed. Check it each month before speaking with vendors.

Look for missing bills, wrong stock counts, and goods that need review. This helps both teams work from the same records.

Establish return procedures

Some vendor goods will not sell. Your staff needs a clear way to send those goods back.

Set up the right return steps before old stock starts to pile up.

For more tips, read our NetSuite implementation guide.

Who This Solution Works Best For

Strong fit if you:

• Hold goods that belong to vendors.
• Use spreadsheets or manual entries to track vendor stock.
• Need clear reports for stock you don't own.
• Want vendor bills based on goods sold.
• Handle enough vendor stock to gain from built-in tools.

May not be the best fit if you:

• Use NetSuite's Assembly Items feature.
• Run NetSuite Warehouse Management or the WMS SuiteApp.
• Depend on Blanket Purchase Orders.
• Need special billing rules beyond the native feature.

These details matter because each NetSuite account is different. A setup that works for one seller may not suit another.

Check your tools and vendor deals before making a choice.

Why Anchor Group Helps With NetSuite Consignment Implementation

Consignment tracking connects finance, warehouse work, and vendor management. Each team needs clear data to do its job.

At Anchor Group, we help businesses improve their NetSuite stock, buying, and accounting processes. Our team knows how small setup problems can cause larger issues. That includes old workarounds, duplicate records, and stock reports that don't match.

We're a Midwestern-based Oracle NetSuite Alliance Partner. We focus on practical fixes and clear advice. We don't believe you need fancy slides to solve a stock problem. When your finance team needs answers before month-end, we help find a plan that works.

Our approach includes:

• Assessment first: We review your stock process and vendor terms before changing settings.
• Clean migration: We help find old workarounds and check stock balances.
• Useful training: We show staff how to use the new setup.
• Ongoing support: We help fix problems after the system goes live.

For a quick chat, start with our FREE 30-minute NetSuite fix. You'll speak with a consultant who can review your needs and suggest next steps.

You can also read our customer success stories to see how we've helped other businesses improve their systems.

Frequently Asked Questions

What is the difference between consigned inventory and owned inventory in NetSuite?

Consigned goods belong to the vendor until ownership changes under the agreed terms. Owned stock belongs to your business. NetSuite tracks these amounts in separate stock records. It also uses special accounts for vendor-owned goods. Some entries may appear on your financial reports. Your finance team should review these accounts and check that they match your vendor deals and accounting rules.

Can NetSuite track consignment inventory across multiple locations?

Yes. NetSuite can track vendor-owned stock at more than one warehouse. Each site can show its own stock counts. You can also move goods between sites through supported transfer orders. NetSuite keeps their consigned status during the move. The Consignment Purchases Workbook helps teams review orders and bills. This gives staff a clear view of stock across their sites.

How can I automate reporting for consigned stock levels in NetSuite?

Start with the stock details your team checks most often. These may include vendor balances, old stock, and goods sold. Saved searches can show data from supported fields. You can also send these reports to staff on a set schedule. For more detail, use the Consignment Purchases Workbook. It helps track goods from the first order through sale and billing.

What modules in NetSuite are most important for managing consignment inventory?

Consigned Inventory Management is the main tool for tracking vendor-owned stock. You also need Inventory Management, Multi-Location Inventory, and Inventory Status. Oracle requires Vendor Return Authorizations and Advanced Bin/Numbered Inventory Management. Bin Management is also needed. Other stock tools can help with reports and planning. However, native consignment cannot run with Assembly Items or Warehouse Management.

How does Anchor Group help with NetSuite consignment inventory implementation?

Anchor Group helps businesses plan and improve their NetSuite stock workflows. We start by reviewing your current process and vendor terms. Then we check account settings and old workarounds. Our team can also help with staff training and support after launch. The goal is a setup your team can use with ease. Learn more about our NetSuite Consulting services.