NetSuite Serialized & Lot-Numbered Inventory: Setup & Tracking

An auditor asks which buyers received goods from a recalled batch. Can your team find the answer? With spreadsheets, the search could take hours or days. With a well-built NetSuite Services setup, the work can be much faster. NetSuite links lot and serial numbers to stock records, sales, and returns.

This helps your team trace goods from the vendor to the buyer. It also helps you find bad stock before more goods ship. For firms with strict safety rules, those records can make a big difference.

Key Takeaways

• Lot tracking groups goods by batch, such as production date or shelf life.
• Serial tracking gives each unit its own number for warranty and return records.
• NetSuite WMS and the FEFO Lot Assignments SuiteApp can help pick lots by expiry date.
• NetSuite has built-in expiry dates and warnings for lot records.
• Good lot records help teams trace recalled goods faster.
• Advanced Bin/Numbered Inventory Management links lot and serial numbers to warehouse bins.

Understanding Serialized vs. Lot-Numbered Inventory in NetSuite

Lot and serial numbers help you track goods. But they serve different needs.

Lot-numbered inventory tracks goods by batch. Each lot holds items that share certain traits. These may include the same production date, expiry date, or supplier.

Think of a shipment of canned food. The cans came from the same batch. They may share one expiry date and lot number.

Serialized inventory tracks each unit on its own. Every unit has a unique number. This works well for medical devices, tools, and electronics. If a buyer reports a fault, you can look up that unit.

Here is how the two methods compare.

NetSuite supports both methods. You can use lot numbers for some items and serial numbers for others.

The system links these numbers to stock transactions. This helps you trace where goods came from and where they went. The key is to capture the right data at every step.

Initial Setup of Serialized Inventory in NetSuite

Serial tracking starts with the right account settings. You then create the item records and train your staff.

Step 1: Enable the Feature

Go to Setup > Company > Enable Features.

Open the Items & Inventory tab. Check Serialized Inventory and save your changes.

You can now create serialized item records. When you receive or ship these items, NetSuite asks for the right serial numbers.

With supported inventory features, staff can enter these details in the Inventory Detail window.

Step 2: Set Up Item Records

Go to Lists > Accounting > Items > New.

Choose Serialized Inventory Items.

Enter the main item details, such as:

• Item name
• Description
• Units of measure
• Cost method
• Vendor details

Choose the cost method with care. Specific costing lets you track costs for individual serial numbers. This can help when units have different costs.

Other supported cost methods may suit items with similar costs.

NetSuite also has an Autogenerate Numbers option in the Inventory Detail window. You can enter a prefix, starting number, and number of digits. NetSuite then makes the serial numbers for that receipt.

If vendors already use serial numbers, enter those instead. This helps your records match the labels on the goods.

Step 3: Train Your Receiving Team

This step is easy to miss. Your team must record serial numbers when goods arrive.

When staff receive an order, they should:

1. Open the purchase order.
2. Select the items to receive.
3. Open Inventory Detail.
4. Enter the serial numbers.
5. Check the numbers against the labels.
6. Save the item receipt.

NetSuite requires the needed serial numbers for tracked items. If staff enter the wrong numbers, your records may not match the actual units. That can cause trouble during returns or warranty checks.

Your NetSuite Implementation should include clear steps for receiving staff.

Setting Up Lot-Numbered Inventory Tracking

Lot tracking follows a similar process. The main difference is that each lot can hold many units. You also need to track dates and batch details.

Enable Lot Tracking

Go to Setup > Company > Enable Features.

Open Items & Inventory. Check Lot Numbered Inventory and save.

Next, go to Lists > Accounting > Items > New. Choose Lot Numbered Inventory Item.

Fill in the item details and select the cost method. NetSuite supports lot-numbered costing and other supported cost methods.

With lot-numbered costing, each lot has its own cost records. This can help you track batches bought at different costs.

Use Native Expiration Date Tracking

NetSuite has built-in expiry date tracking for lot records. You do not need a custom field for basic expiry dates.

When staff create a lot record, they can enter its expiry date. NetSuite can also warn users when they sell a lot close to expiry.

This helps prevent mistakes when handling goods with short shelf lives. You can use these dates in reports and stock reviews.

For more control, you may need saved searches or extra tools.

Receive Lot-Tracked Items

When a shipment arrives, open the purchase order. Choose the goods being received.

Then follow these steps:

1. Open Inventory Detail.
2. Enter the supplier lot number.
3. Enter the amount received for that lot.
4. Add the expiry date when needed.
5. Repeat for other lots in the shipment.
6. Check the totals and save.

One shipment may contain more than one lot. For example, you may receive 100 boxes split across two batches. Enter each batch under its own lot number.

NetSuite links those lots to the receipt and related transactions. If a recall happens, you can use these records to trace the affected goods.

Advanced NetSuite Inventory Management Features

