Browse Business Software Categories

A
B
C
D
E
F
H
I
M
N
P
R
S
W
Close  

Demand Planning

Distribution

ERP

Inventory Management

Supply Chain Management

NetSuite Advanced Inventory Management: Demand Planning, Bins and Lot Control Setup

Sherman Hsieh
Share This Post!
Published
NetSuite Advanced Inventory Management: Demand Planning, Bins and Lot Control Setup

Last updated: November 4, 2026 · Independent guide · We do not sell rankings or coverage.

Inventory management in NetSuite comes in two layers. The base Inventory feature tracks quantities, costs and manual reorder points, while Advanced Inventory Management (AIM) calculates reorder points, preferred stock levels and lead times from your own sales and purchase history, and opens the door to Demand Planning, Supply Planning and bins for lot and serial items. This guide covers what each layer switches on, the setup order and NetSuite’s reorder math, citing Oracle’s help documentation for every step.

Basic inventory vs Advanced Inventory Management

Oracle says inventory management is included with the NetSuite platform license (NetSuite, no date shown), but it markets Advanced Inventory as a separate product covering demand-based replenishment, lots, serials, bins and landed cost (Oracle NetSuite data sheet, no date shown). Oracle does not publish its price.

Capability Base Inventory feature With Advanced Inventory Management
Reorder point and preferred stock level Entered manually on each item Auto-calculated weekly from demand, lead time and safety stock
Lead time Manual Average of the last three fully received purchase orders
Seasonal demand and expected demand change Not available Set per item or as account defaults
Demand Planning and Supply Planning (MRP) Not available Requires AIM to be enabled first
Lot, serial, matrix items, bar codes, multiple units of measure Separate feature boxes Switched on automatically when you enable AIM
Bins, Advanced Bin / Numbered Inventory, Landed Cost Separate feature boxes Accessible, but you enable each one yourself

Table sources: Oracle’s pages on enabling AIM (Oracle NetSuite Help, no date shown) and on item support (Oracle NetSuite Help, no date shown), plus Oracle’s setup pages for Demand Planning (Oracle NetSuite Help, no date shown) and Supply Planning (Oracle NetSuite Help, no date shown). If a feature box is missing from your Enable Features page, ask your account manager whether your contract includes it.

Older partner guides miss one change. Oracle now labels Distribution Resource Planning as part of Time-Phased Planning, “which is no longer supported,” and says it has been replaced by Planning Rules in Supply Planning (MRP) (Oracle NetSuite Help, no date shown). Oracle tells new customers to use Supply Planning (MRP) and existing customers to plan a move from Time-Phased Planning (Oracle NetSuite Help, no date shown).

Before you start

  • License: confirm in writing that Advanced Inventory Management, and Material Requirements Planning if you need multi-location supply planning, are on your subscription.
  • Role: an Administrator role, since every feature in this guide is switched on under Enable Features.
  • Prerequisite features: Inventory (Oracle NetSuite Help, no date shown); Locations and Multi-Location Inventory if you stock more than one site or use Supply Planning (MRP) (Oracle NetSuite Help, no date shown); Work Orders if you plan assemblies (Oracle NetSuite Help, no date shown).
  • History: sales inside the analysis interval and at least three received purchase orders per item, or auto-calculation cannot run.
  • A sandbox: several of these features cannot be switched off once you have transactions, so test there first.

Step 1: Enable Advanced Inventory Management

Go to Setup > Company > Enable Features, open the Items & Inventory subtab, check Advanced Inventory Management and click Save (Oracle NetSuite Help, no date shown).

Oracle states that Lot Tracking cannot be turned off after lot items exist, Serialized Inventory cannot be turned off after serialized items exist, and Multi-Location Inventory cannot be reversed after inventory is distributed without contacting Support (Oracle NetSuite Help, no date shown). Since AIM switches on Lot Tracking and Serialized Inventory, the first numbered item makes them permanent.

Step 2: Set inventory management preferences

Go to Setup > Accounting > Inventory Management Preferences. These defaults apply to both AIM and Demand Planning (Oracle NetSuite Help, no date shown). Oracle documents the following defaults (Oracle NetSuite Help, no date shown):

  • Default Lead Time: 14 days. Lead times are combined across vendors, not tracked per vendor.
  • Default Safety Stock: 7 days of demand.
  • Default Preferred Stock Level: 30 days of demand.
  • Order Analysis Interval: 6 months of history. Seasonal Analysis Interval: 1 month. Estimated Demand Change: 0%.
  • Transactions to Consider: Orders (approved sales and work orders, excluding drop ships) or Actual Sales (cash sales, invoices and builds).
  • Day of Week To Perform Calculation: Sunday at midnight by default; Submit & Calculate adds a one-off run that night.
  • Use Lead Time and Safety Stock per Location: off by default; turn it on if warehouses have different lead times.

Step 3: Set up items for reorder point replenishment

Open an item at Lists > Accounting > Items, click Edit and go to the Purchasing/Inventory subtab. Set Replenishment Method to Reorder Point, then check Auto-Calculate next to Lead Time, Reorder Point and Preferred Stock Level as needed. Enter a Reorder Multiple if your vendor sells in fixed pack quantities, because the Order Items page will then only suggest multiples of that number (Oracle NetSuite Help, no date shown).

Oracle publishes the formulas AIM uses (Oracle NetSuite Help, no date shown):

  • Reorder point = (Demand per Day × Estimated Demand Change × (Lead Time days + Safety Stock days)) + Safety Stock units
  • Preferred stock level = the greater of the reorder point or Demand per Day × Estimated Demand Change × Preferred Stock Level days
  • Demand per day = item quantity on qualifying transactions in the analysis interval, divided by the days in that interval

Illustration (our numbers): a distributor sells 600 cases of a cleaning product in the 6-month window, roughly 3.3 cases a day. With a 10% expected increase, demand is about 3.6 cases a day. With a 12-day lead time and 5 safety stock days, the reorder point is 3.6 × 17, or about 62 cases. With a 30-day preferred stock level, the preferred stock level is about 108 cases. When available stock falls below 62 cases, NetSuite suggests ordering 108 less available stock.

Oracle warns that auto-calculated values can be inaccurate for new items with no sales history. With too little history, NetSuite tries half the interval and otherwise leaves values unchanged. Turn it on later in bulk with Setup > Mass Updates > Mass Updates (Oracle NetSuite Help, no date shown).

Step 4: Add demand and supply planning for seasonal items

For items with uneven demand, check Demand Planning on the Items & Inventory subtab of Enable Features, with AIM already on (Oracle NetSuite Help, no date shown). You calculate a demand plan (Linear Regression, Moving Average, Seasonal Average or Sales Forecast), generate a supply plan of suggested purchase and work orders, and place the orders. Oracle caps Demand Planning runs at 10,000 items at a time (Oracle NetSuite Help, no date shown).

For new projects, set up Supply Planning (MRP) instead of the Time Phased method. Oracle’s steps are to check Locations, Multi-Location Inventory, Advanced Inventory Management and Material Requirements Planning, plus Assembly Items, Advanced Bills of Materials and Work Orders for manufactured items, then set each item’s Replenishment Method to Material Requirements Planning (Oracle NetSuite Help, no date shown).

Step 5: Plan transfers between warehouses

Instead of the retired distribution networks, define transfer planning rules at Lists > Supply Planning > Planning Rule Groups > New. Each rule names the item or category, the receiving location, the source location and the in-transit lead time in days (Oracle NetSuite Help, no date shown). Oracle says these transfer rules take the place of a distribution network in defining how the system creates transfer orders.

Step 6: Set up bins

Check Bin Management on the Items & Inventory subtab, and also Advanced Bin/Numbered Inventory Management if you need bins for lot or serial items or want bins only at some locations (Oracle NetSuite Help, no date shown). Basic bins must be linked to items first and cannot be used on a per-location basis (Oracle NetSuite Help, no date shown).

  1. Set preferences at Setup > Accounting > Preferences > Accounting Preferences, Items/Transactions subtab: Use Preferred Bin on Item Receipts and Require Bins on All Transactions Except Item Receipts (Oracle NetSuite Help, no date shown).
  2. Create bins at Lists > Supply Chain > Bins > New. You cannot change a bin’s location after you save it (Oracle NetSuite Help, no date shown).
  3. On each item, check Use Bins on the Purchasing/Inventory subtab and choose one preferred bin per location (Oracle NetSuite Help, no date shown).
  4. Assign existing stock with the Bin Put-Away Worksheet.

Step 7: Set up lot and serial items

Create lot items at Lists > Accounting > Items > New and choose Inventory Item > Lot Numbered (or Assembly > Lot Numbered). Lot numbered item records track the quantity and specific cost of each lot (Oracle NetSuite Help, no date shown). You cannot convert an existing inventory item into a serialized item, so you must create new item records and move stock to them (Oracle NetSuite Help, no date shown). Choose each item’s costing method before its first receipt; for average costing, review how NetSuite average cost behaves first. For recall and traceability practice beyond NetSuite, see our lot tracking software guide.

Step 8: Place replenishment orders