Basic lot and serial tracking may be enough for some firms. Others need more control over picking, storage, and expiry dates.

FEFO Picking Logic

FEFO means First Expired, First Out. It means you pick goods with the nearest expiry date first. This can help reduce waste.

For example, your warehouse has two lots of juice. One expires in March. The other expires in June. FEFO tells staff to pick the March lot first, as long as it meets the buyer's shelf-life needs.

NetSuite WMS supports FEFO picking. Oracle also offers the FEFO Lot Assignments SuiteApp.

The SuiteApp can assign lots based on expiry dates and shelf-life rules. It can also use FIFO for items without expiry date controls.

FIFO means First In, First Out. It follows the order in which stock entered the system.

Base NetSuite does not give every lot item automatic FEFO picking. If you need that rule, check the available tools first.

A NetSuite Developer can help build custom logic when native tools do not fit.

Automated Expiry Alerts

Expired stock can cost your business money. It may also lead to safety issues or upset buyers.

A saved search can help you find lots close to expiry. For example, you can search for lots that expire within 90 days.

You can then review:

• Item name
• Lot number
• Expiry date
• Stock count
• Warehouse location

Send the report to the warehouse team on a set schedule. Staff can then decide whether to move, sell, or remove the goods.

The amount of waste saved depends on how well the team acts on those alerts.

Bin-Level Tracking

Bins show where goods sit inside a warehouse. Advanced Bin/Numbered Inventory Management lets you link lot and serial data to bins.

This means you can track more than the warehouse location. You can also see the aisle, shelf, or bin holding the goods.

For example, a lot may sit in Bin A-12. Staff can find it without searching the whole warehouse.

Bin records also help with picking and stock counts.

Tracking Across the Supply Chain

Lot and serial numbers help you follow goods through their full journey. This starts with receiving and ends with sales, returns, or disposal.

Receiving and Procurement

When you receive goods, record their lot or serial numbers. NetSuite links these numbers to the item receipt.

That receipt also ties back to the purchase order and vendor. If a quality issue comes up, your team can trace the stock to its source.

Warehouse Transfers

Goods often move between warehouse sites. NetSuite can keep lot and serial details during supported transfers.

The records show which goods moved and where they went. This is useful when your business has many storage sites. It also helps you find stock during a recall.

Order Fulfillment

When you ship tracked goods, NetSuite records the lot or serial numbers used. These records link the goods to the related sales transactions.

They help you find which buyers received items from a certain batch. They also help trace goods back to their source.

Oracle offers a Lot and Serial Number Trace SuiteApp for more detailed checks. You can also use saved searches and reports to review the history.

Packing slips and customer portals may need extra setup to show these numbers.

Returns and Warranty Claims

Returns are easier when each item has a clear history. A serial number can help confirm which unit a buyer received. You can then review its sale date and past returns.

Lot numbers help trace defects that affect a whole batch. This makes it easier to find other goods that may have the same problem.

Troubleshooting Common Problems

Even a good setup can run into trouble. Here are common problems and ways to fix them.

Lot or Serial Numbers Not Required on Transactions

A transaction does not ask for a lot or serial number.

Cause: The item may use the wrong item type.
Fix: Check whether the record is a Lot Numbered Inventory Item or Serialized Inventory Item.

These are item types, not just checkboxes. Also check the transaction and item settings.

Can't Select Numbers at Fulfillment

The lot or serial number does not appear when staff try to ship goods.

Cause: The stock may be held at another location. It may also be used, blocked, or missing from available stock.
Fix: Check the item receipt, stock status, and location.

Make sure the number has enough stock for the order. Review any bins or stock rules that may affect the choice.

FEFO Picking Doesn't Work

Staff see lots chosen by receipt date instead of expiry date.

Cause: FEFO may not be set up for that warehouse or item.
Fix: Check NetSuite WMS or the FEFO Lot Assignments SuiteApp.

Review the expiry dates and shelf-life settings. If your process needs special rules, a custom script may help.

Expiration Dates Missing

The lot record exists, but the expiry field is blank.

Cause: Staff may have missed the field during receiving.
Fix: Add the field to the right form and train your staff.

You may also use scripts to require dates for certain items. Check old lots and fill in missing dates where you have valid source records.

Best Practices for Accurate Records

Good lot tracking starts with good habits. These steps help your team keep records clear and useful.

Capture Data at Receipt

Record lot and serial numbers when goods arrive. Check the numbers against the labels.

Do not rely on staff to add them from memory later. This helps keep the stock history accurate.

Standardize Lot Number Formats

Suppliers may use different lot number styles. Some use dates. Others use letters or long codes.

Choose clear rules for how your team enters these values. Keep the supplier's original lot number when it is needed for traceability.

If you use an internal number, keep a link to the supplier number. This makes reports and recall checks easier.

Enable Tracking Before Go-Live