Go to Transactions > Inventory > Order Items. The page lists items below their reorder point on the Reorder Point Items subtab and planned items on the Time Phased Items subtab. You can filter by location, vendor or minimum quantity. When you submit, NetSuite creates one purchase order per vendor, or one per location if you have multiple locations and do not use the Centralize Purchasing in a Single Location preference (Oracle NetSuite Help, no date shown). Oracle defines the suggested Quantity To Order as preferred stock level less quantity available (Oracle NetSuite Help, no date shown).

Common mistakes and how to fix them

  • Auto-calculated values stay frozen. The item has too little history in the analysis interval. Lengthen the interval or enter manual values. Oracle also notes that AIM ignores transactions dated before you enabled Multi-Location Inventory (Oracle NetSuite Help, no date shown).
  • Demand looks inflated or incomplete. If you use sales orders and standalone invoices or cash sales, Oracle says to set Transactions to Consider to Actual Sales (Oracle NetSuite Help, no date shown).
  • Lead times look wrong. AIM averages the last three purchase orders from order date to final receipt, unweighted by quantity (Oracle NetSuite Help, no date shown), and it does not calculate build times for work orders (Oracle NetSuite Help, no date shown). Override it on slow movers.
  • Lot or serial stock disappears from bins after upgrading to advanced bins. Oracle says these items are not placed in a bin after the upgrade and must be reassigned with a putaway worksheet. Custom scripts written for basic bins also stop working (Oracle NetSuite Help, no date shown).
  • Stock stays stuck in bins after you clear Use Bins. Quantities left in bins do not become available for fulfillment. Empty the bins first with an inventory adjustment per location, as in our NetSuite inventory adjustment guide, then clear the setting (Oracle NetSuite Help, no date shown).

Limitations of the native features

AIM is a weekly batch calculation, not a real-time one, and transactions entered after a run wait for the next run (Oracle NetSuite Help, no date shown). Safety stock is set in days or units, not from a service-level target, and AIM skips kit and item group parents.

Bins track only on-hand and available quantities. Committed, backordered and ordered quantities are not tracked per bin, and item cost is not calculated per bin (Oracle NetSuite Help, no date shown). Mobile receiving-to-shipping workflows, including wave transactions and picking, belong to the separate Warehouse Management feature, which needs the SCM Mobile and Oracle NetSuite WMS SuiteApps (Oracle NetSuite Help, no date shown).

When companies add a third-party tool

Distributors usually add a planning or warehouse tool when they need service-level forecasting instead of fixed days of stock, daily rather than weekly recalculation across many branches, or scanner-driven picking. NetSuite consulting firm BrokenRubik estimates Advanced Inventory at about $500 a month and WMS at $1,000 to $2,000 a month, though Oracle does not publish these prices (BrokenRubik, March 11, 2026). Our inventory replenishment software guide compares the main options.

How we researched this

We read the NetSuite Help Center topics on AIM, Demand Planning, Supply Planning, bins and lot and serial items, and used only menu paths shown there. We also reviewed guides from Anchor Group, BrokenRubik and Cleverence, all of which sell NetSuite services or competing software. We checked all sources on November 4, 2026. Oracle’s help pages show no publication date.

Related guides

Frequently asked questions

Is Advanced Inventory Management included in NetSuite?

Basic inventory tracking is included with the platform license. Oracle markets Advanced Inventory as a separate product and does not publish its price, so check your order form before you plan around it.

How does NetSuite calculate the reorder point?

With auto-calculation on, NetSuite multiplies demand per day by the expected demand change and by lead time days plus safety stock days, then adds any safety stock entered in units. Demand per day comes from your chosen transactions over the analysis interval. The calculation runs weekly.

Do I need Advanced Bin Management for lot-numbered items?

Yes. Basic Bin Management does not support serial or lot-numbered items, and it cannot be used on a per-location basis. Advanced Bin / Numbered Inventory Management adds both and removes the need to link bins to items in advance.

Should I still set up Distribution Resource Planning?

No. Oracle says Distribution Resource Planning is part of Time-Phased Planning, which is no longer supported. Use transfer planning rules in Supply Planning (MRP) instead.

Sources

Sherman Hsieh

CEO & Editor-in-Chief, Business-Software.com
Independent analysis of enterprise software — ERP, CRM and more
Sherman Hsieh is the founder, CEO, and editor-in-chief of Business-Software.com. He leads the site's independent, buyer-focused coverage of ERP, CRM, and other business systems, including vendor-neutral comparisons, pricing analysis, and implementation guidance. Before founding Business-Software.com, Sherman was an executive at Siebel ...

Users Who Read This Article Also Read