Start a lot and serial tracking before your system goes live. If you add it later, old sales may lack the needed data. That can leave gaps in your stock history.

Plan the item types, forms, and receiving steps early. Test them before your team starts using live records.

Even if you do not use FEFO yet, start recording expiry dates.

Review Old Records

Old lot records can build up over time. Large searches may become harder to use if they pull too much data.

Review your search filters and remove fields you do not need.

Do not delete inventory number records used for stock history. Oracle's documentation explains the rules for these records.

Keep the records needed for audits and future checks.

Train Continuously

Warehouse teams change over time. New staff may not know why lot and serial entry matters.

Add these steps to your training plan. Show staff what can happen when they enter the wrong number.

Short practice tasks can help prevent errors.

Using NetSuite Reports for Inventory Analysis

The data you collect can help you make better stock decisions. NetSuite saved searches and SuiteQL can help you review that data.

Lot Traceability Reports

Build a saved search for a certain item and lot number.

Include useful fields such as:

• Transaction date
• Item and lot number
• Transaction type
• Customer or vendor
• Quantity
• Warehouse location

Use this report when a recall occurs. It can help show where the lot came from and where it went.

For full trace checks, you may need more than one report. Make sure the results cover all relevant transactions.

Near-Expiry Inventory

Create a search for lots that expire soon. You might check the next 30, 60, or 90 days.

Group the results by warehouse or product type. Your team can then review the goods that need action.

This helps staff plan stock moves and reduce waste.

Lot Profitability Analysis

Some lots cost more than others. The price may change because of vendor rates or market costs.

With lot-numbered costing, NetSuite can track costs by lot. You can review those costs alongside sales data.

This helps your team study profit by batch. The exact report depends on your cost method and setup.

Serial Number History

Serial tracking helps you review one unit's past. You can look for its receipt, stock moves, sale, and returns.

This helps service teams answer warranty questions. It also helps staff check whether a returned unit matches company records.

For more detailed work, the SuiteQL Query Tool can help. It lets you pull data from related record types.

How Anchor Group Helps with Lot and Serial Tracking

Effective lot and serial tracking takes more than enabling NetSuite features. Your team needs reliable workflows they can use every day.

At Anchor Group, we help businesses improve their NetSuite inventory and warehouse processes.

How We Help

Our team focuses on practical solutions, including:

• Lot and serial setup: Configure items for accurate stock tracking.
• Receiving workflows: Improve how staff receive and track inventory.
• Reporting: Build reports and identify gaps in existing records.
• Native NetSuite tools: Use built-in features where they fit, avoiding unnecessary custom scripts that require ongoing maintenance.

We assess your business needs before recommending custom code or additional tools.

Implementation and Optimization Support

Whether you're starting fresh or improving an existing system, we can help:

• NetSuite Implementation: Plan lot and serial tracking from the beginning.
• NetSuite Optimization: Review and fix gaps in your current setup.

Have questions about your lot tracking setup? Book a FREE 30-minute NetSuite fix. We'll review your issue and help identify the right next step.

Frequently Asked Questions

What is the difference between serialized and lot-numbered inventory?

Lot-numbered stock tracks goods by batch. Each lot may share a date, supplier, or production run. Serialized stock tracks each unit with its own number. Lot tracking helps with expiry dates and product recalls. Serial tracking helps with warranties and returns. Both methods create useful stock records. Choose the method based on whether you need to trace a batch or one specific unit.

Can NetSuite automatically pick the earliest expiring lots first?

Yes, with the right tools and settings. NetSuite WMS supports FEFO picking. Oracle also offers the FEFO Lot Assignments SuiteApp. FEFO means the lot with the nearest expiry date gets picked first. The SuiteApp can also check shelf-life rules. Basic NetSuite does not apply FEFO to every lot item by default. Review your warehouse needs before choosing a setup.

How do I track expiration dates in NetSuite?

NetSuite has built-in expiry date fields for lot records. First, enable Lot Numbered Inventory. Then create the right lot-numbered item records. When goods arrive, enter each lot number and its expiry date. NetSuite can warn users when a lot nears expiry. Saved searches can also find stock that may expire soon. This helps warehouse staff plan the next steps.

What happens if we skip a lot of entries during receiving?

Missing lot data can cause problems with stock records. NetSuite normally requires a lot of details for tracked items at receipt. If staff use the wrong lot number, future checks may show the wrong history. This can slow down recalls and returns. Train staff to check lot labels before saving receipts. Also review item settings and forms to help stop missing or incorrect data.

Do I need Advanced Bin/Numbered Inventory Management for lot tracking?

No. Basic lot and serial tracking can work without Advanced Bin/Numbered Inventory Management. You can still record lot numbers and track stock by location. The advanced feature adds more control over bins and inventory details. It helps when you need to find stock in a specific warehouse bin. Choose it based on your storage needs. Check your current features before changing the setup.